| 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 much
Abu 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.aspx
http://msdn.microsoft.com/en-us/library/ms190941.aspx
http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418
http://msdn.microsoft.com/en-us/library/ms189127.aspx
Using 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