Configuring Database Mirroring

• jshailendra

  SSCrazy

  Points: 2260

  More actions

  October 22, 2011 at 3:14 am

  #244940

  Hi,

  I am in process of configuring database mirroring for few database on SQL Server 2005 PROD environment. I am using synchronous mode with automatic fail-over.

  I have successfully configured 8 databases, but while "Start Mirroring" step for 9th database, I get error:

  Alter Failed for database 'MyDB' (Microsoft.SqlServer.Smo)

  An exception occured while executing a Transact-SQL statement or batch

  (Microsoft.SqlServer.ConnectionInfo)

  Communication to the remote server instance 'TCP://MirrorServerName.Domain.com:<port number>' failed before database mirroring was fully started. The ALTER DATABASE command failed. Retry the command when remote database is started. (Microsoft SQL Server, Error: 1413)

  Recommendations or checks to fix this issue is most appreciated.

  Thanks,

  Shailendra

• SQL Galaxy

  One Orange Chip

  Points: 29478

  More actions

  October 22, 2011 at 4:53 am

  #1398311

  That's the generic mirror error. Usually its communications based. I would suggest and check the below

  1.Firewall

  2. port being used already

  3. named pipes not enabled

  4. remote connections not allowed

  5. TCP/IP port not enbaled

  6. check mirror port Principal -5022, Mirror - 5023, witness-5024

  Mirroring set up with a user that hasn't sys and windows admin access on other side of mirror

  rgds

  ananda

• jshailendra

  SSCrazy

  Points: 2260

  More actions

  October 22, 2011 at 12:02 pm

  #1398364

  I resolved the issue...following KB helped me..

  http://support.microsoft.com/kb/947462.

• nani_varaprasad

  Grasshopper

  Points: 12

  More actions

  October 27, 2011 at 5:43 am

  #1400076

  Shailendra, you made wonders to me.. i was struggling for mirroing..with your link i succeeded... top man....