How to Configure SQL Server 2005 Network Connectivity


Here I am demonstrating how to simply configure networking connectivity in SQL Server 2005.

Go to  Start ->All Programs ->Microsoft  SQL Server 2005->Configuration Tools->SQL Server Configuration Manager.

img1.gif

We are going to allow connections on TCP/IP. By default the TCP/IP service is disabled and also by default SQL only allows local connections. Let's start TCP/IP.

img2.gif

Select TCP/IP and right-click and then enable. You will then see it as below:

img3.gif

img4.gif

After that right-click on TCP/IP and click the properties. Then click on IP Addresses. Here you find your IP. If your IP address is incorrect than correct it and click ok.

img7.gif

After that restart SQL Server 2005 Services.

img8.gif

Finally we are able to remotely connect to other computer databases. Make sure that whichever computer you want to access the database for, it is connected with your computer.

img9.gif

Select any one by which you want to connect. And give a Login Id and Password as required.

img10.gif

img11.gif

If there are any problem after fallowing these step then restart your computer. Manage any firewall exceptions for SQL server.


Similar Articles