I'm trying to start/stop MS SQL Service on various DB servers (locally) but we don't always know the name of the instance (Always only 1 SQL Server running on a single server).

To rebuild a corrupted master database, you must run an instance of SQL Server in single-user mode, which prevents multiple clients from connecting to the server at the same time.

After reboot, you will be able start SQL Server and connect from client machines using Named Pipes 7. Take a backup and delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1 ...