Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mirroring Endpoint Port Number Expand / Collapse
Author
Message
Posted Friday, November 30, 2012 9:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
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
Posted Friday, November 30, 2012 11:01 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 8:34 PM
Points: 23,343, Visits: 32,079
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.



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
Posted Saturday, December 1, 2012 4:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
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
Posted Saturday, December 1, 2012 6:04 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 8:34 PM
Points: 23,343, Visits: 32,079
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?



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 #1391681
Posted Saturday, December 1, 2012 9:57 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
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
Posted Sunday, December 2, 2012 8:12 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 8:34 PM
Points: 23,343, Visits: 32,079
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.



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 #1391726
Posted Sunday, December 2, 2012 10:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
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 2, 2012 9:08 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
See this link.

http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418
Post #1391765
Posted Monday, December 3, 2012 2:22 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
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 »

Add to briefcase

Permissions Expand / Collapse