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?