Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I currently setup a DBMP for SS2008 and i explicitly set it to run under a user that is the the serveradmin role. Also in the job (under sql server agent) generated from the above plan is set in the properties to run under the same sql account and I forced the job step to run as a windows admin account other than the default "SQL Server Agent Service account", restarted sql server agent but the job keeps failling, throwing this error:

SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [SQLSTATE 28000]

I can't see what might be missing here... I'm explicitly saying to SQL Server agent to run the job under a diff account than 'NT AUTHORITY\NETWORK SERVICE'

Anyone has any idea, what i'm missing here?

Appreciated guys!

Regards.

share|improve this question
    
What account is your SQL Server Agent running as? Start> Run> services.msc right click SQL Server Agent service and go to properties. –  andyhky Nov 15 '10 at 16:41
    
Its running under Network Service. I already changed to admin account but problem still happens. The log in sql server says "Login access denied for the db i want to backup.." but the sql server account that i'm using is serveradmin and backup operator... should work fine i gues... :( –  byte_slave Nov 15 '10 at 21:41

1 Answer 1

I would recommend setting your SQL Server Agent to run as a different account. The account shouldn't have to be an admin account as long as you give it the proper permissions to any drives/shared directories it needs.

I'm not sure what you're doing to force a job to run as a particular account. The Server Agent has always been a bit finicky for me but when I run it as a domain account and assign that account the proper permissions I have very few issues.

share|improve this answer
    
Tried your tips but still not working. In job log history it complains about the login is denied for sql server user for that BD, but sql server account has serveadmin and backupoperator roles assigned to. –  byte_slave Nov 15 '10 at 21:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.