Sqlserver error: 15404. Unable to obtain information about Windows NT group/user mypc/administrator. Error code: 0 × 534. [Sqlstate

Problem:

Confirm Login Name

Security-Login Name: confirm the administrator username prefix xxx/administrator, and confirm whether XXX is the user name of the Local Machine. Sometimes this problem occurs after the user name is changed. Change to the local user name/administrator.

 

Confirm connection

When performing a T-SQL task, confirm the user name used for the connection. We recommend that you use the SQL System user to create a connection

 

Generally, the above method can solve this problem.