Re: Running SQLServer and SQLServer Agent as Power User
From: Hansde Bruin (hans_at_nl.invalid)
Date: 03/24/05
- Next message: ron.bennatan_at_gmail.com: "How to (completely) turn off protocol encryption in SQL Server? (the checkbox in server network utility is unchecked)"
- Previous message: gbledsoe: "Re: Running SQLServer and SQLServer Agent as Power User"
- In reply to: gbledsoe: "Running SQLServer and SQLServer Agent as Power User"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 24 Mar 2005 22:57:46 +0100
gbledsoe wrote:
> We're trying to limit the number of user accounts with Admin level permission
> on our Win2K servers, especially SQL servers. We have created a domain level
> account to run SQLServer and SQLAgent. We'd like to limit it to Power User
> status instead of Admin status on the servers, but we cannot seem to start
> and stop the services from SEM with only Power User status. We've checked
> registry key permissions and everything seems to be configured properly. Is
> this configuration even possible? Or does this account NEED to be local admin
> on the server? Help would be appreciated. Thanks.
It should be, although not all sql feature are available. I am running
multiple instances with different plain domain user accounts. When you are
not sure about registry, user and ntfs permission change the account using
the enterprise manager.
When you need the proxy account to run scheduled dts packages create a
separate account for the sql agent service and make it local admin, unless
someone here can explain how to accomplice this without local admin rights.
have a look at this one:
http://support.microsoft.com/default.aspx?scid=kb;en-us;283811&sd=tech
-- Hans
- Next message: ron.bennatan_at_gmail.com: "How to (completely) turn off protocol encryption in SQL Server? (the checkbox in server network utility is unchecked)"
- Previous message: gbledsoe: "Re: Running SQLServer and SQLServer Agent as Power User"
- In reply to: gbledsoe: "Running SQLServer and SQLServer Agent as Power User"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
