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 |
|
craigwg
Posting Yak Master
154 Posts |
 Posted - 2009-08-05 : 10:03:14
|
| I am setting up a mirror which I have done in the past with success. As far as I can tell I am doing everything correctly. The one difference is that one server is in Denver and the other is at my office in Salt Lake City, Utah. I have turned on the -T 1400 switch in the start up parameters which was a problem at first, but I fixed that one. Here is what is happening now:I go to my primary server and set up the mirror, filling in information for the principal and mirror servers as normal, I have gone with all defaults so both ports are 5022. The Endpoint names were set by the wizard and I verified both exist and are correct. The service accounts I leave blank since nothing fancy is running the service accounts on either machine. I click finish and I am told success. Here is where it gets interesting!I click the "Start Mirroring" button, a few seconds pass and then I am met with an error that looks like this:An error occurred while starting mirroring.Additional information: Alter failed for Database "IST_RTCF_TEST". (Microsoft.SqlServer.Smo) An exception occurred while executing a Transact_SQL statement or batch (Microsoft.SqlServer.ConnectionInfo) The server network address "TCP://usdensqltest.corp.riotinto.org:5022" can not be reached or does not exist. Check the netword address anme and that the ports for the local remote endpoints are operational. (Microsoft SQL Server, Error: 1418)I have tried to look all this stuff up, both servers can ping each other with success. So I'm stumped. What am I missing here? I'm willing to try anything, so no advice to small or large here!ThanksCraig Greenwood |
|
|
MonikaK
Starting Member
6 Posts |
Posted - 2009-08-13 : 10:27:17
|
| Try to start the MSSQL SERVER serc=vide with the domain accounts. |
 |
|
|
|
|
|
Database Mirroring not working