question

erlokeshsharma08 avatar image
erlokeshsharma08 asked

SSRS gives error BUT SSMS does not

Hi Guys! This is with regards to getting a feedback for the PROD issue which we faced today. - The issue was that users or anybody in the team were not able to access SSRS report through report manager. We were getting the error - cannot connect to the data source 'XYZ'. After struggling a lot the DB found that there were too many sessions running against the target database (using sp_whoisactive command) and the CPU utilization on prod server was 91 to 95 percent. We were able to retrieve the data using SSMS. DB eventually had to restart the sql server and the reports were being accessed. Can anybody explain this conundrum. P.S. - Happy to share more info if you want.
sqlssrsreportmanager
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

·
jason_clark03 avatar image
jason_clark03 answered
Enable remote errors. tO CHECK more about error. You may also, check Report Server error which error was logged. %programfiles%\Microsoft SQL Server\\\LogFiles\ After this connect Datasource user with the database. Run any script using same parameter which report is using . Hope this will help you.
1 comment
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.

erlokeshsharma08 avatar image erlokeshsharma08 commented ·
Thanks Jason. I'll try these settings. Just to answer your question - the issue was not with one particular report, all the reports were not being accessible.
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.