change the login id for a user

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

DId you try sp_change_users_login with the auto_fix action? Or what did you do exactly?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Supernova Hakeem SSC Veteran Points: 284 More actions · Answer 2

I typed the following command with sa login id:

exec sp_change_users_login "Update_One", "dbo", "sa"

Server: Msg 15287, Level 16, State 1, Procedure sp_change_users_login, Line 34

Terminating this procedure. 'sa' is a forbidden value for the login name parameter in this procedure.

Karen Jackson Say Hey Kid Points: 686 More actions · Answer 3

Have you tried:

sp_changedbowner 'sa'

If memory serves me right - I think there is an issue with using 'sa" with add user type stored proc

karen

Supernova Hakeem SSC Veteran Points: 284 More actions · Answer 4

Hi Karen,

Thanks for the advice. Can you elaborate a bit on your advice? I don't understand. THanks.

Supernova

Supernova Hakeem SSC Veteran Points: 284 More actions · Answer 5

SSC Veteran

Points: 284

July 21, 2002 at 6:36 pm

Does anyone know how to solve this problem?

Andy Warren SSC Guru Points: 119902 More actions · Answer 6

How about sp_addalias?

Andy

Supernova Hakeem SSC Veteran Points: 284 More actions · Answer 7

I solve the problem by running sp_changedbowner "sa" . Thanks to all who helps.

Supernova