Re: Automatically stopping an SQL Service
From: Ashish Ruparel [MSFT] (v-ashrup_at_online.microsoft.com)
Date: 04/21/04
- Next message: Mal: "More Info: MSDE 2000 sp3a install causes err restart on win 98 and win ME"
- Previous message: Mal: "MSDE 2000 sp3a install causes error on restart only on win 98 and win ME"
- In reply to: Bob Day: "Re: Automatically stopping an SQL Service"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Apr 2004 05:42:34 GMT
Hi Bob,
-U option of the osql utility works only with the SQL Server
Authentication. You can enter the Windows Credential using the same.
-E uses the local logged in users credentials and tries to login to the SQL
Server using the Windows Authentication.
This is the reason why the first command was failing as the username
specified was not a valid SQL server user.
To stop the instance of a SQL Server running accross the network, you can
try using the Net Stop <Servername> command.
or pass the SQL server login and password for connecting to the remote
server.
More information about the osql Utility can be found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp
_osql_1wxl.asp
and at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8
_mta_01_2r1e.asp
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
- Next message: Mal: "More Info: MSDE 2000 sp3a install causes err restart on win 98 and win ME"
- Previous message: Mal: "MSDE 2000 sp3a install causes error on restart only on win 98 and win ME"
- In reply to: Bob Day: "Re: Automatically stopping an SQL Service"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
