473,387 Members | 1,575 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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

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?

Jan 23 '06 #1
1 9487
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...

Jan 23 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Chris Kennedy | last post by:
I am pulling a decimal value from SQL server and trying to use the format currency and format number function. I am using these values in a large string of HTML to be used in a CDONTS Email. If I...
2
by: Danilo Popović | last post by:
Hi again, I have a problem with replication on SQLServer 2000. I've started "Configure Publishing and Distribution Wizard" and SQLSrvr posted message "SQLServer Enterprise Manager colud not...
0
by: Doug | last post by:
Working with SQL Servers' transactional replication I am having a problem with the subscribers log growing to the size of the full database that I am replicating. Currently I have a 53 gig database...
0
by: Ref | last post by:
Hi I am new with Replication I develop Now the Microsoft Server 2000 Replication And I chose Snapshot type for replication All I need to copy Part of db from Publisher via distributor to...
2
by: mokles | last post by:
Hello All, The setting is SQL server 7, on Windows NT. If the distributor can not access the log on the publisher database ( but subscribers are not deleted yet), will the full backup of the...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
8
by: =?Utf-8?B?UGV0ZXI=?= | last post by:
I'm trying to get a list of SQL Server Instances thru a VB.NET application. I have tried GetDataSource and SMO. I have also tried using ListSQLSvr.exe from...
2
by: TG | last post by:
Hi! Once again I have hit a brick wall here. I have a combobox in which the user types the server name and then clicks on button 'CONNECT' to populate the next combobox which contains all the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.