Unable to start SQL service - SQL Server Forums

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

SQL Server Administration (2005)

Unable to start SQL service

Author

Topic

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2008-05-01 : 14:42:00

I am unable to start SQL service on my system after i rebooted it

following is the message that i get
SQL Service on Local Computer started and then stopped. Some service stop automatically if they have no work to do

following is the corresponding entry in event viewer
TDSSNIClient initialization failed with error 0x7e, status code 0x60.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-01 : 23:28:01

Which version of sql?

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2008-05-02 : 18:45:38

SQL server 2005

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-02 : 18:59:02

You should always google your error before posting.

Try these:
http://www.dedicatedsqlserver.com/HowTo/MSSQLSERVER_Fail_To_Start.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/10/31/487090.aspx

If those don't work, google your error to see the other suggestions.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2008-05-05 : 14:00:55

Thanks tkizer
problem resolved (this link http://blogs.msdn.com/sql_protocols/archive/2005/10/31/487090.aspx solved the problem)
actually I did tried to google it
however I was searching the error that i got while starting service and not the message in the event viewer
can you clarify my doubt
I didn't changed a thing and just rebooted my system then why via protocol got enabled and service stopped responding

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-05 : 22:33:17

Are there any hints in windows event logs?

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2008-05-06 : 14:52:38

following is the corresponding entry in event viewer
TDSSNIClient initialization failed with error 0x7e, status code 0x60.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-06 : 14:54:07

Are we in an endless loop?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

evmisu
Starting Member

17 Posts

Posted - 2009-02-14 : 03:51:26

I have this probelm also and solve it though http://blogs.msdn.com/sql_protocols/archive/2005/10/31/487090.aspx !! So greaT!!!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources