Error Code 126 while running up the SQl Server 2005

Question

Error Code 126 while running up the SQl Server 2005

Shivanandan Gupta

SSC-Addicted

Points: 434
More actions
February 26, 2008 at 1:57 am

#71175

Hello friends , I am getting error code 126 when I am trying to start the sqlserver from services(Local). Its trying to start the server but at last its giving error code 126. Can anyone help me out to solve this problem.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Anipaul SSC-Insane Points: 24681 More actions · Answer 1

Read this:

http://www.mydigitallife.info/2007/10/31/error-has-occurred-while-establishing-a-connection-to-sql-server-2005-which-does-not-allow-local-and-remote-connections/

http://blogs.msdn.com/sql_protocols/archive/2006/04/28/585835.aspx

Shivanandan Gupta SSC-Addicted Points: 434 More actions · Answer 2

Hello friends for the above problem I got the solution. I have just repaired the SQL server 2005 and after that i am able to run the database engine server.

adam.groch Valued Member Points: 67 More actions · Answer 3

could you please share your solution, have the same problem THANKS!!!

shailesh.thapliyal Right there with Babe Points: 750 More actions · Answer 4

Hi try this.

Start->All Programs -> Microsoft Sql server 2005 -> Configuration Tools -> SQL Server Configuration Manager.

In the SQL SERVER configuration Manager Window, click the plus (+) sign against SQL SERVER 2005 Network Configuration.

Highlight 'Protocols for MS SQL SERVER'

In the right pane you'd find VIA in protocol name column , you can right click it select 'Disable'

🙂