Tuesday, February 21, 2012

Restore

I have successfuly restored one of my SQL databses to another SQl server. A
problem arrises that I get error messages stating that a user cannot login to
the databse in an application. I believe through my research that there is a
orphaned user. The user exists in the sususers table of the individual
dtabase but thre is not entry in the sysxlogin of the master databse. How do
I resolve this?
Read about sp_change_users_login in Books Online. It'll fix it for you. Or search KB for
sp_help_revlogin, which will export the login from source to destination server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:A7B87862-E3C1-47D8-9514-937FC45F6EAC@.microsoft.com...
>I have successfuly restored one of my SQL databses to another SQl server. A
> problem arrises that I get error messages stating that a user cannot login to
> the databse in an application. I believe through my research that there is a
> orphaned user. The user exists in the sususers table of the individual
> dtabase but thre is not entry in the sysxlogin of the master databse. How do
> I resolve this?

No comments:

Post a Comment