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 |
|
Holydon
Starting Member
8 Posts |
 Posted - 2009-02-24 : 08:58:43
|
| I suppose u can help me solve the problem of mirroring. I have studied hard on it and I guess something is wrong somewhere. We have 2 HP Proliant servers, but clients are only connected to one. The 2 servers have the same specifications, both are DHCP, DNS, IIS server with the same Domain Controller Name...like "abcdefgh.com" infact we just replicated all in the 1st server into the 2nd server. This initiation was thought that incase the 1st server developed any OS or Hardware problem, we'll just remove the patch cord and switch servers and the clients will still have access and we wont need to go to all the clients machine trying to make them see a new coupled server. Anyway, the two server has SQL server 2005 SP1 installed, and I made sure I created the same users on each with the same SID number. We have two Database we intend to now link to the next server using the 2nd pair ethernet ports on both server with similar address to communicate, this is bcos we dont want to connect it to the main network switch and I can see each machine on the domain list, lest I forget I had to make a slight change in the computer name like "cumputer" and "computer2" to avoid name conflict. You see when I tried to configure Security for mirroring the endpoint tcp address looks like this tcp://computer.abcdefg.com:5022and tcp://computer2:5022 making it difficult to communicate with each other, thereby giving me Error 1418 (Alter failed for database "name"...the server network add tcp://computer.abcdefg.com:5022 can not be reached or does not exist", even though the 2 machine has the same userid and password, and I also connected to the instances with sa. I dont know what I am doing wrong....but I think it is bcos the 2nd server is not on the 1st domain....it is more like a peer to peer network connection that I did and I think using a certificate will also help but I dont understand it and I dont want to use TSQls in the process. The truth is, we dont want to demote the 2nd server, cos i tried it once and couldn't access my applications and have a right access to the reportserver, I had to crash and rebuild the server again. Now, I know u can help me resolve the issue, I dont mind u writing the step by step procedure to follow.I will greatly appreciate it and please dont refer me to a blog or a column, I will greatly and greatly appreciate it if u give me personal assistance in this.Thanking u in anticipation HolyDon |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 10:03:16
|
quote:
Originally posted by Holydon
I suppose u can help me solve the problem of mirroring. I have studied hard on it and I guess something is wrong somewhere. We have 2 HP Proliant servers, but clients are only connected to one. The 2 servers have the same specifications, both are DHCP, DNS, IIS server with the same Domain Controller Name...like "abcdefgh.com" infact we just replicated all in the 1st server into the 2nd server. This initiation was thought that incase the 1st server developed any OS or Hardware problem, we'll just remove the patch cord and switch servers and the clients will still have access and we wont need to go to all the clients machine trying to make them see a new coupled server. Anyway, the two server has SQL server 2005 SP1 installed, and I made sure I created the same users on each with the same SID number. We have two Database we intend to now link to the next server using the 2nd pair ethernet ports on both server with similar address to communicate, this is bcos we dont want to connect it to the main network switch and I can see each machine on the domain list, lest I forget I had to make a slight change in the computer name like "cumputer" and "computer2" to avoid name conflict. You see when I tried to configure Security for mirroring the endpoint tcp address looks like this tcp://computer.abcdefg.com:5022and tcp://computer2:5022 making it difficult to communicate with each other, thereby giving me Error 1418 (Alter failed for database "name"...the server network add tcp://computer.abcdefg.com:5022 can not be reached or does not exist", even though the 2 machine has the same userid and password, and I also connected to the instances with sa. I dont know what I am doing wrong....but I think it is bcos the 2nd server is not on the 1st domain....it is more like a peer to peer network connection that I did and I think using a certificate will also help but I dont understand it and I dont want to use TSQls in the process. The truth is, we dont want to demote the 2nd server, cos i tried it once and couldn't access my applications and have a right access to the reportserver, I had to crash and rebuild the server again. Now, I know u can help me resolve the issue, I dont mind u writing the step by step procedure to follow.I will greatly appreciate it and please dont refer me to a blog or a column, I will greatly and greatly appreciate it if u give me personal assistance in this.Thanking u in anticipation HolyDon
Your post is really confusing to read. So have you applied transaction log backup in Mirror Server with NORECOVERY MODE. |
 |
|
|
Holydon
Starting Member
8 Posts |
Posted - 2009-02-24 : 10:16:04
|
| Yes.I have done all that...........took the full backup and restore it to the mirror with norecovery and as well as the TransactionLog ..........Be sure I have done all that. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 10:35:09
|
| There should be different port no of both servers. Also use FQDN. |
|
|
|
Holydon
Starting Member
8 Posts |
Posted - 2009-02-24 : 10:37:15
|
| I used the same port number for easy communication.....since the instances are on two different systems |
|
|
|
|
|
|
|
|
SQL