RS2005 - Report Scheduler Error

What does the following error mean and how do I resolve this matter?
ERROR:
'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
SERVICE'. The step failed.I am also experencing this error when the SQL agent tries to execute the step
to run the AddEvent stored procedure which generates the report. The SQL
agent runs under a domain service account which is sa to the SQL server. It
appears that the default owner of SQL Agent jobs is NT AUTHORITY\NETWORK
SERVICE.
We also have a production server running SQL 2000 reporting services with an
identical security configuration. The jobs are invoked on this server with
no isssues.
It seems that the SQL 2005 Agent service account is unable to impersonate
the local network service.
Please advise,
"Terry" wrote:
> What does the following error mean and how do I resolve this matter?
> ERROR:
> 'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
> SERVICE'. The step failed.
>
>

RS2000: Subscriptions "Logon Failed"

Hi,
We get an "Logon Failed" message when running subscriptions;
ReportServer service runs using an domain account. Domain account has
run-as-a-service, logon-locally and "impersonate a client after
authentication" and the apprioriate database rights.
What is the "required privilege" (see below) the reportserver is requiring?
Regards,
Erik Tamminga
ReportingServicesService!library!968!03/08/2006-11:19:11:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
Logon failed., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
Logon failed. --> System.Runtime.InteropServices.COMException (0x80070522):
A required privilege is not held by the client.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
at
Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String
userName, String userPwd, String domain)From here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0lmh.asp
Hope it helps
1.. Decide which accounts to use for Report Server services. Reporting
Services requires three accounts:
2.. Report Server Windows service requires an account to log on to the
local system. Microsoft recommends that you use Local System if you are
installing on Windows 2000. For more information about this recommendation,
see Service Account.
3.. Report Server Web service requires an account to log on to the local
system. Because it is an ASP.NET application, it runs using the ASPNET
account. If you are running Windows 2000, you cannot specify a different
account to use during Setup; you must use the account that is defined for
ASP.NET. If you are running Windows Server 2003, the default is Network
Service, but you can choose to run the service as Local System.
4.. Report Server Web service requires an account to log on to the SQL
Server instance that hosts the report server database. You can specify a
domain account, a SQL Server login, or Local System. You can also use the
credentials that the Report Server Web service uses to log on to the system.
For more information, see Report Server Database Setup.
"Erik Tamminga" <agnimmate@.muimetca.ln_revese_the_previous> wrote in message
news:OcR0JGqQGHA.3896@.TK2MSFTNGP15.phx.gbl...
> Hi,
> We get an "Logon Failed" message when running subscriptions;
> ReportServer service runs using an domain account. Domain account has
> run-as-a-service, logon-locally and "impersonate a client after
> authentication" and the apprioriate database rights.
> What is the "required privilege" (see below) the reportserver is
> requiring?
> Regards,
> Erik Tamminga
> ReportingServicesService!library!968!03/08/2006-11:19:11:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
> Logon failed., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
> Logon failed. --> System.Runtime.InteropServices.COMException
> (0x80070522): A required privilege is not held by the client.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
> String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
> at
> Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String
> userName, String userPwd, String domain)
>|||Thanks Beth,
But; RS is able to start, login to the databases. RS WebApplication works as
expected but only the Subscriptions give me a logon failed when they're
scheduled to run. It seems to have something to do with RS not being able to
render the reports using the account used for subscriptions. Any idears on
how to fix this?
Erik
"Beth" <scratchbakery@.msn.com> wrote in message
news:%23ClUKBtQGHA.3916@.TK2MSFTNGP11.phx.gbl...
> From here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0lmh.asp
> Hope it helps
> 1.. Decide which accounts to use for Report Server services. Reporting
> Services requires three accounts:
> 2.. Report Server Windows service requires an account to log on to the
> local system. Microsoft recommends that you use Local System if you are
> installing on Windows 2000. For more information about this
> recommendation, see Service Account.
> 3.. Report Server Web service requires an account to log on to the local
> system. Because it is an ASP.NET application, it runs using the ASPNET
> account. If you are running Windows 2000, you cannot specify a different
> account to use during Setup; you must use the account that is defined for
> ASP.NET. If you are running Windows Server 2003, the default is Network
> Service, but you can choose to run the service as Local System.
> 4.. Report Server Web service requires an account to log on to the SQL
> Server instance that hosts the report server database. You can specify a
> domain account, a SQL Server login, or Local System. You can also use the
> credentials that the Report Server Web service uses to log on to the
> system. For more information, see Report Server Database Setup.
> "Erik Tamminga" <agnimmate@.muimetca.ln_revese_the_previous> wrote in
> message news:OcR0JGqQGHA.3896@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> We get an "Logon Failed" message when running subscriptions;
>> ReportServer service runs using an domain account. Domain account has
>> run-as-a-service, logon-locally and "impersonate a client after
>> authentication" and the apprioriate database rights.
>> What is the "required privilege" (see below) the reportserver is
>> requiring?
>> Regards,
>> Erik Tamminga
>> ReportingServicesService!library!968!03/08/2006-11:19:11:: e ERROR:
>> Throwing
>> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
>> Logon failed., ;
>> Info:
>> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
>> Logon failed. --> System.Runtime.InteropServices.COMException
>> (0x80070522): A required privilege is not held by the client.
>> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
>> errorCode, IntPtr errorInfo)
>> at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
>> String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
>> at
>> Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String
>> userName, String userPwd, String domain)
>|||Hi Erik,
i think for the subscription to work you need to have Credentials stored
securely in the report server. Subscription will not work for reports which
dont have this stored credentials. When you run the report it will work, but
subscription will not work. The reason is DataSources for that report does
not have stored credentials i.e it has either have windows credential or no
credential. in order that reports have subscrpiton enabled you have to check
the "Credentials stored securely in the report server" and enter the user
name and pwd. you can either enter a sql login or windows login based on the
authentication type. and finally click Apply button to store it. Then do the
subscrpion it will work.
Bava
"Erik Tamminga" wrote:
> Thanks Beth,
> But; RS is able to start, login to the databases. RS WebApplication works as
> expected but only the Subscriptions give me a logon failed when they're
> scheduled to run. It seems to have something to do with RS not being able to
> render the reports using the account used for subscriptions. Any idears on
> how to fix this?
> Erik
> "Beth" <scratchbakery@.msn.com> wrote in message
> news:%23ClUKBtQGHA.3916@.TK2MSFTNGP11.phx.gbl...
> > From here:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0lmh.asp
> > Hope it helps
> > 1.. Decide which accounts to use for Report Server services. Reporting
> > Services requires three accounts:
> > 2.. Report Server Windows service requires an account to log on to the
> > local system. Microsoft recommends that you use Local System if you are
> > installing on Windows 2000. For more information about this
> > recommendation, see Service Account.
> > 3.. Report Server Web service requires an account to log on to the local
> > system. Because it is an ASP.NET application, it runs using the ASPNET
> > account. If you are running Windows 2000, you cannot specify a different
> > account to use during Setup; you must use the account that is defined for
> > ASP.NET. If you are running Windows Server 2003, the default is Network
> > Service, but you can choose to run the service as Local System.
> > 4.. Report Server Web service requires an account to log on to the SQL
> > Server instance that hosts the report server database. You can specify a
> > domain account, a SQL Server login, or Local System. You can also use the
> > credentials that the Report Server Web service uses to log on to the
> > system. For more information, see Report Server Database Setup.
> > "Erik Tamminga" <agnimmate@.muimetca.ln_revese_the_previous> wrote in
> > message news:OcR0JGqQGHA.3896@.TK2MSFTNGP15.phx.gbl...
> >> Hi,
> >>
> >> We get an "Logon Failed" message when running subscriptions;
> >>
> >> ReportServer service runs using an domain account. Domain account has
> >> run-as-a-service, logon-locally and "impersonate a client after
> >> authentication" and the apprioriate database rights.
> >>
> >> What is the "required privilege" (see below) the reportserver is
> >> requiring?
> >>
> >> Regards,
> >>
> >> Erik Tamminga
> >>
> >> ReportingServicesService!library!968!03/08/2006-11:19:11:: e ERROR:
> >> Throwing
> >> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
> >> Logon failed., ;
> >> Info:
> >> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
> >> Logon failed. --> System.Runtime.InteropServices.COMException
> >> (0x80070522): A required privilege is not held by the client.
> >> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> >> errorCode, IntPtr errorInfo)
> >> at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
> >> String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
> >> at
> >> Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String
> >> userName, String userPwd, String domain)
> >>
> >
> >
>
>|||Hi,
Thanks for the reply, but all of my data sources already use stored
credentials (sql-server's sa user, ..., yeah I know ...). So I still think
it has something to do with the win2000 environment and rs supplied
credentials. Have another look at the reported error, it talks about
impersonation, tokens and the windows user/password/domain combo wich are
not used by SQL authenticating data sources.
Regads,
Erik
"Bava Mani" <BavaMani@.discussions.microsoft.com> wrote in message
news:5F64E059-6709-4881-85ED-D9612700BB3B@.microsoft.com...
> Hi Erik,
> i think for the subscription to work you need to have Credentials stored
> securely in the report server. Subscription will not work for reports
> which
> dont have this stored credentials. When you run the report it will work,
> but
> subscription will not work. The reason is DataSources for that report does
> not have stored credentials i.e it has either have windows credential or
> no
> credential. in order that reports have subscrpiton enabled you have to
> check
> the "Credentials stored securely in the report server" and enter the user
> name and pwd. you can either enter a sql login or windows login based on
> the
> authentication type. and finally click Apply button to store it. Then do
> the
> subscrpion it will work.
> Bava
> "Erik Tamminga" wrote:
>> Thanks Beth,
>> But; RS is able to start, login to the databases. RS WebApplication works
>> as
>> expected but only the Subscriptions give me a logon failed when they're
>> scheduled to run. It seems to have something to do with RS not being able
>> to
>> render the reports using the account used for subscriptions. Any idears
>> on
>> how to fix this?
>> Erik
>> "Beth" <scratchbakery@.msn.com> wrote in message
>> news:%23ClUKBtQGHA.3916@.TK2MSFTNGP11.phx.gbl...
>> > From here:
>> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0lmh.asp
>> > Hope it helps
>> > 1.. Decide which accounts to use for Report Server services. Reporting
>> > Services requires three accounts:
>> > 2.. Report Server Windows service requires an account to log on to the
>> > local system. Microsoft recommends that you use Local System if you are
>> > installing on Windows 2000. For more information about this
>> > recommendation, see Service Account.
>> > 3.. Report Server Web service requires an account to log on to the
>> > local
>> > system. Because it is an ASP.NET application, it runs using the ASPNET
>> > account. If you are running Windows 2000, you cannot specify a
>> > different
>> > account to use during Setup; you must use the account that is defined
>> > for
>> > ASP.NET. If you are running Windows Server 2003, the default is Network
>> > Service, but you can choose to run the service as Local System.
>> > 4.. Report Server Web service requires an account to log on to the SQL
>> > Server instance that hosts the report server database. You can specify
>> > a
>> > domain account, a SQL Server login, or Local System. You can also use
>> > the
>> > credentials that the Report Server Web service uses to log on to the
>> > system. For more information, see Report Server Database Setup.
>> > "Erik Tamminga" <agnimmate@.muimetca.ln_revese_the_previous> wrote in
>> > message news:OcR0JGqQGHA.3896@.TK2MSFTNGP15.phx.gbl...
>> >> Hi,
>> >>
>> >> We get an "Logon Failed" message when running subscriptions;
>> >>
>> >> ReportServer service runs using an domain account. Domain account has
>> >> run-as-a-service, logon-locally and "impersonate a client after
>> >> authentication" and the apprioriate database rights.
>> >>
>> >> What is the "required privilege" (see below) the reportserver is
>> >> requiring?
>> >>
>> >> Regards,
>> >>
>> >> Erik Tamminga
>> >>
>> >> ReportingServicesService!library!968!03/08/2006-11:19:11:: e ERROR:
>> >> Throwing
>> >> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
>> >> Logon failed., ;
>> >> Info:
>> >> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
>> >> Logon failed. --> System.Runtime.InteropServices.COMException
>> >> (0x80070522): A required privilege is not held by the client.
>> >> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
>> >> errorCode, IntPtr errorInfo)
>> >> at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
>> >> String pDomain, String pPassword, Boolean bTryRemote, IntPtr&
>> >> pImpToken)
>> >> at
>> >> Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String
>> >> userName, String userPwd, String domain)
>> >>
>> >
>> >
>>|||Hi,
Are you using any custom dataset extension or custom assemblie?
why cant you give a domain\windowuser and pwd and click the check box below
"Use as Windows credentials when connecting to the data source" in the
datasource and try running the report. see if its work.
Bava
"Erik Tamminga" wrote:
> Hi,
> Thanks for the reply, but all of my data sources already use stored
> credentials (sql-server's sa user, ..., yeah I know ...). So I still think
> it has something to do with the win2000 environment and rs supplied
> credentials. Have another look at the reported error, it talks about
> impersonation, tokens and the windows user/password/domain combo wich are
> not used by SQL authenticating data sources.
> Regads,
> Erik
> "Bava Mani" <BavaMani@.discussions.microsoft.com> wrote in message
> news:5F64E059-6709-4881-85ED-D9612700BB3B@.microsoft.com...
> > Hi Erik,
> > i think for the subscription to work you need to have Credentials stored
> > securely in the report server. Subscription will not work for reports
> > which
> > dont have this stored credentials. When you run the report it will work,
> > but
> > subscription will not work. The reason is DataSources for that report does
> > not have stored credentials i.e it has either have windows credential or
> > no
> > credential. in order that reports have subscrpiton enabled you have to
> > check
> > the "Credentials stored securely in the report server" and enter the user
> > name and pwd. you can either enter a sql login or windows login based on
> > the
> > authentication type. and finally click Apply button to store it. Then do
> > the
> > subscrpion it will work.
> >
> > Bava
> >
> > "Erik Tamminga" wrote:
> >
> >> Thanks Beth,
> >>
> >> But; RS is able to start, login to the databases. RS WebApplication works
> >> as
> >> expected but only the Subscriptions give me a logon failed when they're
> >> scheduled to run. It seems to have something to do with RS not being able
> >> to
> >> render the reports using the account used for subscriptions. Any idears
> >> on
> >> how to fix this?
> >>
> >> Erik
> >>
> >> "Beth" <scratchbakery@.msn.com> wrote in message
> >> news:%23ClUKBtQGHA.3916@.TK2MSFTNGP11.phx.gbl...
> >> > From here:
> >> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0lmh.asp
> >> > Hope it helps
> >> > 1.. Decide which accounts to use for Report Server services. Reporting
> >> > Services requires three accounts:
> >> > 2.. Report Server Windows service requires an account to log on to the
> >> > local system. Microsoft recommends that you use Local System if you are
> >> > installing on Windows 2000. For more information about this
> >> > recommendation, see Service Account.
> >> > 3.. Report Server Web service requires an account to log on to the
> >> > local
> >> > system. Because it is an ASP.NET application, it runs using the ASPNET
> >> > account. If you are running Windows 2000, you cannot specify a
> >> > different
> >> > account to use during Setup; you must use the account that is defined
> >> > for
> >> > ASP.NET. If you are running Windows Server 2003, the default is Network
> >> > Service, but you can choose to run the service as Local System.
> >> > 4.. Report Server Web service requires an account to log on to the SQL
> >> > Server instance that hosts the report server database. You can specify
> >> > a
> >> > domain account, a SQL Server login, or Local System. You can also use
> >> > the
> >> > credentials that the Report Server Web service uses to log on to the
> >> > system. For more information, see Report Server Database Setup.
> >> > "Erik Tamminga" <agnimmate@.muimetca.ln_revese_the_previous> wrote in
> >> > message news:OcR0JGqQGHA.3896@.TK2MSFTNGP15.phx.gbl...
> >> >> Hi,
> >> >>
> >> >> We get an "Logon Failed" message when running subscriptions;
> >> >>
> >> >> ReportServer service runs using an domain account. Domain account has
> >> >> run-as-a-service, logon-locally and "impersonate a client after
> >> >> authentication" and the apprioriate database rights.
> >> >>
> >> >> What is the "required privilege" (see below) the reportserver is
> >> >> requiring?
> >> >>
> >> >> Regards,
> >> >>
> >> >> Erik Tamminga
> >> >>
> >> >> ReportingServicesService!library!968!03/08/2006-11:19:11:: e ERROR:
> >> >> Throwing
> >> >> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
> >> >> Logon failed., ;
> >> >> Info:
> >> >> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
> >> >> Logon failed. --> System.Runtime.InteropServices.COMException
> >> >> (0x80070522): A required privilege is not held by the client.
> >> >> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> >> >> errorCode, IntPtr errorInfo)
> >> >> at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
> >> >> String pDomain, String pPassword, Boolean bTryRemote, IntPtr&
> >> >> pImpToken)
> >> >> at
> >> >> Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String
> >> >> userName, String userPwd, String domain)
> >> >>
> >> >
> >> >
> >>
> >>
> >>
>
>

RS service pack 2 installation failed

Hi all,
I tried to install Reporting services service pack 2 on our production
server but it failed before doing any update.
environnement is windows 2000 & framework dotnet 1.1 service pack 1
the same package was successfull on the developpement server - supposed to
be the same environnement.
The logfile shows an error 1635 and it seem to be linked to a file
sp1patch.msp
I could not find anything usefull on the net
Thanks in advance for any help
because we are using in our report one of the feature that cannot work
without the service pack 2.
herefater the log trace :
-----
=== Verbose logging started: 10/28/2005 19:05:40 Build type: SHIP UNICODE
3.01.4000.2435 Calling process:
e:\6704fbb7257fc7f7594ebb9e1cf255b8\sp2setup.exe === MSI (c) (94:58) [19:05:40:481]: Resetting cached policy values
MSI (c) (94:58) [19:05:40:481]: Machine policy value 'Debug' is 0
MSI (c) (94:58) [19:05:40:481]: ******* RunEngine:
******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
******* Action:
******* CommandLine: **********
MSI (c) (94:58) [19:05:40:481]: Client-side and UI is none or basic: Running
entire install on the server.
MSI (c) (94:58) [19:05:40:481]: Grabbed execution mutex.
MSI (c) (94:58) [19:05:40:590]: Cloaking enabled.
MSI (c) (94:58) [19:05:40:590]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (94:58) [19:05:40:621]: Incrementing counter to disable shutdown.
Counter after increment: 0
MSI (s) (A8:0C) [19:05:40:668]: Grabbed execution mutex.
MSI (s) (A8:E0) [19:05:40:668]: Resetting cached policy values
MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'Debug' is 0
MSI (s) (A8:E0) [19:05:40:668]: ******* RunEngine:
******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
******* Action:
******* CommandLine: **********
MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'DisableUserInstalls'
is 0
MSI (s) (A8:E0) [19:05:40:684]: Warning: Local cached package
'C:\W2TP\Installer\ba2813.msi' is missing.
MSI (s) (A8:E0) [19:05:40:684]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (A8:E0) [19:05:40:684]: User policy value 'DisableMedia' is 0
MSI (s) (A8:E0) [19:05:40:684]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media enabled only if package is
safe.
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Looking for sourcelist for
product {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Adding
{33FE9EED-1976-4A51-A7AF-332D9BBB9400}; to potential sourcelist list
(pcode;disk;relpath).
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Now checking product
{33FE9EED-1976-4A51-A7AF-332D9BBB9400}
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media is enabled for product.
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Attempting to use LastUsedSource
from source list.
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Trying source
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
MSI (s) (A8:E0) [19:05:40:856]: Entering
CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (A8:E0) [19:05:40:856]: Specifed source is already in a list.
MSI (s) (A8:E0) [19:05:40:856]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'DisableBrowse' is 0
MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'AllowLockdownBrowse'
is 0
MSI (s) (A8:E0) [19:05:40:856]: Adding new sources is allowed.
MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedSource to:
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedType to: n.
MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedIndex to: 1.
MSI (s) (A8:E0) [19:05:40:871]: SOURCEMGMT: Resolved source to:
'D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\'
MSI (s) (A8:E0) [19:05:40:918]: File will have security applied from OpCode.
MSI (s) (A8:E0) [19:05:41:215]: End dialog not enabled
MSI (s) (A8:E0) [19:05:41:215]: Original package ==>
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
MSI (s) (A8:E0) [19:05:41:215]: Package we're running from ==>
C:\W2TP\Installer\cbc12.msi
MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{33FE9EED-1976-4A51-A7AF-332D9BBB9400}'.
MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: no matching ProductCode found in
database.
MSI (s) (A8:E0) [19:05:41:418]: MSCOREE not loaded loading copy from system32
MSI (s) (A8:E0) [19:05:41:512]: Opening existing patch
'C:\W2TP\Installer\ba290c.msp'.
MSI (s) (A8:E0) [19:05:41:512]: Note: 1: 2203 2:
C:\W2TP\Installer\ba290c.msp 3: -2147287038
MSI (s) (A8:E0) [19:05:41:512]: Couldn't find local patch
'C:\W2TP\Installer\ba290c.msp'. Looking for it at its source.
MSI (s) (A8:E0) [19:05:41:512]: Resolving Patch source.
MSI (s) (A8:E0) [19:05:41:512]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media enabled only if package is
safe.
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Looking for sourcelist for
product {813A147C-2328-4439-9D40-1486308CB952}
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Adding
{813A147C-2328-4439-9D40-1486308CB952}; to potential sourcelist list
(pcode;disk;relpath).
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Now checking product
{813A147C-2328-4439-9D40-1486308CB952}
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media is enabled for product.
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Attempting to use LastUsedSource
from source list.
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Processing net source list.
MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Trying source
e:\3d0526d9dd77e601344dcc338f4f\.
MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 2203 2:
e:\3d0526d9dd77e601344dcc338f4f\sp1patch.msp 3: -2147287037
MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Source is invalid due to
missing/inaccessible package.
MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 1706 2: -2147483647 3: sp1patch.msp
MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Processing media source list.
MSI (s) (A8:E0) [19:05:42:652]: SOURCEMGMT: Resolved source to: 'sp1patch.msp'
MSI (s) (A8:E0) [19:06:49:199]: Note: 1: 1314 2: sp1patch.msp
MSI (s) (A8:E0) [19:06:49:199]: Unable to create a temp copy of patch
'sp1patch.msp'.
This patch package could not be opened. Verify that the patch package
exists and that you can access it, or contact the application vendor to
verify that this is a valid Windows Installer patch package.
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 1708
MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 2729
MSI (s) (A8:E0) [19:06:49:309]: Note: 1: 2729
MSI (s) (A8:E0) [19:06:49:324]: Product: Microsoft SQL Server 2000 Reporting
Services Enterprise Edition -- Installation failed.
MSI (s) (A8:E0) [19:06:49:340]: MainEngineThread is returning 1635
MSI (c) (94:58) [19:06:49:356]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (94:58) [19:06:49:356]: MainEngineThread is returning 1635
=== Verbose logging stopped: 10/28/2005 19:06:49 ===Hello all
I am still without solution for my trouble describe here after.
Is there any additional inforamtion that could be require to identify the
trouble
Thanks if anyone can help about it
Dominique
"dominique deboise" wrote:
> Hi all,
> I tried to install Reporting services service pack 2 on our production
> server but it failed before doing any update.
> environnement is windows 2000 & framework dotnet 1.1 service pack 1
> the same package was successfull on the developpement server - supposed to
> be the same environnement.
>
> The logfile shows an error 1635 and it seem to be linked to a file
> sp1patch.msp
> I could not find anything usefull on the net
> Thanks in advance for any help
> because we are using in our report one of the feature that cannot work
> without the service pack 2.
>
> herefater the log trace :
> -----
> === Verbose logging started: 10/28/2005 19:05:40 Build type: SHIP UNICODE
> 3.01.4000.2435 Calling process:
> e:\6704fbb7257fc7f7594ebb9e1cf255b8\sp2setup.exe ===> MSI (c) (94:58) [19:05:40:481]: Resetting cached policy values
> MSI (c) (94:58) [19:05:40:481]: Machine policy value 'Debug' is 0
> MSI (c) (94:58) [19:05:40:481]: ******* RunEngine:
> ******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> ******* Action:
> ******* CommandLine: **********
> MSI (c) (94:58) [19:05:40:481]: Client-side and UI is none or basic: Running
> entire install on the server.
> MSI (c) (94:58) [19:05:40:481]: Grabbed execution mutex.
> MSI (c) (94:58) [19:05:40:590]: Cloaking enabled.
> MSI (c) (94:58) [19:05:40:590]: Attempting to enable all disabled priveleges
> before calling Install on Server
> MSI (c) (94:58) [19:05:40:621]: Incrementing counter to disable shutdown.
> Counter after increment: 0
> MSI (s) (A8:0C) [19:05:40:668]: Grabbed execution mutex.
> MSI (s) (A8:E0) [19:05:40:668]: Resetting cached policy values
> MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'Debug' is 0
> MSI (s) (A8:E0) [19:05:40:668]: ******* RunEngine:
> ******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> ******* Action:
> ******* CommandLine: **********
> MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'DisableUserInstalls'
> is 0
> MSI (s) (A8:E0) [19:05:40:684]: Warning: Local cached package
> 'C:\W2TP\Installer\ba2813.msi' is missing.
> MSI (s) (A8:E0) [19:05:40:684]: User policy value 'SearchOrder' is 'nmu'
> MSI (s) (A8:E0) [19:05:40:684]: User policy value 'DisableMedia' is 0
> MSI (s) (A8:E0) [19:05:40:684]: Machine policy value 'AllowLockdownMedia' is 0
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media enabled only if package is
> safe.
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Looking for sourcelist for
> product {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Adding
> {33FE9EED-1976-4A51-A7AF-332D9BBB9400}; to potential sourcelist list
> (pcode;disk;relpath).
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Now checking product
> {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media is enabled for product.
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Attempting to use LastUsedSource
> from source list.
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Trying source
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
> MSI (s) (A8:E0) [19:05:40:856]: Entering
> CMsiConfigurationManager::SetLastUsedSource.
> MSI (s) (A8:E0) [19:05:40:856]: Specifed source is already in a list.
> MSI (s) (A8:E0) [19:05:40:856]: User policy value 'SearchOrder' is 'nmu'
> MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'DisableBrowse' is 0
> MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'AllowLockdownBrowse'
> is 0
> MSI (s) (A8:E0) [19:05:40:856]: Adding new sources is allowed.
> MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedSource to:
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
> MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedType to: n.
> MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedIndex to: 1.
> MSI (s) (A8:E0) [19:05:40:871]: SOURCEMGMT: Resolved source to:
> 'D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\'
> MSI (s) (A8:E0) [19:05:40:918]: File will have security applied from OpCode.
> MSI (s) (A8:E0) [19:05:41:215]: End dialog not enabled
> MSI (s) (A8:E0) [19:05:41:215]: Original package ==>
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
> MSI (s) (A8:E0) [19:05:41:215]: Package we're running from ==>
> C:\W2TP\Installer\cbc12.msi
> MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: looking for appcompat database
> entry with ProductCode '{33FE9EED-1976-4A51-A7AF-332D9BBB9400}'.
> MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: no matching ProductCode found in
> database.
> MSI (s) (A8:E0) [19:05:41:418]: MSCOREE not loaded loading copy from system32
> MSI (s) (A8:E0) [19:05:41:512]: Opening existing patch
> 'C:\W2TP\Installer\ba290c.msp'.
> MSI (s) (A8:E0) [19:05:41:512]: Note: 1: 2203 2:
> C:\W2TP\Installer\ba290c.msp 3: -2147287038
> MSI (s) (A8:E0) [19:05:41:512]: Couldn't find local patch
> 'C:\W2TP\Installer\ba290c.msp'. Looking for it at its source.
> MSI (s) (A8:E0) [19:05:41:512]: Resolving Patch source.
> MSI (s) (A8:E0) [19:05:41:512]: User policy value 'SearchOrder' is 'nmu'
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media enabled only if package is
> safe.
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Looking for sourcelist for
> product {813A147C-2328-4439-9D40-1486308CB952}
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Adding
> {813A147C-2328-4439-9D40-1486308CB952}; to potential sourcelist list
> (pcode;disk;relpath).
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Now checking product
> {813A147C-2328-4439-9D40-1486308CB952}
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media is enabled for product.
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Attempting to use LastUsedSource
> from source list.
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Processing net source list.
> MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Trying source
> e:\3d0526d9dd77e601344dcc338f4f\.
> MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 2203 2:
> e:\3d0526d9dd77e601344dcc338f4f\sp1patch.msp 3: -2147287037
> MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Source is invalid due to
> missing/inaccessible package.
> MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 1706 2: -2147483647 3: sp1patch.msp
> MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Processing media source list.
> MSI (s) (A8:E0) [19:05:42:652]: SOURCEMGMT: Resolved source to: 'sp1patch.msp'
> MSI (s) (A8:E0) [19:06:49:199]: Note: 1: 1314 2: sp1patch.msp
> MSI (s) (A8:E0) [19:06:49:199]: Unable to create a temp copy of patch
> 'sp1patch.msp'.
> This patch package could not be opened. Verify that the patch package
> exists and that you can access it, or contact the application vendor to
> verify that this is a valid Windows Installer patch package.
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
> MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 1708
> MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 2729
> MSI (s) (A8:E0) [19:06:49:309]: Note: 1: 2729
> MSI (s) (A8:E0) [19:06:49:324]: Product: Microsoft SQL Server 2000 Reporting
> Services Enterprise Edition -- Installation failed.
> MSI (s) (A8:E0) [19:06:49:340]: MainEngineThread is returning 1635
> MSI (c) (94:58) [19:06:49:356]: Decrementing counter to disable shutdown. If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> MSI (c) (94:58) [19:06:49:356]: MainEngineThread is returning 1635
> === Verbose logging stopped: 10/28/2005 19:06:49 ===>

RS doesn't works under ASP.NET 2.0?

Hi,
when I switch my reportserver virtual folder to the ASp.net2.0 I receive
this error:
"Failed to load expression host assembly"
this error appears only when I try to render a report, I can list reports or
I can access the webservice without any error.
any solution?
thanks.
Jerome.RS 2000 is not a ASP.Net 2.0 app. It uses the 1.1 framework. RS 2005 is a
ASP.Net 2.0 app.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23ndrIwI9FHA.1332@.tk2msftngp13.phx.gbl...
> Hi,
> when I switch my reportserver virtual folder to the ASp.net2.0 I receive
> this error:
> "Failed to load expression host assembly"
> this error appears only when I try to render a report, I can list reports
> or I can access the webservice without any error.
> any solution?
> thanks.
> Jerome.
>|||I know, but, for example Sharepoint works fine under ASP.NET 2.0 and its a
1.1 software.
but if I switch the reportserver virtual directory from v1.1 to v2.0,
rendering a report stop working.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%232wwe4P9FHA.1248@.TK2MSFTNGP14.phx.gbl...
> RS 2000 is not a ASP.Net 2.0 app. It uses the 1.1 framework. RS 2005 is a
> ASP.Net 2.0 app.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:%23ndrIwI9FHA.1332@.tk2msftngp13.phx.gbl...
>> Hi,
>> when I switch my reportserver virtual folder to the ASp.net2.0 I receive
>> this error:
>> "Failed to load expression host assembly"
>> this error appears only when I try to render a report, I can list reports
>> or I can access the webservice without any error.
>> any solution?
>> thanks.
>> Jerome.
>>
>|||If you want RS to work, leave it alone at 1.1 or upgrade to RS 2005. Note
that you can leave SQL Server as 2000 and still upgrade RS to 2005. You do
need a 2005 license though. Beside additional features I noticed significant
performance improvements with RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:OrI6xeR9FHA.500@.TK2MSFTNGP15.phx.gbl...
>I know, but, for example Sharepoint works fine under ASP.NET 2.0 and its a
>1.1 software.
> but if I switch the reportserver virtual directory from v1.1 to v2.0,
> rendering a report stop working.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%232wwe4P9FHA.1248@.TK2MSFTNGP14.phx.gbl...
>> RS 2000 is not a ASP.Net 2.0 app. It uses the 1.1 framework. RS 2005 is a
>> ASP.Net 2.0 app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
>> news:%23ndrIwI9FHA.1332@.tk2msftngp13.phx.gbl...
>> Hi,
>> when I switch my reportserver virtual folder to the ASp.net2.0 I receive
>> this error:
>> "Failed to load expression host assembly"
>> this error appears only when I try to render a report, I can list
>> reports or I can access the webservice without any error.
>> any solution?
>> thanks.
>> Jerome.
>>
>>
>