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.
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.
|||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
Thanxx
Deepak
|||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.
No comments:
Post a Comment