Cannot connect to remote SQL Server.

Asked By 0 points N/A Posted on -

I have MS sql in a one PC and I need to connect with it from another pc remotely. But it always aborted since the connection time out. I have enabled the remote login in security but still the problem exists. 

Answered By 0 points N/A #157349

Cannot connect to remote SQL Server.

I have that problem once. I also have enabled all the features that need to be connecting remotely to the pc which has my database. But it is not worked.  But finally I got the solution.
This is it.
For this you have to go to the start menu — > Microsoft SQL server 2008/2005 — > Configuration Tools — > SQL Server Configuration Manager — > SQL Server Network configuration — >Protocol for MSSQLSERVER
Then see the figure below you can identify what you need to do. Enable all the features except VIA.
Then it will definitely work.   

Login/Register to Answer

Related Questions