November 18, 2003 at 7:24 am
Moan, groan....
Got this one wrong, as I thought it was a trick question.
You don't remove the USER, as the answer says, you need to remove and recreate the LOGIN.
November 18, 2003 at 7:54 am
Something that I have used for several years and works quite well (never had an issue) is to use:
sp_change_users_login 'report'
in combination with
sp_change_users_login 'Auto_Fix', 'userid'
November 19, 2003 at 2:20 am
I didn't like the question either.
It says : 'create the same SQL Server authenticated user there (giving it the necessary permissions). '
Especially the part between brackets is misleading. I was very suspicious. And got it right. This is a trick question.
Maybe it is better to leave out questions that end with 'What is the most likely cause?
'. This is always subject for interpretation.
Erik
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply