Re: SQL Accounts on Mirror
- From: "Laurentiu Cristofor [MSFT]" <Laurentiu.Cristofor@xxxxxxxxxx>
- Date: Mon, 29 Jan 2007 17:05:34 -0800
Answer is on
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1158265&SiteID=1.
--
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.
"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
.
- Prev by Date: Re: Non-SA can't view Activity Monitor with VIEW SERVER STATE perm.
- Next by Date: Setuser failed?
- Previous by thread: Re: SQL Accounts on Mirror
- Next by thread: Re: SQL Server and SSL
- Index(es):
Relevant Pages
|
