Gday,

I have a SQL Server 2005 Enterprise edition installation in our office.

When I run the Sql Server Agent, I get a
Failure Audit:
Login Failed for user 'NT AUTHORITY\SYSTEM [ Client: <Local machine>]

with the additional data indicating ss\Enterprise db Master as the failure.

I then looked intot he sql server logs, and found a

2007-04-27 13:24:00.96 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
2007-04-27 13:25:00.96 Logon Error: 18456, Severity: 14, State: 16.

Message repeated once a minute.

I know NOTHING About sql server logins or the authentication scheme. This
is why I'm here.

Could you guys please walk me through adding the user and login to the
master database including all the little things that I would need to do in
order to get the login to work. It makes it very difficult for me to view
other important info in the logs when this is occuring. I'd also actually
like to schedule some tasks etc so having the agent would be beneficial.

Thanks guys.

Try:

CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH
DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
go
EXEC sp_addsrvrolemember 'NT AUTHORITY\SYSTEM', 'sysadmin';
GO


--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Steven Spencer (Spinalogic)" <Spence-Spinalogic (AT) newsgroup (DOT) nospam> wrote in
message news:e8PPiSgiHHA.4032 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Gday,

I have a SQL Server 2005 Enterprise edition installation in our office.

When I run the Sql Server Agent, I get a
Failure Audit:
Login Failed for user 'NT AUTHORITY\SYSTEM [ Client: <Local machine>]

with the additional data indicating ss\Enterprise db Master as the failure.

I then looked intot he sql server logs, and found a

2007-04-27 13:24:00.96 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
2007-04-27 13:25:00.96 Logon Error: 18456, Severity: 14, State: 16.

Message repeated once a minute.

I know NOTHING About sql server logins or the authentication scheme. This
is why I'm here.

Could you guys please walk me through adding the user and login to the
master database including all the little things that I would need to do in
order to get the login to work. It makes it very difficult for me to view
other important info in the logs when this is occuring. I'd also actually
like to schedule some tasks etc so having the agent would be beneficial.

Thanks guys.

Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
2007-04-29 23:47:00.84 Logon Error: 18456, Severity: 14, State: 16.
2007-04-29 23:47:00.84 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local machine>]



So now the plot gets thicker. I ensured that the login added succesfully
and appeared in the list. I have also ensured that the login is in the
"master" database.

It owns the schemas
db_Accessadmin
db_backupoperator
db_ddladmin
db_owner
db_securityadmin
SS\SqlServer2005MSFTEUser$$SS$ENTERPRISE

And the database role membership
db_owner

Its login name is NT AUTHORITY\SYSTEM

Do you need any more info to help? Just reiterating, whatever permissions
are necessary, they are for the SQL Server Agent.

"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

Under which account is the SQL Agent service running? Can you use a domain
account instead? Can you give us a list of the members of the sysadmin
role? Also check out:

http://support.microsoft.com/kb/237604/


--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Steven Spencer (Spinalogic)" <Spence-Spinalogic (AT) newsgroup (DOT) nospam> wrote in
message news:5ABCE903-3EB2-401E-AE32-94B6FA63248B (AT) microsoft (DOT) com...
Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
2007-04-29 23:47:00.84 Logon Error: 18456, Severity: 14, State: 16.
2007-04-29 23:47:00.84 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local machine>]



So now the plot gets thicker. I ensured that the login added succesfully
and appeared in the list. I have also ensured that the login is in the
"master" database.

It owns the schemas
db_Accessadmin
db_backupoperator
db_ddladmin
db_owner
db_securityadmin
SS\SqlServer2005MSFTEUser$$SS$ENTERPRISE

And the database role membership
db_owner

Its login name is NT AUTHORITY\SYSTEM

Do you need any more info to help? Just reiterating, whatever permissions
are necessary, they are for the SQL Server Agent.

"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote