Color scheme: Dark
You are here: start » en » Documentation » Data integration and data access » WKL Database Gateway » Troubleshooting » "Der Dienst kann diese Anmeldung in SQL Server nicht annehmen" (The service can't assume this login in SQL Server) after renaming an account

"Der Dienst kann diese Anmeldung in SQL Server nicht annehmen" (The service can't assume this login in SQL Server) after renaming an account

A person whose Windows account was renamed gets the response 403 “Der Dienst kann diese Anmeldung in SQL Server nicht annehmen.” on an alias with Persons: Impersonate; the log shows SQL Server error

Environment

Alias with Persons: Impersonate; Windows logins in SQL Server.

Cause

SQL Server keeps the login of a renamed account under the old name. The service finds it by the SID; but SQL Server can't switch to it, because it resolves the stored name through Windows and fails (15404, Windows code 0x534)—even as sysadmin.

Resolution

Rename the login in SQL Server as well:

ALTER LOGIN [CORP\OLD] WITH NAME = [CORP\NEW];

Verification

The person's next request responds 200; SUSER_SNAME() returns the new name.

en/wiki/data-conectivity/database-gateway/troubleshooting/renamed-windows-account.txt · Last modified: by Wolfgang van der Stille