SQL database management processing issues-maintenance plan

Issue: SQL Server error: 15404, unable to get information about Windows NT Group/user Mypc/administrator ', error code 0x534. [SQLSTATE 42000] (connisloginsysadmin)

Confirm Login Name

Security-Login Name: Confirm Administrator user name prefix xxx/administrator, verify that XXX is the native user name, and sometimes change the user name after this problem occurs. Change to native user name/administrator after resolving

Confirm Connection

When executing a T-SQL task, confirm the user name used by the connection and recommend creating a connection using a SQL system user

Generally the above method can solve this error

Operation method

1. Modify the XXX cost machine computer name

2. Set the database for user mappings

Finally, you have to restart the service!

SQL database management processing issues-maintenance plan