Re: Multi Domain Replication Security Issue
- From: petery@xxxxxxxxxxxxxxxxxxxx (Peter Yang [MSFT])
- Date: Thu, 26 Jan 2006 01:38:07 GMT
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.
>>
>
>
>
.
- Follow-Ups:
- Prev by Date: Re: Is there a possibility to be hacked
- Next by Date: Denial of Service: BINARY_CHECKSUM of TEXT column hangs CPU: SQL 2K SP4
- Previous by thread: Is there a possibility to be hacked
- Next by thread: Re: Multi Domain Replication Security Issue
- Index(es):
Relevant Pages
|
