Share via

How to connect to a second SQL Server instance in Report Server Connection?

CharlieLor 571 Reputation points
2020-11-12T18:05:00.64+00:00

I have two instances (DB22 and SMC) of SQL Server in a box. When I launched the Report Server Configuration Manager, I tried to connect to my SMC instance with Server name as DB22/SMC but I kept getting this error.

39300-screen-shot-2020-11-12-at-115837-am.png

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.
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CharlieLor 571 Reputation points
    2020-11-12T18:21:42.24+00:00

    Okay, it looks like I have to connect to the default (db22) and then in the Database, I can change the database to db22\smc there and once I change it there, it will keep these settings even though I connect to db22 instead of db22\smc. Does this sound correct?

    0 comments
  2. ZoeHui-MSFT 41,536 Reputation points
    2020-11-13T01:52:14.99+00:00

    Hi @CharlieLor ，

    When we start to configure the Report Server.

    In Server Name, specify the name of the computer on which the report server instance is installed.

    The name of the local computer appears by default. So it will be the default 'db22' .

    In Report Server Instance, select the SQL Server Reporting Services instance that you want to configure. Suppose you are using SSRS2019, it should be SSRS.

    Click Database , we could create the report server database.

    The database is required and it is used to store published reports, models, shared data sources, session data, resources, and server metadata.

    Once you change the database to db22\smc, all the settings will be stored in db22\smc.

    For more detail information, please refer:

    https://learn.microsoft.com/en-us/sql/reporting-services/report-server/configure-a-report-server-reporting-services-native-mode?view=sql-server-ver15

    https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-native-mode-report-server-database?view=sql-server-ver15

    https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/reporting-services-configuration-manager-native-mode?view=sql-server-ver15

    Regards，
    Zoe

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November

  3. asma gh 21 Reputation points
    2021-01-16T16:32:42.18+00:00

    i have the same probleme any idea how to fix it please

    0 comments

Your answer

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