Changing SID of a USER

Hello can anybody out there help.

I am just getting ready to move a system to production using SQL 2005 and SQL Mirroring. The problem that i have is when the databases fails over my connection string user account losses its rights on the DB untill i run the SP_CHANGE_USERS_LOGIN script. I have been trying to come up with a method of getting around this so far the only fix that i have is to make my user account sysadmin but this is far from ideal for production, does anyone have any ideas i was thinking that changing the SID of the User so that they match might get over the problem.

Any help will be good

Matt.

Looks like the logins that map to those users are created with different SIDs in the mirrored instance. You should recreate them on the mirror using the same SID they have on the principal. Have a look at the SID clause of CREATE LOGIN.

Thanks
Laurentiu

|||

Thanks that has sorted the problem.

Matt