SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Error 126
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jimmyjoemeeker
Starting Member

6 Posts

Posted - 07/24/2007 :  22:02:34  Show Profile  Reply with Quote
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 - 07/24/2007 :  22:33:13  Show Profile  Reply with Quote
Never mind. I had to disable the VIA protocol. Works fine now....
Go to Top of Page

khushbu
Starting Member

1 Posts

Posted - 04/09/2009 :  04:13:27  Show Profile  Reply with Quote
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 - 08/13/2009 :  09:21:04  Show Profile  Reply with Quote
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 - 08/13/2009 :  09:23:16  Show Profile  Reply with Quote

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

USA
1 Posts

Posted - 08/24/2009 :  19:23:37  Show Profile  Reply with Quote
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.

Edited by - rgarrison on 08/24/2009 19:24:11
Go to Top of Page

narayananbabun
Starting Member

India
3 Posts

Posted - 10/21/2010 :  07:26:04  Show Profile  Send narayananbabun a Yahoo! Message  Reply with Quote
This worked out for me thanks very much

narayananbabun
Go to Top of Page

geri856
Starting Member

El Salvador
1 Posts

Posted - 11/14/2010 :  14:27:04  Show Profile  Reply with Quote
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

India
3 Posts

Posted - 11/16/2010 :  08:08:50  Show Profile  Reply with Quote
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 Posts

Posted - 02/11/2012 :  01:37:26  Show Profile  Reply with Quote
Good help ... thanks a lot .. superlike!!!!

sqlg27
Go to Top of Page

friendranga
Starting Member

1 Posts

Posted - 01/06/2014 :  18:37:37  Show Profile  Reply with Quote
It worked for me....

Thanks for the tip.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000