Re: Login problem

From: Ragnar Midtskogen (ragnar_ng_at_newsgroups.com)
Date: 04/30/05 

Date: Fri, 29 Apr 2005 21:22:34 -0400

Thank you Jens,

You hit the nail on the head!
I did not notice it, but the database username I was having problems with
does not have a login name, but there is a login with that name, so I
thought everything was OK.
And, sure enough, when I run the sp_change_users_login, the user can log in
to the DB again.
Of course, the acid test of the fix will come when I do the next restore.

I am puzzled how this happened though, I did not set up the DB on the backup
server, but I know it was created initially by restoring a backup from the
live server.
And the user could log in until I did a restore with recent data..

Thank you, made my day!

Ragnar

Relevant Pages