Could Not Start Sql Server Error 126
Contents |
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. error 126 sql server 2008 SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and
Windows Could Not Start The Sql Server On Local Computer Error Code 126
get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums Other SQL Server Topics (2005) Error
Windows Could Not Start The Sql Server (mssqlserver) Service On Local Computer
126 Reply to Topic Printer Friendly Author Topic jimmyjoemeeker Starting Member 6 Posts Posted-07/24/2007: 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
Sql Server Could Not Spawn Fruncm Thread
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 Never mind. I had to disable the VIA protocol. Works fine now.... khushbu Starting Member 1 Posts Posted-04/09/2009: 04:13:27 I'm too reciving event id 7024 same error but I no protocola enabled.Ps. if you can elaborate how to disable this it will good for me to recheck MonikaK Starting Member 6 Posts Posted-08/13/2009: 09:21:04 quote:Originally posted by khushbuI'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 recheckStart->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'. MonikaK Starting Member 6 Posts Posted-08/13/2009: 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' rgarrison Starting Member USA 1 Posts Posted-08/24/2009: 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. Edited by - rgarrison on 08/24/2009 19:24:11 narayananbabun Starting Member India 3 Posts Posted-10/21/2010: 07:26:04 This worke
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Administration » Error Code 126 while running up the SQl... Error Code 126 while running up the SQl Server 2005 Rate Topic Display Mode Topic Options Author Message Shivanandan GuptaShivanandan Gupta Posted Tuesday, February 26, 2008 1:57 AM Grasshopper Group: General Forum Members Last Login: Thursday, February 18, 2010 2:24 AM Points: 10, Visits: 32 Hello friends , I am getting error code 126 when I am trying http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86841 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. Post #460097 AnipaulAnipaul Posted Tuesday, February 26, 2008 2:14 AM SSCertifiable Group: General Forum Members Last Login: Wednesday, April 20, 2016 3:23 AM Points: 6,049, Visits: 1,407 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 Post #460101 Shivanandan GuptaShivanandan Gupta Posted Tuesday, February http://www.sqlservercentral.com/Forums/Topic460097-5-1.aspx 26, 2008 10:34 PM Grasshopper Group: General Forum Members Last Login: Thursday, February 18, 2010 2:24 AM Points: 10, Visits: 32 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. Post #460687 adam.grochadam.groch Posted Wednesday, June 18, 2008 2:54 PM Forum Newbie Group: General Forum Members Last Login: Wednesday, June 18, 2008 3:15 PM Points: 1, Visits: 1 could you please share your solution, have the same problem THANKS!!! Post #519453 shailesh.thapliyalshailesh.thapliyal Posted Tuesday, January 4, 2011 10:49 PM SSC-Enthusiastic Group: General Forum Members Last Login: Thursday, October 17, 2013 3:35 PM Points: 122, Visits: 142 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' Post #1042820 « Prev Topic | Next Topic » Permissions You cannot post new topics. You cannot post topic replies. You can
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site http://serverfault.com/questions/112913/sql-server-instance-service-doesnt-start About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers sql server are voted up and rise to the top SQL Server instance service doesn't start up vote 0 down vote favorite After manually stopping SQL Server instance service it can not be started both manually from a SQL Server Configuration Manager and automatically by restarting computer. If trying to do it manually I get a message: The request failed or the service did not respond in a could not start timely fashion. Consult the event log or other applicable error logs for details. In event log I can see following: Event ID 7024. The SQL Server (RBSQL) service terminated with service-specific error 126 (0x7E). I use SQL Server 2008 on Windows XP Pro sql-server sql-server-2008 share|improve this question asked Feb 15 '10 at 10:27 rem 15828 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted The problem is solved. It was because the VIA protocol appeared to be enabled. After disabling it (in SQL Server Configuration Manager there are protocols for this instance) everything is OK. share|improve this answer answered Feb 15 '10 at 11:49 rem 15828 add a comment| protected by Michael Hampton♦ Jun 20 '14 at 13:18 Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count). Would you like to answer one of these unanswered questions instead? Not the answer you're looking for? Browse other questions tagged sql-server sql-server-2008 or ask your own question. asked 6 years ago viewed 9607 times active