| Author |
Topic |
|
rezourxe
Starting Member
17 Posts |
 Posted - 2008-04-09 : 17:20:20
|
Hi,I made my way with your help and got it working on our Development environment. Now, I'm trying to do the same thing on productionand I get this error, when I start the mirroring session: The ALTER DATABASE command could not be sent to the remote server instance 'TCP://dtmanager:1433'. The database mirroring configuration was not changed. Verify that the server is connected, and try again. (Microsoft SQL Server, Error: 1456) On the principal log, I have this same registered.but on the witness, I get:Logon,Unknown,Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: PrincipalIP] I configured certificates for all of them. the principal - mirror relation is working properly, the only problem is setting up the witness. any Idea on where I can start looking for more clues to solve this issue?if it ain't broken don't fix it! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 17:24:39
|
| Check this out:http://support.microsoft.com/kb/930284 |
 |
|
|
rezourxe
Starting Member
17 Posts |
Posted - 2008-04-09 : 17:39:43
|
| thx for the answer, the article looks interesting, bu I'm running with sp2 on all my instances. now....:STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft SQL Server 2005 Service Pack 2.WORKAROUNDTo work around this problem, make sure that you have a DNS server listening when you use a private network.if I ping the witness from the principal and I get response, doesn't that mean that my DNS Servers are fine?.............................................................: sometimes I get really confused with their documentation. :.............................................................if it ain't broken don't fix it! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 17:43:58
|
| "MORE INFORMATIONIn this situation, all server names that are referenced in the ALTER DATABASE commands must use IP addresses instead of the server name.Changing the hosts file on the servers that are part of the DBM session does not resolve this problem.This problem does not occur when you originally create the DBM session between the partners as the two ALTER DATABASE commands. One command exists on each partner server to notify the partner server of the other partner"Why don't you set up three servers at same time instead of adding later on? |
|
|
|
rezourxe
Starting Member
17 Posts |
Posted - 2008-04-09 : 18:16:42
|
quote:
Why don't you set up three servers at same time instead of adding later on?
That's what I was trying to do, when I recieved the first error.if it ain't broken don't fix it! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 19:16:47
|
| Confused!! Tell us how did you setup mirroring step-by -step? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-09 : 22:45:28
|
| Where did you put witness? Can you ping both principal and mirrored servers from witness? |
|
|
|
rezourxe
Starting Member
17 Posts |
Posted - 2008-04-10 : 14:26:32
|
| Oh yes, I can. I'm not sure, cause I was using the one that is now my witness as the mirror on the test environment.if it ain't broken don't fix it! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-10 : 14:41:26
|
| What?Read microsoft whitepaper on Database Mirroring . They will guide you step-by-step for resolving errors and setting up right way either GUI or with T-SQL |
|
|
|
rezourxe
Starting Member
17 Posts |
Posted - 2008-04-10 : 15:34:30
|
quote:
Originally posted by sodeep
What?Read microsoft whitepaper on Database Mirroring . They will guide you step-by-step for resolving errors and setting up right way either GUI or with T-SQL
That's how is supposed to be... but is not. In the Upper part of this topic, I quoted the words of Microsoft.if it ain't broken don't fix it! |
|
|
|
rezourxe
Starting Member
17 Posts |
Posted - 2008-04-10 : 15:39:48
|
quote:
Originally posted by sodeep
Confused!! Tell us how did you setup mirroring step-by -step?
I did the certificates part first because I was about to workon production. had to wait till the end of the day for the backup.I created Self-signed certificates on all the servers.I moved the certificates and created users for each server on eachserver.after this, at the end of the day I did my backup on the principal,restore it on the Mirror, with Norecoveryand did the same to the Transaction Log Backup.after that the Wizard did the rest..if it ain't broken don't fix it! |
|
|
|
rezourxe
Starting Member
17 Posts |
Posted - 2008-04-11 : 18:07:00
|
quote:
Originally posted by sodeep
Confused!! Tell us how did you setup mirroring step-by -step?
what was this question for?if it ain't broken don't fix it! |
|
|
|
|
Implementing Mirror