Help! can't start SQL Server!!!!!

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)

Help! can't start SQL Server!!!!!

Author

Topic

Newbie777
Starting Member

20 Posts

Posted - 2010-12-20 : 16:50:57

I changed the startup parameters in Config Manager and Now SQL Server won't start up. I tried to change it back but it won't let me in Config Manager, is there any other way I can start it up? Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-20 : 16:51:39

We'll need the error. Check the AppLog in Event Viewer for the error.

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

Subscribe to my blog

Newbie777
Starting Member

20 Posts

Posted - 2010-12-20 : 17:20:09

theres a bunch of errors from the app logs:

sqqgtres: checkservice alive: QueryServiceStatus Failed (status 6),
sqsrvres: online thread error 435 bringing resouce online.
sqsrvres: resutilsstartresource service failed (status 435),
sqsrvres: failed to start mssql$instance1 current state 1
sqsrvres: counld not open errorlong file, operating system error = 3,the system could not find the path specified.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-20 : 17:23:56

It seems you've got an incorrect path specified for the Error Log. You'll need to rectify that in the startup parameters of the service via Configuration Manager.

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

Subscribe to my blog

Newbie777
Starting Member

20 Posts

Posted - 2010-12-21 : 11:16:40

I did, I have added the line and ran this in command mode:

sqlservr.exe -sINSTANCE1 ;-eF:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

I have verified the errorlog does exist on that drive but I still get the error message:
initerrlog: Could not open error log file Operating system error = 3(The system cannot find the path specified.)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-21 : 11:38:59

Show the entire startup parameter line in the Config Manager.

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

Subscribe to my blog

Newbie777
Starting Member

20 Posts

Posted - 2010-12-21 : 11:47:05

do you mean put this in startup param in config manager?

sqlservr.exe -sINSTANCE1 ;-eF:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

I also tried this and it didn't work in config manager:
-dF:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\master.mdf;-eF:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lF:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mastlog.ldf

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-21 : 11:49:32

No, I mean copy/paste what you have in Config Manager into this thread so that we can inspect it. Something is wrong with your startup parameters.

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

Subscribe to my blog

Newbie777
Starting Member

20 Posts

Posted - 2010-12-21 : 11:59:50

this is what I pasted into the startup parameter in config manager, then I used the login tab to start the service. but fails

-dF:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\master.mdf;-eF:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lF:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mastlog.ldf
===========================================================
this is what i put originally that started the problem:
-c -m -T3608 without the semicolon then shutdown the service.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-12-21 : 15:29:51

In regedit navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\Parameters

Make sure there's nothing else in there. Verify all 3 paths are correct.

Newbie777
Starting Member

20 Posts

Posted - 2010-12-21 : 16:19:32

THANK YOU!

This is what's in regedit under parameters

Name Type Data
(Default) REG_SZ (value not set)
SQLArg0 REG_SZ -c -m -T3608

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-12-21 : 16:44:52

Should look a lot like this:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\Parameters]
"SQLArg0"="-dC:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\master.mdf"
"SQLArg1"="-eC:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\LOG\\ERRORLOG"
"SQLArg2"="-lC:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\mastlog.ldf"

Did you get it running now?

What were you doing? Moving the system databases?

Newbie777
Starting Member

20 Posts

Posted - 2010-12-21 : 16:56:28

How do I get it to look like that?

I was trying to move the model database. no it doesn't look like that, it still looks like this:

Name Type Data
(Default) REG_SZ (value not set)
SQLArg0 REG_SZ -c -m -T3608

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-21 : 16:57:28

It sounds like he accidentally removed all startup parameters and then put in just the ones needed to start in single user mode. And then realized that was a mistake, but now the registry is messed up. Hand modifying the registry should do the trick.

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

Subscribe to my blog

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-12-21 : 17:39:26

Yep, that's what it sounds like.

Newbie777. right-click the registry key and choose export. Save it to the desktop or something.

Then, in regedit, delete all of the paramaters. Next type in the correct values. From the looks of your earlier posts, it should be exactly what I posted above, except on your F: drive where I had C:

Leave your -m -c and trace flag out for now. Let's get the SQL Service running 1st.

If all goes well, you can re-add them later.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources