Share via

How can I connect SSMS to an SSRS instance using the connect dropdown?

Richard Giesbrecht 0 Reputation points
2025-02-18T20:21:07.21+00:00

Trying to connect to an SSRS instance via SSMS where the ReportServer database is on one server and the SSRS services are on a different server. SSMS is unable to connect, possibly because of firewall rules.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,002 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,126 Reputation points
    2025-02-19T03:18:10.7766667+00:00

    Hi Richard Giesbrecht

    In Reporting Services, you can configure report server instances locally or remotely. To configure a remote report server instance, you can use the Reporting Services Configuration tool or write custom code that uses the Reporting Services Windows Management Instrumentation (WMI) provider.

    Please follow the steps mentioned in the official documentation.

    Configure a report server for remote administration

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  2. Olaf Helper 46,196 Reputation points
    2025-02-19T06:41:07.98+00:00

    How can I connect SSMS to an SSRS instance using the connect dropdown?

    Enter the SSRS ReportServer URL and you can connect to SSRS using SSMS.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.