By default Sql server 2005 does not support remote connection using TCP/IP.
This error generally occur when you try to connection a remote or network server using IP address or server name.
Now the question arises how to make enable remote connection for sql server 2005.
Here is the solution:-
Start >> Programs>> Microsoft SQL Server 2005 >>Configuration Tools >>SQL Server Surface Area Configuration
This following images display graphical represents of solution.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIrYRjuka52Zm8YR-BNJeSk0Hb7ysUWx1WYZlZL7-Yjnyviv4ixvU4iNtYfuwUFmkrizRfBJTxaguUH4XFFWXeaI1uV7EVMKmQ6k6YuKuNs5txaT36k6dgGa8eOz-zPRj4jVz6hqr9Ex0/s320/1.jpg)
Follow steps highlighted in red
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEn9kxg_ZgSxTm_WqKGnvasSw5vijenZi7Vov1WrQ2YR3daF3cF651n-GaiGCvO-qf6gMFRVlaKd5coWEkRKVuyht3KldrbfyWZaDI6V58soFUsr8BUdqTrQCE3KDnYe1RBKlimJelEwU/s320/2.jpg)
Follow steps highlighted in red
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2mof2mnJktZ06PNaMZ6xmzkGKcLNXQmk1r6N4Mb4dk4v6ORYVVmBAXv9VwAt8Z6laKKPqxfabQ46TaqcZEmTwIvdlRLTWWvQFA9FrzPCxwU5Y7wXLJRnCQfTA2hR31ybD12D3D2eP4X4/s320/3.jpg)
Now press apply and ok.
By pressing OK. the current settings will not take effect. To make these settings effective you have to restart sql server.
Go to start >> Run >> services.msc
press Ok
it will dispaly services window. now go to "SQL Server (MSSQLSERVER)", right click and "Restart service to take effect"
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmEa6FgVNkuragm_7eFNOsfnz8pp-3s0_A5sBKtjqHCYqclRfI70W7kxFtHjLq8PXzSzna918tQlVtTtKgr4VIscszGa0E61Crbz-uTIPl9mA0v8tRU-L90xnk9pOd9kIvcE6ZAsn8qQc/s320/4.jpg)
If still this will not work try restarting your system/pc
This error generally occur when you try to connection a remote or network server using IP address or server name.
Now the question arises how to make enable remote connection for sql server 2005.
Here is the solution:-
Start >> Programs>> Microsoft SQL Server 2005 >>Configuration Tools >>SQL Server Surface Area Configuration
This following images display graphical represents of solution.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIrYRjuka52Zm8YR-BNJeSk0Hb7ysUWx1WYZlZL7-Yjnyviv4ixvU4iNtYfuwUFmkrizRfBJTxaguUH4XFFWXeaI1uV7EVMKmQ6k6YuKuNs5txaT36k6dgGa8eOz-zPRj4jVz6hqr9Ex0/s320/1.jpg)
Follow steps highlighted in red
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEn9kxg_ZgSxTm_WqKGnvasSw5vijenZi7Vov1WrQ2YR3daF3cF651n-GaiGCvO-qf6gMFRVlaKd5coWEkRKVuyht3KldrbfyWZaDI6V58soFUsr8BUdqTrQCE3KDnYe1RBKlimJelEwU/s320/2.jpg)
Follow steps highlighted in red
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2mof2mnJktZ06PNaMZ6xmzkGKcLNXQmk1r6N4Mb4dk4v6ORYVVmBAXv9VwAt8Z6laKKPqxfabQ46TaqcZEmTwIvdlRLTWWvQFA9FrzPCxwU5Y7wXLJRnCQfTA2hR31ybD12D3D2eP4X4/s320/3.jpg)
Now press apply and ok.
By pressing OK. the current settings will not take effect. To make these settings effective you have to restart sql server.
Go to start >> Run >> services.msc
press Ok
it will dispaly services window. now go to "SQL Server (MSSQLSERVER)", right click and "Restart service to take effect"
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmEa6FgVNkuragm_7eFNOsfnz8pp-3s0_A5sBKtjqHCYqclRfI70W7kxFtHjLq8PXzSzna918tQlVtTtKgr4VIscszGa0E61Crbz-uTIPl9mA0v8tRU-L90xnk9pOd9kIvcE6ZAsn8qQc/s320/4.jpg)
If still this will not work try restarting your system/pc