August 26, 2011

Connect SQL Server remotely using IP Address



If we will try to connect default installed SQL Server with IP  address we will receive below
error.
One of my technical member assisted me how can we resolve this.

Step 1: First open the SQL Configuration Manager.



Step 2: In SQL Server Configuration Manager window click on Protocols for SQLEXPRESS
and then TCP/IP.



Step 3: Now IP1 section type IP and TCP port and in IP All type TCP Port.
Now click on Ok.



Step 4: Restart SQL Server services.Now we can login using IP address.



That’s It.
Enjoy Reading.

No comments:

Post a Comment