Asked By
ramananth
0 points
N/A
Posted on - 05/09/2012
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.
Cannot connect to remote SQL Server.
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.