INF: Starting SQL Server Remotely

ID: Q47271

The information in this article applies to:

SUMMARY

This article describes how to start SQL Server remotely.


MORE INFORMATION

If the specified server is not running when SAF is started, a prompt appears asking whether or not to start it. Another way is to use the NET ADMIN command as follows:

NET ADMIN \\server-name /COMMAND net start sqlserver

If share-level security is active, ADMIN$ must be shared. If ADMIN$ was shared with a password, that password must be used in the NET ADMIN command. For more information, see Chapter 13 of the "Microsoft LAN Manager Administrator's Guide."

If user-level security is active, the workstation must be NET LOGged on to an account with ADMIN privilege. For more information, see Chapter 10 of the "Microsoft LAN Manager Administrator's Guide."

Additional query words: net admin administration remote 


Keywords          : kbnetwork SSrvLAN SSrvSAF 
Version           : 4.2
Platform          : OS/2 
Issue type        :

Last Reviewed: March 9, 1999