Microsoft SQL Server forum - SQL Server could not configure 'Server\Instance' as a Distributor.

Author

SQL Server could not configure 'Server\Instance' as a Distributor.

Michael Swinarski

2006-01-23, 1:23 pm

I am working on setting up our new SQL Server 2005 servers. One of
them will eventually be our Replication Distributor. However when I
attempt to set this up within the wizard, I get the following error:

------------------------------
TITLE: New Publication Wizard
------------------------------
SQL Server could not configure 'Server\Instance' as a Distributor.
------------------------------
ADDITIONAL INFORMATION:

Property LoginSecure cannot be changed or read after a connection
string has been set. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
BUTTONS: OK
------------------------------

In the "Specify the Domain or Machine account under which the Snap Shot
Agent will run" page, I designate a Windows Auth. domain user; The same
user that is used to start SQL Service. Any idea as to why I am
getting this error?

Michael Swinarski

2006-01-23, 8:24 pm

Strangely enough, if I ask the wizard to generate the SQL and then take
the script and run it manually.... It works just fine... Don't ask me
why...

Sponsored Links