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 |
|
np98ig
Starting Member
2 Posts |
 Posted - 2011-03-18 : 08:25:29
|
| Hi there. I have two machines under the same doimain. They are running sql server 2005 with sp4. When i try to mirror a database, i get the " can not be reached or does not exist" error on the principle server. I created a database, made a full backup, restored on the mirror server using NORECOVERY, made a log backup and restored it on the mirror server also using the NORECOVERY option. I can create the endpoint, however when I press the 'start mirroring' buttobn on the wizard i get that error. Can please, please, someone help me?Thanks in advanced,Ricardo |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-18 : 09:36:11
|
| A few things to check:- Make sure Named Pipes and TCP/IP networks are enabled on both servers (and the witness if you're using one). This can be found in the SQL Configuration Manager under Protocols.- Check the SQL Browser service is running on all servers.- Make sure you GRANT CONNECT permissions on the mirroring endpoint. I usually grant to public.- Is your SQL Server service running under LocalSystem or Network Service accounts? If so you should change them to a domain account (NOT Administrator, use another account with fewer privileges) |
 |
|
|
np98ig
Starting Member
2 Posts |
Posted - 2011-03-19 : 13:29:48
|
| Solved!! problem with the ports specified when creating endpoints. Thanks for your help! |
|
|
|
abu fathi
Starting Member
2 Posts |
Posted - 2011-09-07 : 23:40:35
|
| Would you share to me, because i have same problem, please.I have 3 machines, joined with a domain. i created database, made full backup, restored on mirror server using NoRecovery, made a log backup and restored it n the mirror server also using NORECOVERY. I can create the endpoint, but when i press the "start mirroring" on the wizard i get "..cannot be reached or does not exist".Can you help me, please...Thank's so muchAbu Fathi |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-09-08 : 06:58:43
|
| Did you check the 4 things I listed above? You should also check your network and Windows firewalls have rules to allow the TCP port used by mirroring (typically 5022) |
|
|
|
abu fathi
Starting Member
2 Posts |
Posted - 2011-09-08 : 23:12:43
|
| - Make sure Named Pipes and TCP/IP networks are enabled on both servers (and the witness if you're using one). This can be found in the SQL Configuration Manager under Protocols.Yes, i'm sure- Check the SQL Browser service is running on all servers.Hmm..let me check first.- Make sure you GRANT CONNECT permissions on the mirroring endpoint. I usually grant to public.How to create this?- Is your SQL Server service running under LocalSystem or Network Service accounts? If so you should change them to a domain account (NOT Administrator, use another account with fewer privileges)Yes My SQL Server servce is running under Local System. How to create this to?Thanks, i really appreciate. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-09-09 : 06:51:57
|
| You can find information on GRANT CONNECT and basic database mirroring in Books Online. The following links detail the overall process and include specifics for troubleshooting:http://technet.microsoft.com/en-us/library/ms188712.aspxhttp://msdn.microsoft.com/en-us/library/ms190941.aspxhttp://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418http://msdn.microsoft.com/en-us/library/ms189127.aspxUsing a domain account may require your IT network admin to create one specifically for running SQL Server services. I don't recommend using an existing user account, and this service account should not have domain admin privileges. |
|
|
|
|
|
|
|
|
Database mirroring within same domain