1

We had to set SQL Server hide instance flag as "Yes" in production to fix the violation like ADHOCdistQueries_RunValue, hideinstance etc.

But once we hide the instance, SSRS data source connection is failing. Can you please recommend options to fix this issue? We want to keep the database hidden and also make SSRS DB connection work.

How can we do it? Thanks.

Error: The Report Server Cannot Open a Connection to the Report Server Database. A connection to the database is required for all requests and processing (rsReportServerUnavailable)

Improve this question
5
  • 1
    Are you really still using SQL Server 2008? It ran completely out of support back in 2019 (4 years ago). It is long past time you implemented your finalised upgrade plan at this point. Commented Jul 10, 2023 at 15:47
  • We are using SQL Server 2014 Commented Jul 10, 2023 at 16:01
  • 1
    Then why tag both [sql-server-2008] and [ssrs-2008]? Commented Jul 10, 2023 at 16:13
  • 1
    Have you tried specifying a port number instead of instance name in the connection string? That way, the SQL Server Browser service isn't used. Commented Jul 10, 2023 at 16:17
  • Dan -- This is a good answer. But we can't change all the dependent applications in production from instance name to IP/Port. If any other option comes to your mind, feel free to share with me. Thanks. Commented Jul 11, 2023 at 14:00
Related questions
4347
UPDATE from a SELECT
3327
How to add a column with a default value to an existing table in SQL Server?
2114
LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.