Credentials for Mirroring
in [Replication]
|
Prev: Peer to Peer replication for partitioned table using sliding windo
Next: marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicotePara Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 60357
From: Kerry on 18 Feb 2010 19:41 Hello, We are mirroring a SQL Server 2008 Entreprise database over to another SQLServer on another server. We had issues setting this up due to the credentials the SQLServer service runs under (LocalSystem) seems it didn't have permissions to write over to the target server. To solve this we had to start the service under a domain userid that had access to both primary and target server. Is there a way to mirror a database from one server to another without using a domain user id. Thank you.
From: B.Edwards on 24 Feb 2010 17:30
See the following: http://technet.microsoft.com/en-us/library/ms191140.aspx or google: database mirroring using certificates "Kerry" <Kerry(a)discussions.microsoft.com> wrote in message news:C9E0D512-6D05-4AAB-9435-6AD434B0D81B(a)microsoft.com... > Hello, > > We are mirroring a SQL Server 2008 Entreprise database over to another > SQLServer on another server. We had issues setting this up due to the > credentials the SQLServer service runs under (LocalSystem) seems it didn't > have permissions to write over to the target server. To solve this we had > to > start the service under a domain userid that had access to both primary > and > target server. Is there a way to mirror a database from one server to > another without using a domain user id. > > Thank you. |