SQL Server Account will work for SQLSERVER but fails to ReportServer
- by Larry
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