Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TiGGi
Starting Member
29 Posts |
 Posted - 2008-04-29 : 12:38:53
|
| 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.What am I missing here? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-29 : 20:44:02
|
| "so I change it to TCP://sqlsvr2.domain.com:5022 but then I get no connection when I try to start the mirror."How did you change ? What FQDN do you get when pinging mirror server? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-29 : 22:18:31
|
| Tried connect with ip address? |
|
|
|
TiGGi
Starting Member
29 Posts |
Posted - 2008-04-30 : 01:20:11
|
quote:
Originally posted by sodeep
"so I change it to TCP://sqlsvr2.domain.com:5022 but then I get no connection when I try to start the mirror."How did you change ? What FQDN do you get when pinging mirror server?
When doing "Configure Security" under db mirroring properties if you say no to last step where it asks you if you want to start the mirroring, then it lets me change the Server Network Address. It's not grayed out as usual.PING doesn't resolve FQDN, but when I do IPCONFIG on mirror server I get Host Name = sqlsvr1 Primary DNS sufix = domain.com, which is correct.Yes I've tried connecting with IP address and I get the same thing. Weird thing is that I can register the mirrored server in the database engine and browse it just fine. Do I need to change any network properties or protocols. TCP connection is using TCP/IP protocol right? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-30 : 21:48:22
|
| Did you get any error? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-01 : 16:14:04
|
| It needs FQDN or I.p address. Ping your principle server and see what is difference between them |
|
|
|
|
|
|
db mirroring connection problem