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:04:09
|
| 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 |
|
|
craigwg
Posting Yak Master
154 Posts |
Posted - 2009-08-05 : 10:52:00
|
| Update:The error log says: The login 'CORP\usslc-sqltest' does not have CONNECT permission on the endpoint. State 84.How do I fix this?Craig Greenwood |
 |
|
|
craigwg
Posting Yak Master
154 Posts |
Posted - 2009-08-06 : 12:56:19
|
| For anyone following this, the issue was the service accounts. I had to create an account in users on the mirror server, then make that account run the SQL services. After that the mirror worked as normal.Craig Greenwood |
|
|
|
|
|
|
Database Mirroring not working