| Groups | Blog | Home |
sql server reporting services : SQL Server 2005 Reporting Services Logon issue
I have set up an installation of Reporting Services on a WIndows 2003
(Standard) server. I've applied sp1 and the cumulative hotfix. The Reporting Services service runs under a domain (admin) account. I can connect to the server and deploy reports, however when I run a report I get this error: Logon failed. For more information about this error navigate to the report server on the local server machine, or enable remote errors When designing the report I can preview it, and all seems fine. The IIS app pool runs under the Network Services account. I am at a loss as to why I'm getting this error - the connection for the datasource is set up with correct credentials..... Any help would be appreciated,
Wei,
Here's the entire message when I run the report: Logon failed. Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Latest Log: <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product> <Locale>en-US</Locale> <TimeZone>Eastern Daylight Time</TimeZone> <Path>C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServerService__08_09_2006_19_56_50.log</Path> <SystemName>CLAUDIA</SystemName> <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName> <OSVersion>5.2.3790.65536</OSVersion> </Header> ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:50:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. ReportingServicesService!library!9!8/9/2006-19:56:51:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. ReportingServicesService!resourceutilities!9!8/9/2006-19:56:51:: i INFO: Reporting Services starting SKU: Standard ReportingServicesService!resourceutilities!9!8/9/2006-19:56:51:: i INFO: Evaluation copy: 0 days left ReportingServicesService!resourceutilities!9!8/9/2006-19:56:51:: i INFO: Running on 1 physical processors, 2 logical processors ReportingServicesService!runningjobs!9!8/9/2006-19:56:51:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds ReportingServicesService!runningjobs!9!8/9/2006-19:56:51:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds ReportingServicesService!runningjobs!9!8/9/2006-19:56:51:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds ReportingServicesService!runningjobs!9!8/9/2006-19:56:51:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 21788 seconds. Cycle: 86400 seconds ReportingServicesService!runningjobs!9!8/9/2006-19:56:51:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds ReportingServicesService!runningjobs!9!8/9/2006-19:56:51:: i INFO: SQM timer timer enabled: Next Event: 25388 seconds. Cycle: 86400 seconds ReportingServicesService!library!11!8/9/2006-19:56:51:: i INFO: Catalog SQL Server Edition = Standard ReportingServicesService!crypto!11!8/9/2006-19:56:51:: i INFO: Initializing crypto as user: MSAA\ttucker ReportingServicesService!crypto!11!8/9/2006-19:56:51:: i INFO: Exporting public key ReportingServicesService!crypto!11!8/9/2006-19:56:51:: i INFO: Performing sku validation ReportingServicesService!crypto!11!8/9/2006-19:56:51:: i INFO: Importing existing encryption key ReportingServicesService!dbpolling!11!08/09/2006-19:56:51:: EventPolling polling service started ReportingServicesService!dbpolling!11!08/09/2006-19:56:51:: NotificationPolling polling service started
Hi Tom,
Please modify the credential of the Datasource in the Reporting Manager to be a consisted user. If this does not help, please send all the reporting services log files to me. You may zip the folder and send to me directly. I understand the information may be sensitive to you, my direct email address is weilu@ONLINE.microsoft.com ( Please remove ONLINE when you send the email ), you may send the file to me directly and I will keep it secure.. Sincerely, Wei Lu Microsoft Online Community Support
Hello Tom,
Would you please try to login to the Report Server and run the report? I would like to know the detailed error message to troubleshoot. Also, you could access the report log to check what's the exactly problem is. By default, the log file is located at \Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles. You could post the latest log file here for me to troubleshoot. Please let me know the information so that I can provide further assistance. Sincerely, Wei Lu Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== (This posting is provided "AS IS", with no warranties, and confers no rights.)
Hi Wei,
Not sure what you mean by a consisted user..... [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hi Tom, > > Please modify the credential of the Datasource in the Reporting Manager to > be a consisted user. > > If this does not help, please send all the reporting services log files to > me. > > You may zip the folder and send to me directly. I understand the > information may be sensitive to you, my direct email address is > weilu@ONLINE.microsoft.com ( Please remove ONLINE when you send the email > ), you may send the file to me directly and I will keep it secure.. > > Sincerely, > > Wei Lu > > Microsoft Online Community Support >
Hi Tom,
I means you could modify the credential to be a fixed user. For example, the sa account. Please let me know the result. Sincerely, Wei Lu Microsoft Online Community Support
Tried the sa account, as well as a domain admin account, neither of which
worked. Thanks [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hi Tom, > > I means you could modify the credential to be a fixed user. For example, > the sa account. Please let me know the result. > > Sincerely, > > Wei Lu > > Microsoft Online Community Support >
Hi Tom,
If you try to access the Report Server http://<server name>/ReportServer, does any error appear? Also, if you try to run the rsconfig utility to connect to the reportserver database by using the domain admin account, does this issue appeared? rsconfig Utility http://msdn2.microsoft.com/en-us/library/ms162837.aspx Hope this will be helpful! Sincerely, Wei Lu Microsoft Online Community Support
Wei,
I can access the report server and see a list of reports, data sources etc. I do have keep resetting the permissions on the windows\temp folder, and windows\microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files for the network service account - for some reason the permissions settings for these gets reset periodically. However, once reset, I can access the report server as you asked. I was also able to connect via the rsconfig utility. When designing a report/datasource in VS 2005, the preview works fine. However, after deploying I get the Logon failed. Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) message. If I change the credentials for the datasource on the report server to be another account, e.g. sa, I get the same message. If I specify no credentials, same error. Using the domain account which runs the service also gets this error. I haven't seen this before, and am unclear as to why it's happening. Thanks for your help, Tom [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hi Tom, > > If you try to access the Report Server http://<server name>/ReportServer, > does any error appear? > > Also, if you try to run the rsconfig utility to connect to the reportserver > database by using the domain admin account, does this issue appeared? > > rsconfig Utility > > http://msdn2.microsoft.com/en-us/library/ms162837.aspx > > Hope this will be helpful! > > Sincerely, > > Wei Lu > > Microsoft Online Community Support >
Wei,
After a bit more reseach, I have found the problem. The issue was with the Execution Account not being properly set up (actually it was, but someone changed the password for the account and didn't tell me). Once I reset that account, things are working properly now. Thanks for all your help, Tom [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hi Tom, > > If you try to access the Report Server http://<server name>/ReportServer, > does any error appear? > > Also, if you try to run the rsconfig utility to connect to the reportserver > database by using the domain admin account, does this issue appeared? > > rsconfig Utility > > http://msdn2.microsoft.com/en-us/library/ms162837.aspx > > Hope this will be helpful! > > Sincerely, > > Wei Lu > > Microsoft Online Community Support >
Hello Tom
Thank you for your update. Glad to hear you have resolved this issue by changing the Execution Account Password. Please let me know if you have any questions or concerns. Thank you! Sincerely, Wei Lu Microsoft Online Community Support
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
January 2009
| home · blog · groups | Questions? Comments? Contact the dn |