I am trying to set up mirroring between two servers behind the same firewall on the same subnet.
I backed up mainserver and restored to mirrorserver.
I'm using the wizard on "mainserver" and connect to the "mirrorserver" using the sa login as both servers have the same sa login password.
The wizard creates endpoints on both servers correctly. When I start the mirroring it asks about FQDN but there is no domain so I click "Yes". It works for a while then I get the error alert below.
What is strange is that the error suggests it can't connect to itself.
Since posting this I found elsewhere suggestions that the problem is the database wasn't restored with NO RECOVERY on the mirrorserver. I tried this and now the wizard says
Cannot connect to mirrorserver Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)
Alter failed for Database 'mydatabase'. (Microsoft.SqlServer.Smo) An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The server network address "TCP://mainserver: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)