sp_change_users_login 'Auto_Fix'

Question

sp_change_users_login 'Auto_Fix'

RGP

SSCarpal Tunnel

Points: 4381
More actions
July 29, 2008 at 11:17 pm

#194970

One quick question :
I was trying to fix a login using
EXEC sp_change_users_login 'Auto_Fix', 'fundsUser'
I got this message :
Msg 15600, Level 15, State 1, Procedure sp_change_users_login, Line 207
An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'.
Any suggestions

Viewing 3 posts - 1 through 2 (of 2 total)

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

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 1

When you use Auto_Fix, you must specify user and password if the login does not already exist, otherwise you must specify user but password will be ignored. login must be NULL. user must be a valid user in the current database. The login cannot have another user mapped to it.

got it from

http://technet.microsoft.com/en-us/library/ms174378.aspx">

http://technet.microsoft.com/en-us/library/ms174378.aspx

Atif Sheikh

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

RGP SSCarpal Tunnel Points: 4381 More actions · Answer 2

Atif Sheikh (7/30/2008)
When you use Auto_Fix, you must specify user and password if the login does not already exist, otherwise you must specify user but password will be ignored. login must be NULL. user must be a valid user in the current database. The login cannot have another user mapped to it.
got it from
http://technet.microsoft.com/en-us/library/ms174378.aspx">
http://technet.microsoft.com/en-us/library/ms174378.aspx
Atif Sheikh

thanks Atif