Knowledgebase
emscom > emscom Help Desk > Knowledgebase

Search help:


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
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: 170
Rating (Votes): Article not rated yet (0)

 
« Go back

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