SQL Accounts on Mirror

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LionPaw - 26 Jan 2007 14:41 GMT

-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

Reply to this Message

Steve - 28 Jan 2007 00:36 GMT

> -On the Principle (sql1) I have a Database named dbBooks
>
[quoted text clipped - 13 lines]
>
> PSU Guy

SQL Server 2005 Books Online
Managing Logins and Jobs After Role Switching
sp_change_users_login (Transact-SQL)

Reply to this Message

Antonio Soto - 29 Jan 2007 09:04 GMT

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!!

Signature

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

> -On the Principle (sql1) I have a Database named dbBooks
>
[quoted text clipped - 15 lines]
>
> PSU Guy

Reply to this Message

Laurentiu Cristofor [MSFT] - 30 Jan 2007 01:05 GMT

Answer is on
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1158265&SiteID=1.

Signature

Laurentiu Cristofor [MSFT]
Software Development Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/

This posting is provided "AS IS" with no warranties, and confers no rights.

> -On the Principle (sql1) I have a Database named dbBooks
>
[quoted text clipped - 15 lines]
>
> PSU Guy

Reply to this Message