SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Configuring Database Mirroring


Configuring Database Mirroring

Author
Message
william-375754
william-375754
SSC-Addicted
SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)

Group: General Forum Members
Points: 466 Visits: 221
Comments posted to this topic are about the item Configuring Database Mirroring
brekee
brekee
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 41
I had also the same error:

[color=#FF0000]The server network address "TCP://<server>:5022" 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.[/color]

While building about 20 mirrors. And the strange was that I was able to build the first 10 mirrors, then this error appeared. But if I tried again then I was success. Than fail again and success again, or not.
First I suspect for the network....

Then I realized the following:
On the mirror instance I had two SQL instances running. One of them ate 20Gigs of memory, the other one left only 600MB...
What do you think which one was the one I tried to set up for mirroring?
Once it got some memory (2-3 gigs) it was easily build the mirrors, and the error was gone...

Andor
sireesha.budagala
sireesha.budagala
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 33
Very Useful information with Statements from starting of the Mirroring Configuration till the end with Error messages . :-D

Sireesha
sireesha.budagala
sireesha.budagala
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 33
How Can we modify the Login permissions on SQL Mirrored Database ?
for ex : 'abc' is the Login we need to reduce the level of permission from 'db_owner' to 'read/write' on Mirrored database . Database will be Read-only .

Provide all your inputs on the above . :-)

Thanks in Advance

Sireesha
clementhuge
clementhuge
SSC Veteran
SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)

Group: General Forum Members
Points: 211 Visits: 301
This is a very nice little introduction by this article lacks of several issues that should be looked at.
- certificate authentication
- mirroring replication
- linked server failovering
- job failovering

I had the experience with all of that for a client and I am still struggling with linked server. The failover partner solution does not work as there is a bug on Microsoft part (your login needs to be sysadmin for the linked server with failover partner to fully work). I am setting a different way as we speak as linked server is source of security breach. This needs to be definitely fix by Microsoft.

Clement
clementhuge
clementhuge
SSC Veteran
SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)

Group: General Forum Members
Points: 211 Visits: 301
sireesha.budagala (2/1/2011)

How Can we modify the Login permissions on SQL Mirrored Database ?
for ex : 'abc' is the Login we need to reduce the level of permission from 'db_owner' to 'read/write' on Mirrored database . Database will be Read-only .

Provide all your inputs on the above . :-)

Thanks in Advance

Sireesha



There is no issue as the rights on a database is user-oriented or database role oriented, both objects embedded in the database. Your changes will be automatically mirrored without any issue.

The rights that are given at the server level and OS level will not be mirrored. So if your login need to write/read specific things on disk or if your login has view server state granted for example, you need to apply those rights on both servers.

Clement
jorge.rodriguez
jorge.rodriguez
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 76
When I try to partner the principal to the mirror I get the error:

The server network address "TCP://<server>:5022" 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

Strange thing is I cant partner the mirror to the principal.

I have followed all the steps listed on the article all to no avail. The service account are running under the same domain account on both databases... Any help would be apreciated.
clementhuge
clementhuge
SSC Veteran
SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)

Group: General Forum Members
Points: 211 Visits: 301
jorge.rodriguez (2/1/2011)
When I try to partner the principal to the mirror I get the error:

The server network address "TCP://<server>:5022" 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

Strange thing is I cant partner the mirror to the principal.

I have followed all the steps listed on the article all to no avail. The service account are running under the same domain account on both databases... Any help would be apreciated.



-- 1. Ping and telnet your principal and mirror servers: if you cannot ping or telnet, this can be your problem (add your ips on your host files and see if this fix your issue)
-- 2. Firewall setup: inbound and outbound packets need to be allowed on the ports used by your listening end points
-- 3. Windows negotiate: can you confirm you use windows negotiate for your end points?

This is for starters.

Clement
jorge.rodriguez
jorge.rodriguez
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 76
-- 1. Ping and telnet your principal and mirror servers: if you cannot ping or telnet, this can be your problem (add your ips on your host files and see if this fix your issue)
-- 2. Firewall setup: inbound and outbound packets need to be allowed on the ports used by your listening end points
-- 3. Windows negotiate: can you confirm you use windows negotiate for your end points?

This is for starters.


Thanks for the prompt reply,

I can connect through telnet on both servers, my firewall is currently off and windows negotiate is used on both endpoints.

Any other sugestions?
Kendal Van Dyke
Kendal Van Dyke
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2832 Visits: 983
The article states that SQL 2008 is a prerequisite but mirroring has been around since SQL 2005 SP1.

Also, the witness can be Express or Workgroup edition.

Finally, I want to emphasize that one very important consideration for mirroring to work properly is that you should use the fully qualified domain name (FQDN) for servers, NOT their IP address. You will run into a myriad of reliability issues if you use IP address.

Kendal Van Dyke
http://kendalvandyke.blogspot.com/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search