Re: sp_change_users_login doesn't work for me

From: Russell Fields (rlfields@sprynet.com)
Date: 10/16/02 

From: "Russell Fields" <rlfields@sprynet.com>
Date: Tue, 15 Oct 2002 22:11:09 -0400

Eric,

First, you should be sure to note this comment: "sp_change_users_login can
be used only with the security accounts of SQL Server logins and users; it
cannot be used with Microsoft Windows NTŪ users."

If that is not your case, then a database should always restore with its
users, so I don't know what went wrong there. My first guess is that
something got run that deleted the users from the database.

Russell Fields
"Eric" <eric@nomailplease.com> wrote in message
news:30c901c27450$ca133fa0$3aef2ecf@TKMSFTNGXA09...
I've restored a database to a different instance. I know
about the sp_change_users_login proc, but my problem is
different. I have a login, but no associated database
user. When I run sp_change_users_login Report I get 0
orphaned users, but I can't log into the database. Anyone
seen this before?

Relevant Pages