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.