SQL Server Mirroring
Posted on 2011-10-11
I have a Database setup that is being Mirrored to another Server in the same Workgroup on the same IP range (different physical locations). This current mirror is working.
Trying to add a Witness at a different location and on a different IP address range isnt working though. Their are already rules to transmit data for this IP range via routers to the site which all works fine. I can connect to each database from each as well so i know there are no real connection issues.
The error Im getting though however is ...
The ALTER DATABASE command failed due to an invalid connection string.
(this is from the command "ALTER DATABASE [ClickToCall] SET WITNESS = N'TCP://10.10.10.40\SQLEXPRESS:5022'")
If I remove the SQLEXPRESS part then I get...
The ALTER DATABASE command could not be sent to the remote server instance 'TCP://10.10.10.40:5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again. (Microsoft SQL Server, Error: 1456)
All the whislt, in the object explorer the database is connected.
The firewalls on each of the servers are off, even the tricky secondary ones, and the versions of each server are the same at 10.50.1600. Also, Before moving to the different sites, each of these have been connected in a witnessed mirror, although they were all on the same IP range.
Does anyone know why this would have such a bizarre connection issue?