April 29, 2008 at 12:07 pm
Hi all,
I am trying to set up db mirroring between 2 servers and I have everything pretty much set but only problem so far is connecting to mirrored server. When I go through the "Configure Security" setup I connect to the mirrored server using server name "sqlsvr2" and user/password that has access to the endpoint. After this is finished it automatically enters TCP://sqlsvr2:5022 in to the address bar, which it doesn't like, so I change it to TCP://sqlsvr2.domain.com:5022 but then I get no connection when I try to start the mirror. sqlsvr2.domain.com pings just fine and also responds to telnet on port 5022. I even tried using the IP address for tcp connection but it's not connecting. Also when I use t-sql to connect I get same error.
What am I missing here?
April 29, 2008 at 11:29 pm
Anyone, pllllllllllllllleeeeeeeeeease!!!!
April 30, 2008 at 8:35 am
Hi
what is the error you are getting? are all the sql services running under the same account?
April 30, 2008 at 9:49 am
The error is "The server network address: "TCP://sqlsvr2.domain.com" can not be reached or does not exists. Check the network address name and that he ports for the local and remote endpoints are operational. (Microsoft SQL Server, error: 1418)"
Yes sql services are running under the same account.
April 30, 2008 at 9:57 am
Hi use the configure mirroring wizard . when it gets to the section where you choose the witness server, make a note of the EndPoint name where the box is greyed out then cancel the wizard. now connect to the witness server and execute the following command
DROP ENDPOINT
Then re-try the wizard
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply