Re: Add Login to the Master Database

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@xxxxxxxxxxxxxxxx> wrote in
message news:5ABCE903-3EB2-401E-AE32-94B6FA63248B@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OF7btPliHHA.4064@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxx> wrote
in
message news:e8PPiSgiHHA.4032@xxxxxxxxxxxxxxxxxxxxxxx
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.



.

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • RE: SQL Server Errorlog login Failure
    ... the login error. ... If your replication agents are proper, ... agent startup account etc to resolve it. ... ||I have an Windows account that runs all my SQL Server ...
    (microsoft.public.sqlserver.replication)
  • Re: sp_revoke login is not working as expected.
    ... when I use DROP LOGIN and subsequently try to connect i get the folloiwng ... Since sysadmin role members are mapped to the dbo user in all databases, ... SQL Server MVP ... All of them are also a part of a windows group which has required ...
    (microsoft.public.sqlserver.security)
  • Re: xp_cmdshell issue, local system
    ... So initially I tried to change the login using EM, ... account to the localsystem for SQL Server and the same for agent which worked ... Now when I go and try the same for the agent startup account it ...
    (microsoft.public.sqlserver.security)
Quantcast