Friday, March 30, 2012

Maintenance plan error!

Microsoft (R) SQLMaint Utility (Unicode), Version
[Microsoft SQL-DMO (ODBC SQLState: 28000)] Error 18456:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user 'NT AUTHORITY\SYSTEM'.Did you remove the BUILTIN\Administrators group or remove
that group from the sysadmin server role?
If so, you can add the login and add it to the sysadmin
server role using:
exec sp_grantlogin N'NT Authority\System'
and
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
-Sue
On Wed, 16 Jun 2004 12:50:32 -0700, "ss"
<anonymous@.discussions.microsoft.com> wrote:
>Microsoft (R) SQLMaint Utility (Unicode), Version
>[Microsoft SQL-DMO (ODBC SQLState: 28000)] Error 18456:
>[Microsoft][ODBC SQL Server Driver][SQL Server]Login
>failed for user 'NT AUTHORITY\SYSTEM'.sql

No comments:

Post a Comment