October 10, 2024 at 7:42 am
I was trying to access SSRS report in host server browser , throwing an error message below but I can able to access thes same out side the server , which is in my local is working well. I did check the account having SA full rights to the reporting databases and having certificates , keys are looks good. Please suggest what could be the reason on this .....it would be much appreciated !!
The service is not available.
Contact your system administrator to resolve the issue. System administrators: The report server can’t connect to its database. Make sure the database is running and accessible. You can also check the report server trace log for details.
October 10, 2024 at 1:05 pm
Not sureI understand your question correctly.
You get the database connect error when you try to call a report through Report Manager?
The first thing that comes to my mind is that you may have have a firewall issue. Have you checked that you can establish a connection from your Report Manager server instance to the database server instance?
The default SQL Server port for querying is 1431, but it might have been set to something different if your security people have been busy.
October 11, 2024 at 9:53 am
I have configured SSRS with encryption key , service account having SA permission and Reporting Databases looks good, TCP / IP enabled as well. However I can see error stating while access report from browser and don't see issue from ssrs logs.
The service is not available.
Contact your system administrator to resolve the issue. System administrators: The report server can’t connect to its database. Make sure the database is running and accessible. You can also check the report server trace log for details.
October 11, 2024 at 1:01 pm
So whats in the trace file? Does it help us understand whats happening in some way?
October 11, 2024 at 2:52 pm
Trace log file means, Is the ssrs logs ? Don't see much in logs. Appreciate if any help please...
October 11, 2024 at 3:36 pm
Are you using Windows authentication to connect to the database?
If so you might have a Kerberos double hop problem.
If you do, try checking the SPNs with the Kerberos Configuration Manager for SQL Server
ie When running the report on your local machine you are going directly to the database server. When running the report through the browser you are going from your local machine to the SSRS server which then connects to the database server. (ie Your credentials need to double hop.)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply