Mark,
Ok .. it seems first of all that there is no way to do the setup using the GUI/Wizard. I always get the error described above even if the endpoints are already defined and started. I have discover that for strange reason if I create endpoint using three differents port (I have three independant server so according to the doc I should be able to use the same port) it works but only using command line:
These are the steps I have to go through to have the mirror configured:
1- backup on the principal
2- restore on the mirror with norecovery
3 - create endpoint
principal: state= started port=5022 role=partner
mirror: state=started port=5023 role=partner
witness: state=started port=5024 role=witness
4 - setup the mirror
mirror site: alter db set partner='TCP://itanium8.sql.net:5022'
principal site:
alter db set partner='TCP://itanium9.sql.net:5023'
alter db set partner='TCP://itanium10.sql.net:5024'
But again no way to set it up with the wizard....
Thanks
Jerome
如何建立一个使用WIN验证的数据镜像Witness服务器
要为数据库指定witness,须设置witness服务器上的角色到数据库实例
虽然witness服务器实例可以运行在主服务器或者镜像服务器上,但这样减少了灵活性
我们推荐witness服务器分配到不同的机器上,为了保证安全,我们推荐设置SAFETY属性为FULL
下面实例指点如何建立WIN验证的WITNESS
1.在服务器上建立端点,监听在7022端口
CREATE ENDPOINT Endpoint_Mirroring
STATE=STARTED
AS TCP (LISTENER_PORT=7022)
FOR DATABASE_MIRRORING (ROLE=WITNESS)
GO
2.为从服务器实例的用户帐号建立一个SQL登录,假设WITNESS运行在SOMEDOMAIN/witnessuser上,而从服务器运行在MYDOMAIN/dbousername上,那么为从服务器建立一个登录如下:
--Create a login for the partner server instances,
--which are both running as MYDOMAIN/dbousername:
USE master ;
GO
CREATE LOGIN [MYDOMAIN/dbousername] FROM WINDOWS ;
GO
--Grant connect permissions on endpoint to login account
--of partners
GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [MYDOMAIN/dbousername];
GO
3.在每一个从服务器实例上,为WITNESS实例上用户建立一个登录,如下
--Create a login for the witness server instance,
--which is running as SOMEDOMAIN/witnessuser:
USE master ;
GO
CREATE LOGIN [SOMEDOMAIN/witnessuser] FROM WINDOWS ;
GO
--Grant connect permissions on endpoint to login account
--of partners
GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [SOMEDOMAIN/witnessuser];
GO
4.在主服务器上,设置witness
ALTER DATABASE AdventureWorks
SET WITNESS =
'TCP://WITNESSHOST4:7022'
GO