locked
Mirroring and Domains RRS feed

  • Question

  •  

    I not too hot on networking.  When I type "IPCONFIG /ALL" the "Prmary DNS Suffix" is empty.  Does this mean I have no domain?  Can I configure a mirror on this server?

     

    Thanks in advance.

     

    Monday, September 24, 2007 9:35 AM

All replies

  • Yes, you can configure a mirror to the server.  You do not have to be in a domain to do mirroring, although it makes it a bit easier to manage the accounts at a Windows level.

     

    Mirroring operates under the security context of the SQL Server service account.  That means the SQL Server service account on the instance hosting the principal must have been granted CONNECT permissions on the instance hosting the mirror.  It additionally needs dbo authority to the mirror database.  Likewise, the SQL Server service account on the instance hosting the mirror needs to have been granted CONNECT permissions on the instance hosting the principal as well as dbo authority on the principal database.

     

    Saturday, September 29, 2007 7:23 AM
  • Michael I'll be glad if you could clarify my doubt with respect to service account !
    Can we have the same Sql service account in both the sql servers and configure mirroring ? also if there are 2 different service account for principal and mirror servers can we configure mirroring ?

    This might be a simple question but i am confused at this  !  your help is very much appreciated  Smile

    Thanxx
    Deepak

    Saturday, September 29, 2007 9:40 AM
  • Yes.  If you use a local account on both machine that has the exact same name and password, then you wind up with Windows doing passthrough authentication.  (Although this practice is frowned upon.)  If you have 2 different service accounts, you can still do mirroring.  You just have to make sure the permission conditions I outlined above are true.

     

    Saturday, September 29, 2007 10:12 AM
  • When I tried to set this up using the Management Studio I got an error?

     

    Tuesday, October 2, 2007 7:52 AM
  • Have you tried to use the T-SQL commands to set this up instead of relying on pointing and clicking through the GUI?  Not everything will configure with the GUI, Database Mirroring outside of a domain andn using certificates is one of those things which the GUI has no clue how to do.

    Tuesday, October 2, 2007 1:50 PM
  • Not yet, but I will be using this article to configure it http://msdn2.microsoft.com/en-us/library/ms191140.aspx

     

    However, it might be a few weeks before I get chance.

    Tuesday, October 2, 2007 1:55 PM