Re: SQL Accounts on Mirror

Hi LionPaw,

You need to copy your logins manually. You can find more information here: http://support.microsoft.com/kb/918992/en-us

Hope this helps!!
--
Antonio Soto
Solid Quality Learning
http://www.sqlu.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference
"LionPaw" <LionPaw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:C2224DA7-AA43-4508-82DE-01DEDC5D6D5E@xxxxxxxxxxxxxxxx
-On the Principle (sql1) I have a Database named dbBooks

-I create a SQL Account called Dog and password of Cat and give it
read/write to dbBooks

-I fail the morror to (sql2) , Dog is an account on the databse, but not at
the server level and I cant log in with it.

-I then create SQL account Dog at the Server Level of sql2 and give it a
password of Cat. - Still fail to log in.

Should I be able to create a SQL account on a Principle, fail it over and
have that account still work on another server? What else do I need to do?

Thank You


PSU Guy

.