TSQL Resolve orphaned user after restore

Solution

Restoring a data base to a foreign SQL server may cause user accounts defined in the database schema to be orphaned from an SQL login account.

To resolve the disconnect use the following TSQL

USE <db>; ALTER USER <dbUser> WITH LOGIN <server login>

e.g.

USE Publishers;

ALTER USER pubUser WITH LOGIN serverLogin

Was this article helpful? yes / no

Article details