在SQL中镜像时出错。错误代码是1418 [英] Am getting error when mirroring in SQL. Error code is 1418
问题描述
以下错误我的网络协议已启用..
TITLE:数据库属性
------------------------------
开始镜像时出错。
------------ ------------------
附加信息:
更改数据库失败' MIRRORING。 (Microsoft.SqlServer.Smo)
如需帮助,请单击:http://go.microsoft.com/fwlink?ProdName = Microsoft + SQL + Server&ProdVer = 10.50。 4000.0 +((KJ_PCU_Main).120628-0827 +)&EvtSrc = Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID = Alter + Database&LinkId = 20476
--- ---------------------------
执行Transact时发生异常-SQL语句或批处理。 (Microsoft.SqlServer.ConnectionInfo)
--------------------------- ---
无法访问或不存在服务器网络地址TCP:// Babu:5023。检查网络地址名称以及本地和远程端点的端口是否正常运行。 (Microsoft SQL Server,错误:1418)
如需帮助,请单击:http://go.microsoft.com/fwlink?ProdName = Microsoft + SQL + Server&ProdVer = 10.50.1600&EvtSrc = MSSQLServer&EvtID = 1418&LinkId = 20476
------------------------- -----
按钮:
OK
---------- --------------------
Hi,
Below error am getting.. network protocols are enabled..
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'MIRRORING'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The server network address "TCP://Babu: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. (Microsoft SQL Server, Error: 1418)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
推荐答案
按照link [ ^ ]获取如何解决问题的说明。
Follow the link[^] to get instructions how to solve your problem.
这篇关于在SQL中镜像时出错。错误代码是1418的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!