avatar

Cannot Connect To Remote Sql Server.

Asked By 0 points N/A Posted on -
qa-featured

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. 

SHARE
Answered By 0 points N/A #157349
qa-featured
Hello, 
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