Changing User Authentication

Question

Changing User Authentication

BC-353997

SSC Veteran

Points: 248
More actions
August 23, 2007 at 6:17 am

#176132

Hello,
I recently took on a new sql server 2000 where there are several logins using sql server authentication. Is there any easy way to switch the authentication mode to windows authentication for each user and preserve all the rights without dropping each login and creating new ones. Thanks in advance.
bc

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

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

Antares686 SSC Guru Points: 125444 More actions · Answer 1

No. The Account has no way to match to the NT Person or Group. You will need to record all their permissions and create the new account. Don't remove the old until complete that way you can still reference.

BC-353997 SSC Veteran Points: 248 More actions · Answer 2

That's what I feared. Thanks for the confirmation.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 3

There's no way to do this. The SQL login is not related to the Windows login. You could add the Windows login and map it to the database user, but not sure how well that would work.

You should move to roles to avoid this very problem.