[THIN] Re: sql replication

  • From: Webster <webster@xxxxxxxxxxxxxxx>
  • To: "thin@xxxxxxxxxxxxx" <thin@xxxxxxxxxxxxx>
  • Date: Wed, 23 Nov 2011 22:11:00 +0000

Have you read this:

http://blogs.citrix.com/2011/09/22/setting-up-sql-replication-for-the-xenapp-data-store/


Carl Webster
Consultant and Citrix Technology Professional
http://www.CarlWebster.com<http://www.carlwebster.com/>


From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of 
Bruce Ricker
Sent: Wednesday, November 23, 2011 3:53 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: sql replication

yep and the test is successful during the install on the replica no problem
On Wed, Nov 23, 2011 at 1:51 PM, Berny Stapleton 
<berny@xxxxxxxxxxxxxxxxx<mailto:berny@xxxxxxxxxxxxxxxxx>> wrote:

Just to ask the simple question, the other server is setup to accept SQL auth?

Secondly, I haven't done SQL auth on a replicated setup; what happens when you 
create a second account with access to the db on the replica and use that for 
auth? I'm wondering if there is something wrong with the account...

Actually, if you do a manual install and do a test connection what happens?

Berny
On Nov 23, 2011 3:06 p.m., "Bruce Ricker" 
<brucericker@xxxxxxxxx<mailto:brucericker@xxxxxxxxx>> wrote:
Yes and she says she gets login failed for nt authority/anonymous logon..

I think its dtc settings...

We r using sql auth not windows

Dtc is set to no auth, does it have to be set to mutual replication ?


Sent from my iPhone

On Nov 22, 2011, at 2:51 PM, Berny Stapleton 
<berny@xxxxxxxxxxxxxxxxx<mailto:berny@xxxxxxxxxxxxxxxxx>> wrote:

Has the dba run profiler against it to see what the db server is saying?
On Nov 21, 2011 11:48 p.m., "Bruce Ricker" 
<brucericker@xxxxxxxxx<mailto:brucericker@xxxxxxxxx>> wrote:
I cannot get the first server in emea to join the replicated xenapp6 datastore

Hangs in starting mfcom and ima

Dba appears to have it set up properly

Do i need configuration logging in order to support repl to emea?  Any other 
ideas?

It joins the publisher in northamerica no problem, just not the updatable 
subscription replicated ds locally in eu


Other related posts: