Running the maintenance plan fails with the SQL Server error: 15404 SQLSTATE 42000
search cancel

Running the maintenance plan fails with the SQL Server error: 15404 SQLSTATE 42000

book

Article ID: 304509

calendar_today

Updated On:

Products

VMware

Issue/Introduction

Symptoms:
  • The maintenance plan fails to complete
  • In the SQL Server logs located at %INSTALLDIR%\Microsoft SQL Server\MSSQL.<x>\MSSQL\LOG\SQLAGENT.OUT, you see the error:

    SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'Domain\user.name', error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)


Resolution

To resolve this issue:
  1. Launch Microsoft SQL Server Management Studio and connect to the database.
  2. In the Object Explorer, navigate to SQL Server Agent > Jobs.
  3. Right click the maintenance plan that you used during the initial creation of the job and click Properties.

    Note: The maintenance plan has the format MaintenancePlan_Name.Subplan_x.

  4. Navigate to Job Properties > General Page.
  5. Set the value of Owner to SA.
  6. Click OK.


Additional Information

メンテナンス プランを実行すると次の SQL Server エラーで失敗する： 15404 SQLSTATE 42000
运行维护计划失败并显示 SQL Server 错误 15404 SQLSTATE 42000

Powered by Wolken Software