☰

SQL 镜像错误 - SQL 2008

tag-icon • tag-icon sql-server-2008 database-mirroring
SQL 镜像错误 - SQL 2008

我正在尝试配置 SQL Server 镜像，但出现以下错误：

The server network address "TCP://santosh-PC:5023" 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. (.Net SqlClient Data Provider).

Program Location: 
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplFinish(StringCollection alterQuery, ScriptingOptions so)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplWorker()
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl()

您能告诉我出了什么问题吗？

答案1

您确实应该提供更多信息，您何时收到错误，您设置镜像的程序是什么，您尝试了什么来解决错误？但是，我记得收到过与网络相关的错误，就像我忘记在辅助服务器上恢复日志备份时收到的错误，或者在恢复时错过了 WITH NORECOVERY。

也可以在这里阅读 Graham Kents 的文章：http://blogs.msdn.com/b/grahamk/archive/2008/12/08/database-mirroring-error-1418-troubleshooter.aspx

答案2

听起来您没有创建端点，它们没有启动，或者有防火墙阻止与端点的连接。

相关内容