How to connect to another SQL Server in your network

How to connect to another SQL Server in your network

Step 1

To register another MS SQL Server, go to your SQL Server and right click on it.

Then another popup menu will appear. From here choose New SQL Server Registration.

Then register SQL Server Wizard will appear

Step 2

Click on Next to continue. We will attempt to connect to a server called JAGUAR.

Step 3

Add it into Added Server column and click Next to continue.

Step 4

Click Next to continue.

Step 5

Accept the default and click Next to continue.

Step 6

Click on Finish to let SQL Server Wizard to find and add this server into your group of SQL Servers.

Then your Enterprise Manager would look something like this.