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

asked Nov 20 '10 at 03:07 AM in Default

ramesh 1
1.8k ● 48 ● 64 ● 68

(comments are locked)

4 answers:

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.

answered Nov 23 '10 at 07:54 AM

WilliamD
25.4k ● 16 ● 18 ● 41

(comments are locked)

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

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.

answered Nov 23 '10 at 01:34 PM

KenJ
12.4k ● 2 ● 10

(comments are locked)

what have you done to test the network between the two servers?

answered Nov 20 '10 at 04:37 AM

Fatherjack ♦♦
38.8k ● 56 ● 73 ● 104

alter database dbname set partnet='TCP://servre.local.ser:5022'

Nov 21 '10 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 '10 at 03:15 AM WilliamD

hi william, i have used to pint -t , and i am able to ping them , cartroomramesh.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 '10 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 '10 at 07:40 AM ramesh 1

(comments are locked)