Mirroring - server network address cannot be reached or does not exist -

-

i have read number of articles on how configure mirroring on sql server 2012. went through steps , worked until hitting final step, didn't work.

when run on principal:

alter database mydbname set partner = 'tcp://1.2.3.4:5022';

i error:

the server network address "tcp://1.2.3.4:5022" can not reached or not exist.

when run counterpart alter statement shown above, on mirror, works fine.

i have tried steps in troubleshooting article.

important points:

  1. the primary , mirror servers in different datacenters, not on same network @ all. not connected vpn. untrusted each other.
  2. i can connect mirror via ssms on primary , run queries. , vice versa.
  3. i configured certificates on each server establish trust relationship. worked during setup , config, no errors.
  4. i configured endpoints on both servers , verified they're active/enabled.
  5. i opened port 5022 on both servers configuring incoming , outgoing windows firewall rules. can telnet mirror principal , vice versa - ports appear open, no problems.
  6. in troubleshooting guide mentioned above, tried steps 1-6. didn't try 7, deleting endpoints , re-creating, because valid , active me.

looking ideas on one.

if can telnet port principal machine fine tcp/ip , firewall settings.

i can remember had similar issue in past. unfortunatly dont remember exact solution related security/authentication of endpoints , sql server service account not having enough permission on mirror machine. unfortunatly error message pretty misleading in case. script endpoints , verify settings, ssms has no ui that. thing check have possibility connect port 5022 mirror principal machine. same error message if connection not possible both instances.

sorry cant provide proper solution, maybe points right direction.


Comments

Post a Comment

Popular posts from this blog

python - Subclassed QStyledItemDelegate ignores Stylesheet -

-
i'm trying subclass qstyleditemdelegate remove focus rectangle in qcombobox . even though i'm calling base implementation of paint function , nothing else, result different. looks if parts of style-sheet influence bounding box of item taken consideration. class pstyleditemdelegate(qstyleditemdelegate): def __init__(self, *args, **kwds): super(pstyleditemdelegate, self).__init__(*args, **kwds) def paint(self, *args, **kwargs): qstyleditemdelegate.paint(*args, **kwargs) what have paint unmodified qstyleditemdelegate ? as suggested tried replacing pyside pyqt4 , works, appears bug. update pyside 1.1.2 1.2.1 result same. unfortunately switch breaks other parts of code, if there no other suggestions i'm going accept answer. edit bug tracked here
Read more

java - HttpClient 3.1 Connection pooling vs HttpClient 4.3.2 -

-
i have used httpclient3.1(java) connection pooling below : import org.apache.commons.httpclient.httpclient; import org.apache.commons.httpclient.multithreadedhttpconnectionmanager; import org.apache.commons.httpclient.params.httpclientparams; import org.apache.commons.httpclient.params.httpmethodparams; import org.apache.log4j.logger; public class httpclientmanager { private static logger logger = logger.getlogger(httpclientmanager.class); private static multithreadedhttpconnectionmanager connectionmanager = new multithreadedhttpconnectionmanager(); private static httpclientparams clientparams = new httpclientparams(); static { try { clientparams.makelenient(); clientparams.setauthenticationpreemptive(false); clientparams.setparameter(httpmethodparams.so_timeout, new integer(30000)); // set so_timeout clientparams.setparameter(httpmethodparams.head_body_check_timeout, new integer(3000)); // head responses
Read more

SQL: Divide the sum of values in one table with the count of rows in another -

-
is possible to, in single query, sum bunch of values in 1 table, , divide count of rows in another? there common id/key in both tables... fyi, win points least info provided in question. answer it's possible...here psuedo code since i'm guessing @ tables , columns select summing / counting whynot (select id, sum(whatever) summing where_ever ) inner join (select id, count(1) counting what_ever)b on a.id = b.id question = 'vague' group a.id
Read more