June 17, 2014 at 7:54 am
We run srss against a log ship copy of sql server 2008 r2. everything worked fine until we got below error message. We can connect to database with management studio with same credentials
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DBNAME'. ---> System.Data.SqlClient.SqlException: Cannot open database "DBNAME" requested by the login. The login failed.
Login failed for user 'RptAcct'.
June 23, 2014 at 8:03 pm
tcronin 95651 (6/17/2014)
Cannot open database "DBNAME" requested by the login. The login failed.Login failed for user 'RptAcct'.
The error tells you to investigate the login RptAcct. Did somebody changed the security of the account?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply