Ver Mensaje Individual
  #11 (permalink)  
Antiguo 13/09/2012, 16:02
Avatar de Libras
Libras
Colaborador
 
Fecha de Ingreso: agosto-2006
Ubicación: En la hermosa perla de occidente
Mensajes: 7.412
Antigüedad: 18 años, 4 meses
Puntos: 774
Respuesta: Problema al configurar mirroring

http://msdn.microsoft.com/es-es/libr....aspx#StartDbm

http://blog.sqlauthority.com/2007/04...e-the-command/



Working solution.

1. Start MSSQLSERVER Services with Domain user credentials (instead of Local System Account) on principal database Server and Mirror Database Server.

Note: To switch from “Local System Account” to Domain User credentials do the following (a).

a) On Windows (XP or Server): Start -> Control Panel -> Administrative tools -> Services. Then right click on SQL Server (MSSQLSERVER). Then click on properties. And then click on tab “Log On”. And then choose radio button “this account”. Then provide the Domain user name and password.

If you want repeat (a) for all SQLSERVER related Services.

2. And then try the mirroring process in MS SQL Server Management Studio.
__________________
What does an execution plan say to t-sql query? Go f**k yourself, if you are not happy with me

Última edición por Libras; 13/09/2012 a las 16:08