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-25 : 09:46:22
|
| HelloPlease help me solve mirroring issue.I have 2 servers. 1 is live and clients are connected to it while the other is connected to eachother (Peer by Peer) by the available 2nd LAN port. Both of them are domain controller. Server1 FQDN is serv.domain.com, while Server2 is just serv (Becauseit is a standalone Domain controller) i.e. No Clients are connected to it and it is not added to Server1 domain.Both have Ip 10.0.0.2 and 10.0.0.3 ipsThey can ping each other by FQDN (added that to hosts file). All ports are open.I am trying to configure mirror.server1 is principle and server2 mirror server.I have backuped database and transaction logs on server1 and restored to server2 with NORECOVERY option. Database in srv2 now is with "in recovery" status.Then i try to configure mirror on srv1. Using port 5022 on both servers. Service accounts for instances: leave empty.Configuring endpoints finished with "Success" status.But when i try to start mirroring i get this error:Alter failed for Database 'database'. (Microsoft.SqlServer.Smo)An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)The server network address "TCP://srv2.server.lan:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.What can be wrong?Thank you for help in advanceAidas |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-25 : 09:49:54
|
| why Duplicate?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109437 |
 |
|
|
Holydon
Starting Member
8 Posts |
Posted - 2009-02-25 : 09:54:48
|
| I need it answered... Ikariux didnt say how he got it solved and mine is not in a workgroup. |
|
|
|
|
|
|
Sql Server 2005 Mirroring problems