Mirroring Endpoint Port Number

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Mirroring Endpoint Port Number

Mirroring Endpoint Port Number

Rate Topic

Display Mode

Topic Options

Author

Message

shohelr2003

Posted Friday, November 30, 2012 9:11 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:32 AM
Points: 124, Visits: 324

Dear,
I want to configure database mirroring with automatic failover option. That is why I want to make my PC as Principal and another PC as Mirror (Default Instance) and Witness (Named Instance).

Now my query is should the endpoints remain same or different?

Please help me.

Regards,
Akbar

Post #1391618

Lynn Pettis

Posted Friday, November 30, 2012 11:01 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 21,633, Visits: 27,490

If you are talking physically different hardware (could be two separate VM's on the same box as well), then they can be the same. If the instances are on the same hardware, they need to be different.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1391625

shohelr2003

Posted Saturday, December 01, 2012 4:55 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:32 AM
Points: 124, Visits: 324

I am using one PC for Principal and other PC for Mirror and Witness. That means there are two different hardwares. One contain one instance and other contain two instances.

Post #1391641

Lynn Pettis

Posted Saturday, December 01, 2012 6:04 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 21,633, Visits: 27,490

Knowing that one system has one instance of SQL Server installed (default instance?) and another has two instances installed (a default and a named instance?), we now need to know which instances are you trying to mirror databases?

Cool

Lynn Pettis

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1391681

shohelr2003

Posted Saturday, December 01, 2012 9:57 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:32 AM
Points: 124, Visits: 324

Thank you Lynn Pettis.

I want to configure mirroring default instance (Principal) to default instance (Mirror) and named instance will Witness. Principal will reside on one System and Mirror and Witness will reside on other system.

Post #1391698

Lynn Pettis

Posted Sunday, December 02, 2012 8:12 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 21,633, Visits: 27,490

The two default instances can use the same port value for database mirroring. The named instance on the second system has to use a different port since it is on the same physical hardware as the default instance.

Cool

Lynn Pettis

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1391726

shohelr2003

Posted Sunday, December 02, 2012 10:58 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:32 AM
Points: 124, Visits: 324

Thank you, Boss. I have tried in the way you mentioned. In configuring mirroring I left service accounts box blank. But when I click on Start Mirroring, I get an error message something like "The server network address “TCP://SQLServer:5023″ can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)"

I can not get the problem. Please help me.

Post #1391737

Posted Sunday, December 02, 2012 9:08 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 3:36 AM
Points: 305, Visits: 493

See this link.

http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418

Post #1391765

shohelr2003

Posted Monday, December 03, 2012 2:22 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:32 AM
Points: 124, Visits: 324

Now I have done.

I have changed local service account to domain account and created domain account login with windows authentication. That's it.

Thank you all.

Post #1391811

« Prev Topic | Next Topic »

Permissions