Re: NT AUTHORITY\SYSTEM SQL Server 2005

From: "Evergray" <forlists@xxxxxxx>
Date: Wed, 22 Feb 2006 15:09:41 +0200

This is done if your server instance (or SQL Server Agent for this instance)
is running under 'Local System' account.

--
WBR, Evergray
--
Words mean nothing...

"Mike" <Mike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:817D30A0-53DD-4761-ACAA-B48133636DD7@xxxxxxxxxxxxxxxx

I am reviewing SQL security on an existing server. Can anyone think of a
reason why NT AUTHORITY\SYSTEM would be granted sysadmin permissions?

Thank you.
--
Mike

Prev by Date: Re: how to know simultaneous connected count to a Database?
Next by Date: Re: SQL2005 Allow Login Limited Visibility
Previous by thread: how to know simultaneous connected count to a Database?
Next by thread: Re: Any valid login can access Enterprise Manager
Index(es):
- Date
- Thread

Relevant Pages

Re: Browsing for Publication error message
... what is going on with the description you gave previously but I would guess that the subscriber SQL Server Agent service account was somehow added to the publication access list of the publication on the DMZ. ... select from the MSpublication_access table in the distribution database and see if the account for your Subscriber's SQL Server Agent service account shows up. ...
(microsoft.public.sqlserver.replication)
Re: Problems with SQL Srv. Agent and Proxy Account
... Windows Account. ... SQL Server Agent, try adding this account to the local ... >Password verification of the 'SQLAgentCmdExec' proxy ...
(microsoft.public.sqlserver.security)
Re: Re-installing SP4
... > I will try unregistering the components with the service account but what ... >> guessing that you want a cleaner approach so you are wondering if an SP4 ... >> 1) SP4 setup could not retrieve information for the SQL Server Agent ... >> privilege to enumerate the Agent service account information. ...
(microsoft.public.sqlserver.replication)
Re: Distributor SQLSERVERAgent Account
... your subscriber's sql server agent should be running ... under the same account as the publisher's SQL Server agent, ... that is part of the local admin group on the publisher. ... If this is not possible the SQL Server agent account on the subscriber ...
(microsoft.public.sqlserver.replication)
Re: SQLSERVERAGENT service hung on starting
... For the first reason, I confirm that the account user is inthe admin local ... A - Unable to start mail session ... > Your SQL Server Agent will now be stopped instead of stuck in starting mode. ...
(microsoft.public.sqlserver.tools)