sql server 2008 database mirroring gotchas
One day if you try to configure sql server for mirroring without domain accounts you may come across with a few problems.such as this error message: Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote "alter failed for database" The server network address 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 server network address "%.*ls" 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. Error messages differs but the problem is sql servers principal and mirror should trust each other. On the net there are various resources how to configure this via certificates etc. but if you are in a hurry to test something quick try this on your mirror: run on master database if not exists( select *