Mirroring Port Endpoints Error

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

High Availability (2008)

Mirroring Port Endpoints Error

Author

Topic

jchrist79
Starting Member

7 Posts

Posted - 2010-09-06 : 03:54:11

I am trying to set up mirroring for a database called MirrorTest between two SQL Server 2008 instances on seperate machines. The machines are on the same domain and both instances are running under the same domain account. When I try to set the mirror as the partner for the principal instance I get the following error:

"The server network address "TCP://mirror.domain.net:5025" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational."

The error code is 1418. mirror is the name of the server hosting the mirror instance.

I've verified through the SQL Server Network Configuration in SQL Server Configuration Manager that both the mirror and principal are set up to allow TCP/IP connections. I've checked that the ports I have specified for the mirroring endpoints can be connected to using telnet from both servers. I've checked that SQL Server is using these ports by running netstat -abn on both servers. I cant figure out where I'm going wrong!

Before anyone asks, here are the TSQL commands I used:

To create the mirroring end points on both principal and mirror (they use the same port number on different machines):


    CREATE ENDPOINT MirroringEndPoint
    
        STATE = STARTED
        AS TCP ( LISTENER_PORT = 5025 )
        FOR DATABASE_MIRRORING (
           AUTHENTICATION = WINDOWS KERBEROS,
           ENCRYPTION = SUPPORTED,
           ROLE=PARTNER);
    GO

Then restored the MirrorTest database onto the mirror server with NORECOVERY specified:


    RESTORE DATABASE MirrorTest 
    FROM DISK = 'G:\Backup\MirrorTest.bak' 
    WITH NORECOVERY,
    MOVE 'MirrorTest' TO 'G:\Data\MirrorTest.mdf',
    MOVE 'MirrorTest_log' TO 'G:\Data\MirrorTest_log.ldf'
GO

    RESTORE LOG MirrorTest
    FROM DISK = 'G:\Backup\MirrorTest_log.bak' 
    WITH FILE=1, NORECOVERY
GO

Then I tried to partner the mirror with the principal by running this on the mirror first


    ALTER DATABASE MirrorTest
    SET PARTNER = 'TCP://principal.domain.net:5025'

and then running this on the principal at which point I get the error


    ALTER DATABASE MirrorTest
    SET PARTNER = 'TCP://mirror.domain.net:5025'

Any ideas anyone?

--------------------

Cheers,
James

jchrist79
Starting Member

7 Posts

Posted - 2010-09-07 : 03:23:56

I checked the SQL error log and found this entry which may provide further information:

2010-09-07 17:17:39.43 Logon Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (80090303) 0x80090303(The specified target is unknown or unreachable). State 66.'. [CLIENT: 159.137.45.68]

--------------------

Cheers,
James

jchrist79
Starting Member

7 Posts

Posted - 2010-09-07 : 03:41:41

Ok found the answer here: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_26294382.html

Turns out it was the Windows Kerberos authentication specified for the endpoints which was causing trouble. I changed it to plain Windows and it worked.

--------------------

Cheers,
James

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources