I'm trying to mirror a database which is hosted by a SQL Server 2008 R2 on another SQL Server 2008 R2 which is not in a domain. The database is set in full mode and I'm trying to mirror it on this new server but it returns an error at the end.
I've backup the database on the source server as well as the logs and imported them on the new server in NO RECOVERY mode.
The connection between the servers seems to be just fine, there isn't any firewall between them but I still got this error message after the wizard ends and I don't understand why :
*Alter Failed for Database 'Test'. An exception occured while executing a Transact-SQL statement or batch. The network address TCP://10.0.2.40: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"
Any ideas ?
PS : There is no witness server. Is it mandatory to have one?