Welcome to weblogs.com.pk Sign in | Join | Help

SQL Server :: Maintenance Plan Jobs :: Login failed for user 'NT AUTHORITY\SYSTEM'

If you are running SQL Server under SYSTEM account, your SQL Server Agent is running under some non-SYSTEM account, you remove BUILTIN\Administrators account from SQL Server and you setup Database Maintenance Plan, you might experience problems executing Maintenance plan jobs.

If logs are saying that, Login failed for user 'NT AUTHORITY\SYSTEM'., recreate the BUILTIN\Administrators account. And be careful, the domain should read BUILTIN and not your machine name or Domain name.

It took considerable time while debugging the above problem….

Published Wednesday, August 3, 2005 2:19 PM by khurram


No Comments

New Comments to this post are disabled