[THIN] Re: sql replication

  • From: Berny Stapleton <berny@xxxxxxxxxxxxxxxxx>
  • To: thin@xxxxxxxxxxxxx
  • Date: Wed, 23 Nov 2011 22:07:56 +0000

On the failed install have you tried a dsmaint to reconnect to the db
(specified credentials again)?
On Nov 23, 2011 9:53 p.m., "Bruce Ricker" <brucericker@xxxxxxxxx> wrote:

> 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>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>
>> 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>
>>> 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>
>>> 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: