cannot stop SQL Server 2005 Service.

Hello,

My problem is,

I cannot stop SQL Server 2005 Service.

after "net stop sqlserver", not stop for all time.

but, I can kill process from task manager.

How can I fix this probelm ?

Environment:

OS: Windows XP SP 2

DB: SQL Server 2005 SP2, SQL Server 2005 SP2 Express Edition.

Regards,

Yoshihiro Kawabata

are you able to stop it from the services snap in?|||

Try "net stop mssqlserver /y" for default instance or "net stop mssql$<instance_name> /y" for named instance. This will force terminating any child process first before terminating sqlserver.

|||NO, I cannot stop services by Management Studio and Configuration Manager.|||

Thanks

But, I cannot stop services by 'net stop "sql server (sqlexpress)" /y '.

|||

what is the error msg u gets... is there any entry in log... is the loged in user is a privilaged user to do this... and also check you have local instance of sql server...

Madhu

|||

The correct syntax is:

net stop mssql$sqlexpress /y