Re: Error 14113 while trying to setup replication on SQL Server 2000 S
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Fri, 22 Jun 2007 14:06:10 -0400
Can you try to run command shell from within query analyzer? Can you create
subfolders within your snapshot location?
--
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
"Gaston" <Gaston@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ADC431B8-38B5-477D-BE35-AFBF9D6903EC@xxxxxxxxxxxxxxxx
Hi,
I'm trying to run the wizard to setup replication on a SQL Server 2000
SP3.
Entering the parameters goes without a problem but when executing the
script
I'm getting an error 14113:
SQL Server Enterprise MAnager could not configure 'XYZ' as the distributor
for 'XYZ'.
Error 14113: Could not execute c:\... \instdist.sql
I have all the necessary rights on the DB server and on Win 2003.
I also noticed that XP_CMDSHELL doesn't work on this server (probably
needed
to execute the previous line) so I executed the instdist.sql manually in
query analyzer.
This clearly isn't enough to get replication working.
The problem with XP_CMDSHELL:
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 1260 from CreateProcess on line 675
I already dropped XP_CMDSHELL:
exec sp_dropextendedproc 'xp_cmdshell'
then replaced the dll with one from another server (just in case) and
re-installed it:
exec sp_addextendedproc 'xp_cmdshell', 'xplog70.dll'
all with the same result.
IMHO both problems are related. Any suggestions?
Tanks in advance,
Gaston.
.
- Follow-Ups:
- Prev by Date: Re: MSREPL_Commands TABLE
- Next by Date: Can't copy/export a database with identity *NEWBIE*
- Previous by thread: MSREPL_Commands TABLE
- Next by thread: Re: Error 14113 while trying to setup replication on SQL Server 20
- Index(es):
Relevant Pages
|
