Post reply

Configuring Database Mirroring

  • 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

  • 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

  • October 22, 2011 at 12:02 pm

    #1398364

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

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

  • 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....

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply