Re: Multi Domain Replication Security Issue
- From: "asd" <asd@xxxxxxx>
- Date: Thu, 26 Jan 2006 15:48:54 +0100
To be sure we started off with jobs being owned by the domain admin
accounts. No avail.
Any thoughts appreciated.
BR,
GAZ
"Peter Yang [MSFT]" <petery@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:Cs4jakhIGHA.3944@xxxxxxxxxxxxxxxxxxxxxxxx
> Hello,
>
> You could check the job owner of the merge job:
>
> 1. Right click the pull subscription->Properites->Synchrnization->Agent
> Properites
>
> 2. Change the job owner to the local account with SQL system admin account
> on both local and resmote server to test.
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> =====================================================
>
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> --------------------
>>From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
>>References: <uJmqQCaIGHA.3176@xxxxxxxxxxxxxxxxxxxx>
> <e9uuFgaIGHA.596@xxxxxxxxxxxxxxxxxxxx>
> <ujJqbTbIGHA.3752@xxxxxxxxxxxxxxxxxxxx>
>>Subject: Re: Multi Domain Replication Security Issue
>>Date: Wed, 25 Jan 2006 09:48:50 -0500
>>Lines: 26
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>X-RFC2646: Format=Flowed; Response
>>Message-ID: <#s1N35bIGHA.3408@xxxxxxxxxxxxxxxxxxxx>
>>Newsgroups:
> microsoft.public.sqlserver.relationalserver.performance,microsoft.public.sql
> server.replication,microsoft.public.sqlserver.security,microsoft.public.sqls
> erver.securitytools
>>NNTP-Posting-Host: 165.1.27.105
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:68745
> microsoft.public.sqlserver.security:26245
> microsoft.public.sqlserver.securitytools:1079
> microsoft.public.sqlserver.relationalserver.performance:117
>>X-Tomcat-NG: microsoft.public.sqlserver.security
>>
>>Is the sa account you are using in your agent to connect to the subscriber
>>the publisher sa account or the subscriber one? It should be the publisher
>>one.
>>
>>This could be a name resolution problem or a account problem. It sound
> like
>>its not a name resolution problem as you can connect to the publisher and
>>configure the pull. So it probably is an account problem.
>>
>>--
>>Hilary Cotter
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>Looking for a FAQ on Indexing Services/SQL FTS
>>http://www.indexserverfaq.com
>>
>>"asd" <asd@xxxxxxx> wrote in message
>>news:ujJqbTbIGHA.3752@xxxxxxxxxxxxxxxxxxxxxxx
>>> Thanks for the aswer but unfortunately it does not work. We still get
> the
>>> same message 'SQL server does not exist or access denied.'
>>>
>>> We can ping the server in question with both the IP address and its
> name,
>>> but still we cannot run the replication.
>>>
>>
>>
>>
>
.
- References:
- Re: Multi Domain Replication Security Issue
- From: Peter Yang [MSFT]
- Re: Multi Domain Replication Security Issue
- Prev by Date: restricting access to databases in SQL Server Management Studio
- Next by Date: Re: Denial of Service: BINARY_CHECKSUM of TEXT column hangs CPU: SQL 2K SP4
- Previous by thread: Re: Multi Domain Replication Security Issue
- Next by thread: Denial of Service: BINARY_CHECKSUM of TEXT column hangs CPU: SQL 2K SP4
- Index(es):
Relevant Pages
|
|
