SQL will not start

[Former Member]

I have just installed SQL 2005 and B1 on a new SB Server and SQL will not start. I get a service specific error 126 (0x7e). I've looked this up in the SAP notes and Microsoft SQL help, but can not find anything. Anyone have ideas as to what to do next?

[Former Member]

Hi Kathy

Have a look at the following thread as well:

https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3619346&SiteID=17

Kind regards

Peter Juby

[Former Member]

Hi Kathy

Can you go to My Computer and right click and select Manage. Expand the event viewer and go through the various files. Look for any red crosses and see if there are any other services that SQL might depend on that are also not starting, or if there are any specific errors for SQL.

Let me know.

Kind regards

Peter Juby

[Former Member]

The SQL error is "The SQL Server (MSSQLSERVER) service terminated with service-specific error 126 (0x7e).

I did try to look this error up on the MS knowledgebase, but could not find this specific one.

There are no other errors in the Event Viewer related to SQL.

[former_member583013]

I found some info outside of the Forums. Searching the WWW with the specific error should get you the answers

Two of the links

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86841

http://www.myitforum.com/forums/m_173415/mpage_1/key_/tm.htm#173415

[Former Member]

That worked! Thanks so much for your help!

[Former Member]

Hi Kathy

Did you follow the SAP guidelines to install SQL 2005 found in the documentation for the SAP installation (AdministratorGuide_SQL.PDF)? Can you give me specific info on what steps you took and any selections that were made during the installation? Did you reboot the server after the installation? Is the server configured for IIS?

Let me know so I can look into it for you

Kind regards

Peter Juby

[Former Member]

Yes, I did follow the instructions, and I believe that the selections i made were standard. It appears that IIS is configured as I can see it on the menu and I did reboot the server after installation. Anything else that may help?