July 5, 2011 at 6:57 am
Trying to configure db mirroring using database properties> mirroring and after I have added 2 servers and a witness and then start mirroring it fails trying to connect to the backup server.
The server network address can not be reached
There are no port conflicts
each server can be pinged from the others
port 5022 is used on principal and backup - both separate servers
port 5023 is used on witness, which is a named instance on the principal
all ports are open and listening - netstat -a -p tcp
I leave login names empty in the wizard also tried a domain\username that has login rights on all 3 servers.
This is test environment and all instances other than witness are default instances - patched to (64 bit) SP4 on Windows Server 2003 sp2 - vm servers
July 5, 2011 at 7:17 am
post the error detail
July 5, 2011 at 7:47 am
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database '**********'. (Microsoft.SqlServer.Smo)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The server network address "TCP://************:5022" 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.
(Microsoft SQL Server, Error: 1418)
July 5, 2011 at 7:50 am
the following link: http://msdn.microsoft.com/en-us/library/ms189921.aspx for connections between servers of mirror!
July 5, 2011 at 8:03 am
Thanks for your help. I've tried the methods suggested in the link but I still get the same error. All the endpoints on the servers are correct, the logins have the correct permissions, I can connect to the server from EMS but not after i click start mirroring - I'm using SQLserver 2005 so the T-sql i used was,
CREATE ENDPOINT Endpoint_Mirroring
STATE=STARTED
AS TCP (LISTENER_PORT=5022)
FOR DATABASE_MIRRORING (ROLE=PARTNER);
GO
on both principal and mirror.
ROLE=WITNESS on the witness server and PORT=5023
July 5, 2011 at 8:37 am
the follow link, contain several steps for find out solution!
http://msdn.microsoft.com/en-us/library/aa337361(v=SQL.90).aspx
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply