SQL Server Account will work for SQLSERVER but fails to ReportServer

Posted by Larry on Stack Overflow See other posts from Stack Overflow or by Larry
Published on 2010-04-30T23:02:48Z Indexed on 2010/04/30 23:07 UTC
Read the original article Hit count: 452

Filed under:

ssrs-2008

Setting up SSRS. For Service Account, 1. I set a domain account as the Report Server Service Account.
2. click apply 3. SQL Server Connection Dialog pops up. Need to specify an account with admin privileges. i. set Credentials Type = SQL Server Account ii. I use sa account (which works, verified many ways with sql server management studio)

I fails with the following:

System.InvalidOperationException: Cannot start service ReportServer on computer 'DEVDB5'. ---> System.ComponentModel.Win32Exception: The service did not start due to a logon failure --- End of inner exception stack trace --- at System.ServiceProcess.ServiceController.Start(String[] args) at System.ServiceProcess.ServiceController.Start() at ReportServicesConfigUI.Panels.WindowsServiceIdentityPanel.StartWindowsServicePostChangeWindowsServiceIdentity(ServiceController rsService)

What am I doing wrong.

btw: it was working fine as of yesterday. I originally set up SSRS a few days ago using the sa account

Related posts about ssrs-2008

How to convert SSRS 2008 Server reports to SSRS 2008 Client Reports

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a large SSRS 2008 Server Report Project (more than 200 reports). Currently my companystrategy has been changed and we want to convert these server reports to client reports. All of the Server reports uses Storeprocedures (or in some cases from the SQl Functions) All of them work properly… >>> More
iPhone - Open excel from SSRS 2008

as seen on Server Fault - Search for 'Server Fault'
We're currently having a problem with our 2008 SSRS server sending excel reports to users with iPhones. They get the email with no problems, but when the XLS file is opened on the phone, it returns an error of: Invalid format. Everyone else can open the report with no problems (email/blackberry) The… >>> More
SSRS 2008 Report Manager Error

as seen on Stack Overflow - Search for 'Stack Overflow'
I have just installed SQL Server 2008 including Reporting Services on Windows Server 2003. I'm having a problem though accessing the Report Manager. When the Reporting Service is first started I can access it fine but after maybe an hour when I try and access it I get an error saying: Unable to… >>> More
How to disable SSRS 2008 manager

as seen on Stack Overflow - Search for 'Stack Overflow'
Can you disable the SSRS 2008 manager (http://mydomain/reports), while leaving the report server working (http://mydomain/reportserver)? EDIT: Got it! This is how you do it in SSRS: Turn off Report Manager >>> More
Force SSRS 2008 to use SSRS 2005 CSV rendering

as seen on Stack Overflow - Search for 'Stack Overflow'
We are upgrading our report server from SSRS 2005 to SSRS 2008 R2. I have an issue with CSV export rendering for SSRS 2008 where the SUM of columns are appearing on the right side of the detail values in 2008 instead of the left side like in 2005 as shown in the below blocks. 117 and 131 are the sums… >>> More

Developer IT