Wednesday, March 18, 2009

#blogger  We got hit by Conflicker.c virus and have been feeling the effects for the past week. This virus spreads by e-mailing itself to everyone in the Outlook Address Book. My admin account was one of those and virus tried to send itself out using my account and while trying to authenticate, my admin account got locked out. Our server admins renamed all of the admin accounts and inserted a special character so that they would be invisible. The problem that affected my SQL Servers was that when you login with Remote Desktop to create SQL Jobs and Maintenance Tasks, SQL Server makes you the owner of the given task.  Obviously my admin account cannot be found anymore and job fails. A fix is pretty easy though, assign a sql login, i.e. SA or some other as the owner of SQL Jobs.    [image: Error.jpg]

We got hit by Conflicker.c virus and have been feeling the effects for the
past week. This virus spreads by e-mailing itself to everyone in the Outlook
Address Book. My admin account was one of those and virus tried to send
itself out using my account and while trying to authenticate, my admin
account got locked out. Our server admins renamed all of the admin accounts
and inserted a special character so that they would be invisible. The
problem that affected my SQL Servers was that when you login with Remote
Desktop to create SQL Jobs and Maintenance Tasks, SQL Server makes you the
owner of the given task. Obviously my admin account cannot be found anymore
and job fails. A fix is pretty easy though, assign a sql login, i.e. SA or
some other as the owner of SQL Jobs.



[image: Error.jpg]
Post a Comment