主体服务器和镜像服务器都是SQLSERVER 2008R2 ,在域环境下进行镜像配置,不使用见证服务器。
在配置镜像的实例服务账户时采用的是域管理员,所以用户登录不存在问题。
点击开始镜像,提示如下错误:
查看镜像服务器数据库日志如下:
2014-10-17 09:29:07.82 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required.
2014-10-17 09:29:08.03 spid7s Recovery is complete. This is an informational message only. No user action is required.
2014-10-17 09:29:18.35 spid53 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2014-10-17 09:29:18.36 spid53 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2014-10-17 09:29:18.37 spid53 Database mirroring has been enabled on this instance of SQL Server.
2014-10-17 09:29:39.68 spid25s Error: 1474, Severity: 16, State: 1.
2014-10-17 09:29:39.68 spid25s Database mirroring connection error 2 'Connection attempt failed with error: '10060(由于连接方在一段时间后没有正确答复或连接的主机没有反应,连接尝试失败。)'.' for 'TCP://192.168.6.20:5022'.
我根据网上的方案,将'xpstra.dll'的权限设为everyone 完全控制后没有任何效果。再次点击开始镜像,提示如下:
,必须重启镜像服务器的SQL服务才可。