June 17, 2005 at 2:23 am
have reporting services installed on both a server and a workstation (on the WS as testconfiguration).
I have used the same SMTP address on both installations (rsreportserver.config), but only the RS installation on the workstation will mail a report. The problem is also that there is no error message coming through to RS on the Server installation. SQL Agent run's the scheduled job without problems.
I suspect it has something do to with rights or the user that is actually trying to create a mail.
Does anyone experienced this problem before or can tell me what things I can check to find the cause of this problem?
June 17, 2005 at 7:14 am
Two things: 1. Test your server with a new subscription with NO attachment or embeded reports, just links, this should work. 2. Check your log files, in particular look for the following word is in the logs -> AuthzInitializeContextFromSid
If the two tests = true, then check out the following link -> http://support.microsoft.com/default.aspx?scid=kb;en-us;842423 which in short tells ou to set the RS service to run under a domain account.
HTH,
Steve.
June 17, 2005 at 7:47 am
Steve,
I have set up a new subscription, only a link, no attachement, but it still does not produce an email. I have also looked at the logfiles but was UNABLE to find the string "AuthzInitializeContextFromSid".
I have included the logfile ReportServerService below. Because I found an error when decrypting the key, I have run rsconfig -c to try to resolve this.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>W. Europe Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerService__06_17_2005_15_25_16.log</Path>
<SystemName>ANYG-FS-3</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!1c8!6/17/2005-15:25:16:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!1c8!6/17/2005-15:25:16:: i INFO: Running on 1 physical processors, 1 logical processors
ReportingServicesService!resourceutilities!1c8!6/17/2005-15:25:16:: i INFO: Reporting Services starting SKU: Enterprise
ReportingServicesService!runningjobs!1c8!6/17/2005-15:25:16:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!1c8!6/17/2005-15:25:16:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!1c8!6/17/2005-15:25:16:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!1c8!6/17/2005-15:25:16:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 38083 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!1c8!6/17/2005-15:25:16:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!crypto!11c!6/17/2005-15:25:16:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!11c!6/17/2005-15:25:16:: i INFO: Exporting public key
ReportingServicesService!crypto!11c!6/17/2005-15:25:16:: i INFO: Performing sku validation
ReportingServicesService!crypto!11c!6/17/2005-15:25:16:: i INFO: Importing existing encryption key
ReportingServicesService!library!11c!6/17/2005-15:25:16:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. ---> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
--- End of inner exception stack trace ---
ReportingServicesService!library!11c!6/17/2005-15:25:16:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. ---> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
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.ServiceController.ServiceStartThread()
ReportingServicesService!library!11c!6/17/2005-15:25:16:: Attempting to start service again...
June 17, 2005 at 7:58 am
I have reset the user using RSCONFIG.EXE. My logfile now displays no errors, BUT ALSO STILL NO MAIL;
<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>W. Europe Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServer__06_17_2005_15_38_42.log</Path>
<SystemName>ANYG-FS-3</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!e58!6/17/2005-15:38:42:: i INFO: Reporting Web Server started
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!e58!6/17/2005-15:38:42:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!resourceutilities!e58!6/17/2005-15:38:42:: i INFO: Running on 1 physical processors, 1 logical processors
w3wp!resourceutilities!e58!6/17/2005-15:38:42:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!runningjobs!e58!6/17/2005-15:38:42:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!e58!6/17/2005-15:38:42:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!e58!6/17/2005-15:38:42:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!e58!6/17/2005-15:38:42:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!898!06/17/2005-15:38:45:: i INFO: Call to GetSystemPermissions
w3wp!crypto!898!06/17/2005-15:38:45:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!898!06/17/2005-15:38:45:: i INFO: Exporting public key
w3wp!crypto!898!06/17/2005-15:38:45:: i INFO: Performing sku validation
w3wp!crypto!898!06/17/2005-15:38:45:: i INFO: Importing existing encryption key
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply