July 13, 2008 at 6:37 pm
G'day guys,
I have a question about the maintenance report that is created when using the maintenance plan in SS 2000.
The first line says:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server ' ' as 'MERCURY\LouJ' (trusted)
But I can't work out why this is coming up as this user. This is not me, the maintenance plan is owned by me and the database is owned by 'sa'.
Anyone got any thoughts on this? I am trying to get rid of this user account from everywhere as the user has moved on and we need to blow his Windows account away.
Regards,
Gavin Boyce
DBA
July 13, 2008 at 7:19 pm
Check the service account that SQL Server Agent is running under. Make sure that the SQL Server Service account is not running under this user also if you are trying to get rid of the account.
July 13, 2008 at 7:38 pm
As Ken mentioned, you can set a job to run as SQL Agnet or another proxy account, so it's probably set for one of those.
July 13, 2008 at 8:12 pm
Cheers guys. I will check this out.
Gav
July 13, 2008 at 8:41 pm
when you right click the job-properties you see the owner, you might change the owner to some Other user acct, probably the SQl Server Agent Service actt. Or as mentioned above create a Proxy account.
Maninder
www.dbanation.com
July 13, 2008 at 9:32 pm
Yeah, I've got the owner set as me, as I set up the maintenance plan. I am just waiting on local admin rights to the server (only started here last week) so that I can check the other suggestion above.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply