While attempting to mirror two sql servers without a witness server, the following error kept coming through right at the end:
The server network address "TCP://MOSSSQL-B.mka.compu
nal: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)
I checked that both endpoints were created and on/started. I can ping both servers from the other server. Both servers are running SQL Standard 2005 ver 9.0.3077. All servers are in Amazon's cloud and apart of the "local" domain: MKA (mka.compute-1.internal).
In trying to fix this issue, a forum, http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22896060.html?sfQueryTermInfo=1+1418+2005+cannot+doe+error+exist+mirror+reach+sql
, suggested to run the SQL processes under a domain admin account rather than the local admin account. The first server switched over fine, but the second server now gives this error:
Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code -2146885628.
1. Does the SQL server need to be run by a Domain admin for cloning to be successful?
2. What else should be done to get these two machines cloning successfully?