| Author |
Topic |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2009-04-11 : 05:13:27
|
| Dear All, I have installed SQL 2005,SP2 server on two test computers and am trying to get database mirroring to work. Nowitness server is being used.I have done a FULL backup of the database and backed up the transaction log.I have also restored the database and the transactionlog On the mirror server and the database is currently "In Recovery" and seems to always stay that way.When I try to mirror the database I can get the primary and mirror instances to configure,however when I click on "Start Mirroring" with(Synchronous High protection) I get the following error message:An error occurred while starting mirroring.An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------The server network address "TCP://XNSSRV03104.exensys.net: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. (Microsoft SQL Server, Error: 1418)Does anyone have any tips that might be of use?I feel like I'm soclose...Thanks!!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-13 : 18:01:15
|
| http://msdn.microsoft.com/en-us/library/ms189127.aspx |
 |
|
|
jankoz
Starting Member
2 Posts |
Posted - 2009-04-21 : 12:57:04
|
| Have you found the solution ?I have the same problem. I have created everything by the book:backup with full recovery, restore with norecovery, created endpoints, checked endpoints according to link posted above,...with no sucess.The 1418 error referes to my mirror server (TCP://mirror_ip:5023) when preformingALTER DATABASE Mirror_db SET PARTNER=N'TCP://MirrorServer:portNumber'What else do you suggest ?Thank you |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-04-21 : 16:04:27
|
| You missed the log backup.1) Full backup of database2) Log backup of database3) Restore full backup on mirror server with NORECOVERY4) Restore log backup on mirror server with NORECOVERY5) Issue ALTER DATABASE commands. |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2009-04-22 : 11:02:00
|
| Dear Mcrowley, I have did all the process what you have said but iam unable to telnet from principal server to mirror server and viceversa using the port 5022.it says unable to connect,do u have any idea of how to enable port 5022 for mirroring |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-04-22 : 11:12:04
|
| Jankoz missed the log backup. Sounds like you have a firewall somewhere between you and your mirror. Other things to check are permissions. Are both machines in the same domain? Do the service accounts on each match? |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2009-04-22 : 11:16:13
|
| Dear Mcrowley, The firewall is disabled in both the systems,both the systems use local system account,I think the problem is with port 5022 only iam unable to telnet from one server to other it says unable to connect can you tell me how we can enable the port 5022 |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-04-22 : 14:11:44
|
| Have you tried a different port? |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2009-04-23 : 05:09:12
|
| Dear mcrowley, I tried using 1433,1434 but the same error comes these ports are listening to other processes,how can we know the ports which are free and no process is using them. |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-04-23 : 05:20:51
|
| try someone like 2001 on the principal and 2002 on the secondary server |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-04-24 : 14:47:30
|
quote:
Originally posted by DBA007
Dear Mcrowley, The firewall is disabled in both the systems,both the systems use local system account,I think the problem is with port 5022 only iam unable to telnet from one server to other it says unable to connect can you tell me how we can enable the port 5022
for a safer side, u can use a windows account with administrator privileges for every system participating in mirroring. add this account as a login on each serverRegards,Ahmad Osama |
|
|
|
|
Mirroring Error