February 5, 2008 at 6:20 am
Hi all,
I am using SQL 2005 (Enterprise Edition, SP2) Mirroring with a Principal, Mirror and Witness set to High Safety mode and am a little confused!
As far as I understand it, during a failover, although the database content will automatically be available on the Mirror any user accounts will need to be either manually created or manually mapped to the new principal. Is this the case? If so, I can't really see the purpose of using Mirroring.
For example - We principally use the database servers for our web applications which we connect to using ADO.NET. Each database and Web app has a different SQL user account to allow access etc. If we experience a failover this means the users will not be able to use the web app until we have manually recreated/mapped the SQL accounts for each and every database. Surely this is a massive oversight?! Or am I simply getting the wrong end of the stick.
Any help/guidance would be greatly appreciated!
Thanks,
Richard
February 5, 2008 at 7:27 pm
The users are transferred over, but you need to transfer the logins. Just as you would for any other move of a DB from one server to another.
See here: http://support.microsoft.com/kb/918992/
February 5, 2008 at 8:03 pm
Well, more than logins. Take a look here:
"Managing Metadata When Making a Database Available on Another Server Instance"
http://technet.microsoft.com/en-us/library/ms187580.aspx
It is "Database (user DB) mirroring" not a database server mirroring. Sounds make sense.
February 5, 2008 at 8:35 pm
Check this link where you can create the login in mirror server with the same SID of the principal server and after failover you dont need to map the logins. Refer, http://www.mssqltips.com/tip.asp?tip=1166
[font="Verdana"]- Deepak[/font]
February 7, 2008 at 1:04 am
Many thanks Deepak - it's all up and running now. 🙂
Richard
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply