Cannot connect to remote SQL Server.

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. 

• Status: Open
• Question Views: 1419
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Norwood-Koonce 0 points N/A #157349

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.   

 

About Norwood-Koonce

Questions
0

Answers
96

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 05/09/2012
• Question Category: MS SQL Server