Monday, February 2, 2009

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005 ,SQL Server does not allow remote connections

5 comments
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.

















Follow steps highlighted in red
































Follow steps highlighted in red
































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"





























If still this will not work try restarting your system/pc

5 comments:

Shakti Singh Dulawat said...

Narendar you are doing a great work

Anonymous said...

hello l have and fellow the what you said but l still get the same error.
l install sql server 2005 express edition and and visual server 2005 profeesional and it works well.l then uninstall the sql server 2005 and installed sql server 2005 Enterprise edition because l want to add report service to my project.
then from then l start getting the problem.
any idea please
salis

Parminder Singh said...

Hi,

I had faced that same problem earlier.

I had tried so many solution but finally, I had removed the whole Sql server and reinstall again. May this solution will work for u.

(:)
Thanks,
Parminder

Anonymous said...

Thank you very much for this information.I was searching it for long to use sql express to connect to remote .

Shijo Baby said...

Hi

Try this also

http://sqlservererror-info.blogspot.com/2009/07/error-has-occurred-while-establishing.html

If helpful pls leave a comment also

Regards