Hello,
From the error description, it is related to the configuration of
distributor. Do you use local or remote distributor?
If you use local distributor, you may try the following steps to see if it
helps:
1. Right click local publicaiton->Distributor properties
2. Select the publisher in the list, click ...
3. In agent connection mode, select "impoersonate the agent process account"
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.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
[quoted text, click to view] >Thread-Topic: sql server 2005 replication set up error
>thread-index: AcYvV4tUJzEwgBLqSsmqJJaKNh2Cnw==
>X-WBNR-Posting-Host: 69.158.125.140
>From: "=?Utf-8?B?YnNhbmRlcnM=?=" <missisummer@community.nospam>
>Subject: sql server 2005 replication set up error
>Date: Sat, 11 Feb 2006 14:07:27 -0800
>Lines: 28
>Message-ID: <DCF406D8-22C8-47BC-8565-D66DC3CC815F@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:69275
>X-Tomcat-NG: microsoft.public.sqlserver.replication
>
>Hi,
>I installed sql server 2005 in two machine and want to set up replications
>between them, on mahcine A , I want to create a publication and a
>distributor. I have a administrator account "davidadmin" and password "abc
"
>in this machine(A). In new publication wizard, in Snaphsot Agent Security
>windows, I input "davidadmin" account as process account and input the
>"davidadmin" password, I used default options for other fields. then I
push
>"finsh" button to create the publication, but it gave me the error when
>configuring the distributor, I copied the error report as follow:
>================================================
>-Configuring the Distributor(Error)
> Messages
> . SQL Server could not configure 'A' as a distributor.(New Publication
>Wizard)
> ------------------
> ADDITIONAL INFORMATION:
> Property LoginSecure cannot be changed or read after a connection
string
>has been set(Microsoft SqlServer.Connection Info)
>===============================================
>could you tell me how can I fix it?
>thanks
>
>
>
>
>
>
>
>
