emscom > emscom Help Desk > Knowledgebase

Search help:

TSQL Resolve orphaned user after restore


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>


USE Publishers;

ALTER USER pubUser WITH LOGIN serverLogin


Was this article helpful? yes / no
Related articles OSX XTerm environment not set
XP auto logon
Re-establish broken trust relationship
OSX SSH login
OSX MSSQL Server ODBC drivers
Article details
Article ID: 91
Category: SQL
Date added: 12-12-2016 12:21:17
Views: 202
Rating (Votes): Article not rated yet (0)

« Go back

Powered by Help Desk Software HESK, in partnership with SysAid Technologies