rsactivate returns error, unable to activate error

Failure starting the web service:
Unexpected database error (-2147159548) 0x80004002Hi, possibly your configuration is bad, try runnig, rsconfig.exe with the
new parameters and then try with this again, in most cases this problem is
for bad configuration.
"hcas" wrote:
> Failure starting the web service:
> Unexpected database error (-2147159548) 0x80004002|||Hi, the problem is because the ASPNet is not reg over IIS, with this command
you can repair this.
c> "%windir%\Microsoft.NET\Framework\v1.0.375\aspnet_regiis.exe" -i
regsvr32 %windir%\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
the aspnet_regiis.exe is a command of .net Framework
Best Regards
John Bocachica
Colombia|||HI John:
I have already tried quite a few different rsconfig.exe settings and users
with no luck. I also re-registered aspnet (I am using a higher version,
1.1.4322) and its dll. The same error occurs when I attempt to use the
rsactivate command. If I use the server name as opposed to the config file,
I get the following error.
Failure initializing remote NT Service:
Unexpected database error (-2147159548) 0x80004002
"John Bocachica" wrote:
> Hi, the problem is because the ASPNet is not reg over IIS, with this command
> you can repair this.
> c> "%windir%\Microsoft.NET\Framework\v1.0.375\aspnet_regiis.exe" -i
> regsvr32 %windir%\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
> the aspnet_regiis.exe is a command of .net Framework
> Best Regards
> John Bocachica
> Colombia

RSActivate Error

I am getting the following error when attempting to run RSActivate to add a
server to a web farm:
Failure starting the web service:
The local NT service is not activated
The log file contains the following entries:
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
Activating web service via RPC.
w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()What error do you see in the Windows service log file?
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> I am getting the following error when attempting to run RSActivate to add
a
> server to a web farm:
> Failure starting the web service:
> The local NT service is not activated
> The log file contains the following entries:
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> Activating web service via RPC.
> w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
Int32
> clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services error
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
Int32
> clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>|||Here is what I see in the Windows service log file:
ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: Exporting
public key
ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: NT Service
not activated
ReportingServicesService!library!764!8/17/2004-10:29:51:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information.
ReportingServicesService!library!764!8/17/2004-10:29:51:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information.
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!764!8/17/2004-10:29:51:: Attempting to
start service again...
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:O0xHpDIhEHA.3540@.TK2MSFTNGP10.phx.gbl...
> What error do you see in the Windows service log file?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
> news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> > I am getting the following error when attempting to run RSActivate to
add
> a
> > server to a web farm:
> >
> > Failure starting the web service:
> > The local NT service is not activated
> >
> > The log file contains the following entries:
> >
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as
user:
> > NT AUTHORITY\NETWORK SERVICE
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> > Activating web service via RPC.
> > w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information., ;
> > Info:
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information. -->
> > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
mainError,
> > Int32 extendedError)
> > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32
> > clientType)
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > -- End of inner exception stack trace --
> > w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services
error
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information. -->
> > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
mainError,
> > Int32 extendedError)
> > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32
> > clientType)
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > at Microsoft.ReportingServices.Library.Storage.get_Connection()
> > at
> > Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> > storedProcedureName)
> > at
> >
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> > ng key)
> > at
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> > (String name)
> > at
> Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > name)
> > at
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> > ng name)
> > at
Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> > at
Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> > source)
> > at
> >
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path, Boolean validate, Boolean convert, Boolean translate)
> > at
> >
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path)
> > at
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> > tent()
> > at
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> >
> >
>|||Are you reusing a database from a previous installation? It looks like the
windows service is not activating automatically because it thinks another
report server is using the database. If this is not the case, you can clear
out the old entries by running rskeymgmt -d, then restart the windows and
web service.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:upNDrRJhEHA.3980@.TK2MSFTNGP12.phx.gbl...
> Here is what I see in the Windows service log file:
> ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: NT
Service
> not activated
> ReportingServicesService!library!764!8/17/2004-10:29:51:: e ERROR:
Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information.
> ReportingServicesService!library!764!8/17/2004-10:29:51:: Exception caught
> while starting service. Error:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information.
> at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!764!8/17/2004-10:29:51:: Attempting to
> start service again...
>
> "Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
> news:O0xHpDIhEHA.3540@.TK2MSFTNGP10.phx.gbl...
> > What error do you see in the Windows service log file?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
> > news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> > > I am getting the following error when attempting to run RSActivate to
> add
> > a
> > > server to a web farm:
> > >
> > > Failure starting the web service:
> > > The local NT service is not activated
> > >
> > > The log file contains the following entries:
> > >
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as
> user:
> > > NT AUTHORITY\NETWORK SERVICE
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not
activated
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> > > Activating web service via RPC.
> > > w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information., ;
> > > Info:
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information. -->
> > > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
> mainError,
> > > Int32 extendedError)
> > > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> > Int32
> > > clientType)
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > -- End of inner exception stack trace --
> > > w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services
> error
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information. -->
> > > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
> mainError,
> > > Int32 extendedError)
> > > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> > Int32
> > > clientType)
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > -- End of inner exception stack trace --
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > at
> > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > > at
> > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > > at Microsoft.ReportingServices.Library.Storage.get_Connection()
> > > at
> > >
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> > > storedProcedureName)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> > > ng key)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> > > (String name)
> > > at
> > Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > > name)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> > > ng name)
> > > at
> Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> > > at
> Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> > > source)
> > > at
> > >
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > > path, Boolean validate, Boolean convert, Boolean translate)
> > > at
> > >
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > > path)
> > > at
> > >
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> > > tent()
> > > at
> > >
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> > >
> > >
> >
> >
>

RS2000: Failure sending mail: Cannot access a closed file...

SQL Server 2000, RS2000...
I have 2 timed subscriptions to the same report. One of the
subscriptions delivers the report via Report Server Email, the other
via File share.
If I choose PDF orWeb Archive as the deliverable then then both
reports work. If I choose Excel, I get the following error message
posted on the Report Server next to Status when I look at both
subscriptions to the report.
Any idea what is happening?
Thanks,
KeithOn Feb 1, 5:29 pm, 1300...@.gmail.com wrote:
> SQL Server 2000, RS2000...
> I have 2 timed subscriptions to the same report. One of the
> subscriptions delivers the report via Report Server Email, the other
> via File share.
> If I choose PDF orWeb Archive as the deliverable then then both
> reports work. If I choose Excel, I get the following error message
> posted on the Report Server next to Status when I look at both
> subscriptions to the report.
Guess including the error might help!
Failure sending mail: Cannot access a closed file
> Any idea what is happening?
> Thanks,
> Keith

RS Subscription Failures

RS Subscriptions are generating the following errors for some (not all)
subscriptions:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files
The only difference I can see between our working subscriptions and the non
working subscriptions are the owners of the subscriptions.
A log file I was able to find with a failed email reference is as follows.
ReportingServicesService!dbpolling!25f4!4/18/2005-02:00:13::
NotificationPolling processing 1 more items. 2 Total items in internal
queue.
ReportingServicesService!library!27e4!04/18/2005-02:00:14:: i INFO: Call to
RenderFirst( '/Production Systems' )
ReportingServicesService!library!27e4!04/18/2005-02:00:15:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason -
service account doesn't have rights to check domain user SIDs.;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!27e4!04/18/2005-02:00:15:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!27e4!04/18/2005-02:00:15:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage
message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification
notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
notification)
ReportingServicesService!notification!27e4!04/18/2005-02:00:15::
Notification 75812118-974c-4618-98b1-5327eb230d09 completed. Success:
False, Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension:
Report Server Email, Report: Production Systems, Attempt 0
ReportingServicesService!dbpolling!27e4!04/18/2005-02:00:15::
NotificationPolling finished processing item
75812118-974c-4618-98b1-5327eb230d09
ReportingServicesService!library!1ef8!04/18/2005-02:00:23:: i INFO:
Initializing SessionTimeout to '600' second(s) as specified in Server system
properties.
ReportingServicesService!library!1ef8!04/18/2005-02:00:23:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1ef8!04/18/2005-02:00:26:: Email
successfully sent to "someone@.x.com" <someone@.x.com>
ReportingServicesService!notification!1ef8!04/18/2005-02:00:26::
Notification 7f32758e-2511-4a4d-8ac2-f91c31691db7 completed. Success: True,
Status: Mail sent to someone@.x.com, DeliveryExtension: Report Server Email,
Report: Production Systems, Attempt 0
ReportingServicesService!dbpolling!1ef8!04/18/2005-02:00:26::
NotificationPolling finished processing item
7f32758e-2511-4a4d-8ac2-f91c31691db7
Any help would be greatly appreciated. Thanks!
BrentHi Brent,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood your Reporting Services' subscription
is not able to send email as you expected. If I have misunderstood your
concern, please feel free to point it out.
According to the error message, I think there might be something wrong with
your configuration file. Please compare rsreportserver.config file in your
working subscriptions machine and non working subscriptions machine. You
may also post the file here and let's check the parameter
You could refer the MSDN Online or RS BooksOnline for detailed information
Configuring a Report Server for E-Mail Delivery
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
/arp_configserver_v1_4bzl.asp
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||This is one RS Server. Subscriptions that I subscribe to work perfectly, and
have been working perfectly. Subscriptions that other users subscribe to are
failing on the same server. I've reviewed the BOL, but this appears to be
configured properly. Below is the .config file:
<Configuration>
<Dsn>removed encrypted for this post</Dsn>
<ConnectionType>Default</ConnectionType>
<LogonUser>removed encrypted for this post</LogonUser>
<LogonDomain>removed encrypted for this post</LogonDomain>
<LogonCred>removed encrypted for this post</LogonCred>
<InstanceId>MSSQL.1</InstanceId>
<InstallationID>{6435f6bb-db14-43d3-b565-ccd72a245bd3}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="InstanceName" Value="MSSQLSERVER"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://SDBMSP-CTC01/ReportServer</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
</Service>
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smarthost.fnfinc.com</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>brent@.nospam.nospam</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
<Extension Name="IMAGE"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="HTML4.0"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="MHTML"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
<Extension Name="HTMLOWC"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering">
<Configuration>
<OWCConfiguration>
<OWCDownloadLocation
language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation>
</OWCConfiguration>
</Configuration>
</Extension>
</Render>
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
</Data>
<Security>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,
Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
Microsoft.ReportingServices.Authorization"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension"
Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
<Event>
<Type>ReportHistorySnapshotCreated</Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension"
Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
<Event>
<Type>TimedSubscription</Type>
</Event>
</Extension>
<Extension Name="Cache Update Extension"
Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
<Event>
<Type>SnapshotUpdated</Type>
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
"Michael Cheng [MSFT]" wrote:
> Hi Brent,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood your Reporting Services' subscription
> is not able to send email as you expected. If I have misunderstood your
> concern, please feel free to point it out.
> According to the error message, I think there might be something wrong with
> your configuration file. Please compare rsreportserver.config file in your
> working subscriptions machine and non working subscriptions machine. You
> may also post the file here and let's check the parameter
> You could refer the MSDN Online or RS BooksOnline for detailed information
> Configuring a Report Server for E-Mail Delivery
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> /arp_configserver_v1_4bzl.asp
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Brent,
Thanks for your prompt update and sorry for my lateness!
I looked into your Reporting Services log and found the following entry
--
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
The Report Server has encountered a configuration error; more details in
the
log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason -
service account doesn't have rights to check domain user SIDs.;
--
Based on my knowledge, when your Reporting Services is running under
Windows Server 2003 and your Reporting Services and SQL Server are both
running under domain user account, you should apply the hotfix in the
following KB
"The specified domain either does not exist or could not be contacted"
error message in Windows Server 2003
http://support.microsoft.com/kb/834859
You may also apply Windows Server 2003 Service Pack 1, within which, I
believe this hotfix had been included
http://www.microsoft.com/downloads/details.aspx?FamilyID=22cfc239-337c-4d81-
8354-72593b1c1f43&DisplayLang=en
NOTE that it will be a FREE/REFUND case if you only asking for hotfix.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.