Error to start SQL Server 2005 from the command prompt in single user mode

[vinodk_patel]

HI All

I want to restore master database in SQL Server 2005. I am trying to start SQL Server from the command prompt in single user mode.

I am using “Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)”

But it gives error like that

SQL Server could not find the specified named instance (M90TEST2$SQL2K5) - please specify the name of an existing instance on the invocation of sqlservr.exe.

If you believe that your installation is corrupt or has been tampered with, uninstall then re-run setup to correct this problem.

Mu computer name is M90TEST2 and instance name is SQL2K5


Any body has any idea

Thanks in advance

Vinod

[rmiao]

What's the command you used? By the way, you can start sql service in single user mode as well. Just put -m in start parameters.

[vinodk_patel]

I have used
SQLSERVR -sM90TEST2$SQL2K5
in dir
C:\Program Files\Microsoft SQL Server\MSSQL\Binn>

[rmiao]

Tried this?

SQLSERVR -S M90TEST2\SQL2K5 -E -m

[vinodk_patel]

rmiao

It give error as follow
---------------------------


Your SQL Server installation is either corrupt or has been tampered with (Error getting instance ID from name.). Please uninstall then re-run setup to correct this problem

[rmiao]

If the machine has multiple instances, you need to run the command in correct sql directory (~mssql$SQL2K5\binn in your case). Otherwise, ensure you can start the instance normally.

[vinodk_patel]

I have already run command from the correct directory. I mean from the ...binn

[rmiao]

Can you start the instance normally?