Thursday, July 23, 2015

Connecting to a another SQL Server instance on the same network/LAN

If you need to connect to another SQL Server instance on the same network you need to ensure the following settings are in place-

1. Your login should be added to the SQL Server instance you are trying to connect to.

2. The SQL Server instance should have Allow Remote Connections as checked.
     a. Goto Instance Properties
     b. Connections
     c. Check "Allow remote connections to this server".

3. SQL Server Browser Service should be running in the machine you are trying to access.

4. TCP/IP Protocol should be enabled for the SQL Server
        a. Run SQL Server Configuration Manager
        b. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS
        c. Make sure TCP/IP is enabled.

Hope this helps!!

No comments:

Post a Comment