Re: SQL Accounts on Mirror
- From: "Steve" <morriszone@xxxxxxxxxxx>
- Date: 27 Jan 2007 16:36:08 -0800
LionPaw wrote:
-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
SQL Server 2005 Books Online
Managing Logins and Jobs After Role Switching
sp_change_users_login (Transact-SQL)
.
- Prev by Date: Re: Search encrypted column in SQL 2005http://msdn.microsoft.com/wn3/a
- Next by Date: Re: SQL Server and SSL
- Previous by thread: Re: Search encrypted column in SQL 2005http://msdn.microsoft.com/wn3/a
- Next by thread: Re: SQL Accounts on Mirror
- Index(es):
