SQL Server error: 15404, maintenance plan cannot be executed

Error symptoms:

D:\Program Files\Microsoft SQL Server\mssql.1\mssql\log below Erroelog, hit with text, view run dimension plan unsuccessful is the generated error log details: 2011-08-11 14:16:48-! [298] SQL Server error: 15404, unable to get information about Windows NT Group/user ' computer name \administrator ', error code 0x534. [SQLSTATE 42000] (Connisloginsysadmin).

Resolution and Cause:

1. First write a SQL statement to backup the specified database to be successful.

2. According to the error log details inferred that the database in the execution of the maintenance plan is to use a domain control user (System administrator), and we for the server security, the default system administrator name is often changed, so that the task schedule cannot be performed.

3. The workaround is to first change the SQL security-to-login name to the user name that is now used, and then delete the existing maintenance plan to re-build the maintenance plan.

4. The problem has been resolved.

SQL Server server renaming and adding a Windows logon name

The virtual machine installed SQL server, found that the server name has been forgotten to change. As a result, the server name is changed and the add Windows login is removed in SQL Servers.

Change your Windows computer name directly and restart your computer

Logging on to SQL Server failed after rebooting the system. Because the current Windows default logon name is not in the database.

Now let's stop the database agent.

Open the command line to start the service as an administrator (single user) on the local server:net start mssqlserver/m

Start the named instance Service:sqlcmd-e-S Kk-db1\mssqlservera

Or: Add a "-M" option to the SQL startup parameter (remember to add a semicolon before-m)

You can then log in to SQL Server to create a Windows login and authorize the sysadmin

or continue to login at the command line to create a login and authorize, and then exit the restart service after completion.

Sqlcmd-e-S "kk-db1"

CREATE LOGIN [Kk-db1\administrator] from WINDOWS

Go

EXEC Master. sp_addsrvrolemember @loginame = n ' kk-db1\administrator ', @rolename = n ' sysadmin '

Go

Another way to add a Windows logon name in SQL Server:

Before you change the Windows name, log on to SQL Server, select SQL Server and Windows Authentication mode, and enable the SA account.

After you change the Windows name, you can add the Windows logins by using the SA logon SQL Server

Change the name and change the server name of the record in the database, and then restart the SQL Servers service

[SQL]View Plaincopy print?

1. --Take serverproperty (' SERVERNAME ') as the subject
3. SELECT @ @servername
4. Select SERVERPROPERTY (' servername ')
6. sp_dropserver ' oldname '
7. Go
8. sp_addserver ' NewName ',' local '
9. Go

--Take serverproperty (' SERVERNAME ') as the SELECT @ @servernameselect serverproperty (' SERVERNAME ') sp_dropserver ' oldname ' Go sp_addserver ' NewName ', ' local ' go

SQL Server error: 15404, maintenance plan cannot be executed