Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Error 126

Author  Topic 

jimmyjoemeeker
Starting Member

6 Posts

Posted - 2007-07-24 : 22:02:34
I've re-installed SQL 2005 on an XP Pro box. I'm making some setting changes in the Configuration Manager. After a change I have to stop and start SQL. After repeating this several times, I get this error message:

The SQL Server (SQLSTARR) service terminated with service-specific error 126 (0x7E).

I've rebooted with no change. Anybody know what's going on and how to fix it?

thanx...

jimmyjoemeeker
Starting Member

6 Posts

Posted - 2007-07-24 : 22:33:13
Never mind. I had to disable the VIA protocol. Works fine now....
Go to Top of Page

khushbu
Starting Member

1 Post

Posted - 2009-04-09 : 04:13:27
I'm too reciving same error but I no protocola enabled.

Ps. if you can elaborate how to disable this it will good for me to recheck
Go to Top of Page

MonikaK
Starting Member

6 Posts

Posted - 2009-08-13 : 09:21:04
quote:
Originally posted by khushbu

I'm too reciving same error but I no protocola enabled.

Ps. if you can elaborate how to disable this it will good for me to recheck


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'.
Go to Top of Page

MonikaK
Starting Member

6 Posts

Posted - 2009-08-13 : 09:23:16

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 san select 'Disable'
Go to Top of Page

rgarrison
Starting Member

1 Post

Posted - 2009-08-24 : 19:23:37
jimmyjoemeeker wrote "Never mind. I had to disable the VIA protocol. Works fine now...."

I had the error (in SQL 2008 RTM) and tried that, and now I'm back up.

Thanks for the tip.
Go to Top of Page

narayananbabun
Starting Member

3 Posts

Posted - 2010-10-21 : 07:26:04
This worked out for me thanks very much

narayananbabun
Go to Top of Page

geri856
Starting Member

1 Post

Posted - 2010-11-14 : 14:27:04
quote:
Originally posted by rgarrison

jimmyjoemeeker wrote "Never mind. I had to disable the VIA protocol. Works fine now...."

I had the error (in SQL 2008 RTM) and tried that, and now I'm back up.

Thanks for the tip.



super THANK'S!!!!!!
Go to Top of Page

amar4sk
Starting Member

3 Posts

Posted - 2010-11-16 : 08:08:50
It worked for me....

Thanks for the tip.

quote:
Originally posted by geri856

quote:
Originally posted by rgarrison

jimmyjoemeeker wrote "Never mind. I had to disable the VIA protocol. Works fine now...."

I had the error (in SQL 2008 RTM) and tried that, and now I'm back up.

Thanks for the tip.



super THANK'S!!!!!!



amar
Go to Top of Page

sqlg27
Starting Member

1 Post

Posted - 2012-02-11 : 01:37:26
Good help ... thanks a lot .. superlike!!!!

sqlg27
Go to Top of Page

friendranga
Starting Member

1 Post

Posted - 2014-01-06 : 18:37:37
It worked for me....

Thanks for the tip.
Go to Top of Page
   

- Advertisement -