I'm trying to mirror a db using a Principal, Mirror, and a Witness server. Each computer that has it's own local ip address (v4) and I made them static so they would not change.
Then I did some reading and followed the steps on how to backup and restore a test database and then using the Mirroring Congure Security Wizard I'm able to connect to each of the Servers using the SQL Server Authentication not Windows Authentication and then I get the Success message then I click on Close and Start Mirroing but I then get an Error# 1418 Network address: "TCP://BAKSRV:5022" cannot be reached or does not exist, I then changed the network addresses to see if it will connect using IPv4 and entered the below info. into the Server network addresses:
Principal: TCP://10.1.10.1:5022 Mirror: TCP://10.1.10.2:5022 Witness: TCP://10.1.10.3:5022
I also tried using their computer names but it still gives me the same error
Error# 1418 Network address: "TCP://10.1.10.2:5022" cannot be reached or does not exist
on the Mirror Comp. I went into cmd and did netstat -a and I see this a number of times:
TCP ---- 10.1.10.2:5022 ------- Main-PC:diffrent port numbers ---- TIME_WAIT
I also disabled the firewall on the mirror comp. to rule it out but I still cannot Start Mirroring.
All Comps are runnning MS SQL 2012 and I'm using a TestDB that has like two fileds just to get it tested/working.
When I try this:
SELECT name, role_desc, state_desc FROM sys.database_mirroring_endpoints
name role_desc state_desc Mirroring PARTNER STARTED
and when I try this:
SELECT name, port FROM sys.tcp_endpoints
name port Dedicated Admin Connection 0 TSQL Default TCP 0 Mirroring 5022
when I go into SQL Server Configuration Manager and Select SQL Server under Log On: This Account is check, and there is a Account Name: .\BKAccount and the password is also filled out. all 3 servers have the same settings but all of them have a different username/password. I don't know if this helps any but when I'm in SQL Management Studio I can only connect to the Mirror server and Witness server by selecting Authentication: SQL Server Authentication, and not by selecting windows authentication.
Can someone please help me what am I doing wrong and how can I get this to work.... Please HELP!!!