question

sand143eep avatar image
sand143eep asked

Unable to connect to Reporting services

Hello, when i am trying to connect to the Reporting services 2005 i am getting the following error:
  • The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help
    • **The referenced account is currently locked out** and may not be logged on to. (Exception from HRESULT: 0x80070775)
    • can any one please help on this as this was an urgent issue.
ssrsssrs-2005ssrs-subscription
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
Based on the error it seems, tha thte user account which Reporting Services is using to connect to it's database is locked out. It can be Windows(Active Directory) Account or SQL Server Account. You can identify it in the Reportin Services Configuraiton database. Then in case it is SQL Server account you can unlock it using `ALTER LOGIN [account] UNLOCK`. If it is local windows account, you can unlock it in the local uses management. In case of AD account, you will have to ask your AD Administrator to unlock it. But any way, if the service account get locked, I would try to investigate why it happen. (Whether some administrator changed the password, or the password has expried etc. or whether there was some security breach). In case the password has expired, you will have to change the password. And if password was changed, you have to set the new password in the Reporting Services Configuration manager so the account is not locked again.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sand143eep avatar image sand143eep commented ·
Hello it was windows account and we unlocked it now we are able to connect to the Reporting services but there is another issue now when i am trying to open home then i am getting the following error: The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) (Report Services SOAP Proxy Source) i am confused please help.
0 Likes 0 ·
sand143eep avatar image sand143eep commented ·
As i am getting the error The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) (Report Services SOAP Proxy Source) i opened the reporting services configuration manager and selected encryption keys tab and deleted the encryption keys. it worked for me now i am able to see the reports. and the database was also initialized automatically.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.