x

sql server 2008 data mirroring

![alt text][1] [1]: /upfiles/error.JPG hi team getting this error which configuring database mirroring in sql server 2008
more ▼

asked Nov 20, 2010 at 03:07 AM in Default

ramesh 1 gravatar image

ramesh 1
2.2k 63 67 69

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

Ramesh - if you have setup the endpoints as stated in the technet example there must be some sort of network issue outside of SQL Server.

I would hazard a guess at firewall settings blocking the ports that you want to use for mirroring.
more ▼

answered Nov 23, 2010 at 07:54 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

(comments are locked)
10|1200 characters needed characters left

Microsoft has a couple of resources for troubleshooting database mirroring problems.

Here is a short MS checklist for verifying that your [database mirroring ports are enabled][2]

Make sure that...

  • the mirror database is ready for mirroring.
  • the name and port of the mirror server instance are correct.
  • the destination mirror server instance is not behind a firewall.
  • the principal server instance is not behind a firewall.
  • the endpoints are started on the partners by using the state or state_desc column the of the sys.database_mirroring_endpoints catalog view. If either endpoint is not started, execute an ALTER ENDPOINT statement to start it.
  • the principal server instance is listening on the port assigned to its database mirroring endpoint and that and the mirror server instance is listening on its port. For more information, see "Verifying Port Availability," later in this topic. If a partner is not listening on its assigned port, modify the database mirroring endpoint to listen on a different port.

This is part of a larger article called "Troubleshooting Database Mirroring Deployment," which is full of T-SQL scripts and database mirroring troubleshooting guidance.

[2]: http://msdn.microsoft.com/en-us/library/aa337361.aspx
more ▼

answered Nov 23, 2010 at 01:34 PM

KenJ gravatar image

KenJ
19.2k 1 3 11

(comments are locked)
10|1200 characters needed characters left
what have you done to test the network between the two servers?
more ▼

answered Nov 20, 2010 at 04:37 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.3k 74 78 108

alter database dbname set partnet='TCP://servre.local.ser:5022'
Nov 21, 2010 at 02:39 AM ramesh 1
@Ramesh - that doesn't test the network connection between the servers. You need to test the actual network connections e.g. try ping from one server to the other. As the error says, either the network address doesn't exist or the port is not accessible.
Nov 21, 2010 at 03:15 AM WilliamD
hi william, i have used to pint -t , and i am able to ping them , cartroom\ramesh.babu is the domain admin on both the server, but stil. i have dropped the end points and re created them with out any iissue, but still microsoft error 1418, remains the same.
Nov 23, 2010 at 07:37 AM ramesh 1
i have used this url to verify the problem http://technet.microsoft.com/en-us/library/ms179306.aspx but no result
Nov 23, 2010 at 07:40 AM ramesh 1
(comments are locked)
10|1200 characters needed characters left
Have you tried IPs rather than names?
more ▼

answered Nov 23, 2010 at 01:35 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 36

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1832
x57

asked: Nov 20, 2010 at 03:07 AM

Seen: 1690 times

Last Updated: Nov 21, 2010 at 03:14 AM