Re: sql server start/stop security
From: Uri Dimant (urid_at_iscar.co.il)
Date: 11/18/04
- Next message: SqlJunkies User: "Re: can't add current login as user"
- Previous message: dimsdale_007: "sql server start/stop security"
- In reply to: dimsdale_007: "sql server start/stop security"
- Next in thread: Sue Hoegemeier: "Re: sql server start/stop security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 18 Nov 2004 16:55:30 +0200
Hi
It will be much better if you don't use 'sa' to administrate SQL Server.
Instead , use your Windows account.
Remove this person from Admin group on the server.
"dimsdale_007" <dimsdale007@discussions.microsoft.com> wrote in message
news:A3E9D420-348E-4155-9515-8E31B69D5740@microsoft.com...
> i have my sa account set as the one that starts/stops the server.
however,
> one of my admins logged onto another machine and stopped the server during
> production! is there a way to restrict everyone from be able to log on
the
> machine, or remote into the machine and stop/start the service except for
> myself?
>
> thanks,
- Next message: SqlJunkies User: "Re: can't add current login as user"
- Previous message: dimsdale_007: "sql server start/stop security"
- In reply to: dimsdale_007: "sql server start/stop security"
- Next in thread: Sue Hoegemeier: "Re: sql server start/stop security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
