database mirroring

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » database mirroring

database mirroring

Rate Topic

Display Mode

Topic Options

Author

Message

meghaissethu

Posted Monday, May 26, 2008 5:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 19, 2009 12:41 AM
Points: 7, Visits: 36

Hi,

I followed a document to do database mirroring in two server.Server A have two instances .I made one as principal and another one as witness.Server B have one instance I made that as mirror and followed the following steps.
But i got again the error 1418, the server network address cannot be reached or does not exist.Can anybody help me for this error??

Editor's Note: Section quoted from book removed.

Post #506449

Andy sql

Posted Tuesday, May 27, 2008 6:37 AM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:21 AM
Points: 893, Visits: 872

A quick read through the (overly-long) notes tells me that you are trying to create ALL the endpoints on TCP/4040.

That is fine if each MSSQL Instance is on a separate server. But you have one server with two instances. You will have to change the Port number for one of the endpoints.

Andy

Post #506875

GilaMonster

Posted Tuesday, May 27, 2008 6:40 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 37,730, Visits: 29,996

If I may suggest - remove the extract from a wrox book as it is probably (at best) borderline copyright infringement - posting copyrighted works on a public forum.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #506878

meghaissethu

Posted Tuesday, May 27, 2008 6:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 19, 2009 12:41 AM
Points: 7, Visits: 36

Hi,
Yes i changed the port number to 4041 for witness.Then also not working.

Thanks and Regards ,
Megha

Post #506898

Andy sql

Posted Tuesday, May 27, 2008 7:10 AM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:21 AM
Points: 893, Visits: 872

Perhaps you could be a little more specific? What, exactly, is not working? What steps have you taken to figure out what is wrong?

Is the long copy-and-paste document from a Wrox book, or any other copyrighted source? If yes, I second the GilaMonster and strongly suggest you remove it. If nothing else, it is overly long and largely irrelevant.

Andy

Post #506907

alimcitp

Posted Tuesday, May 27, 2008 8:09 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, January 14, 2011 7:53 AM
Points: 78, Visits: 344

I looks that this post text is just a copy/paste from some book chapter which is the voilation of copyrights can you please tell what actually is not working.

Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate

Post #506942

2 Tim 3:16

Posted Wednesday, May 28, 2008 7:17 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 1,081, Visits: 1,454

I had a similar problem that ended up being a DNS entry problem. As a test, you can change the server name the endpoint is pointing to and use the IP instead. If this works, you hae a DNS problem.

Tim White

Post #507654

mallesh.nayak2002

Posted Friday, September 10, 2010 10:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, November 11, 2012 12:27 AM
Points: 3, Visits: 29

ping the server with hostname.
if not put an entry in host file and try to connect that server through osql

Post #983959

GilaMonster

Posted Friday, September 10, 2010 1:53 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 37,730, Visits: 29,996

Please note: 2 year old thread

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #984091

« Prev Topic | Next Topic »

Permissions