Check 'instdist.out' in the install directory.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

thejamie - 11 Oct 2006 21:30 GMT

What does this mean? It appears to be keeping the wizard from running the
distributor setup on the server.

Code used is:
use master go
sp_adddistributor @distributor = @@servername GO
sp_adddistributiondb @database='distribution' GO

Error is:
Server: Msg 14113, Level 16, State 1, Procedure sp_adddistributiondb, Line 304
Could not execute 'copy "d:\Program Files\Microsoft SQL
Server\MSSQL\DATA\DISTMDL.MDF" "d:\Program Files\Microsoft SQL
Server\MSSQL\DATA\distribution.MDF"'. Check 'instdist.out' in the install
directory.

Signature

Regards,
Jamie

Reply to this Message

Hilary Cotter - 12 Oct 2006 03:20 GMT

What does 'instdist.out say?

You can also issue this command

sp_adddistributiondb 'distributionNew',@data_folder='c:\temp,
@data_file='distribution.mdf',

@log_folder='ctemp', @log_file='distribution.ldf',

@log_file_size=5,@create_mode=1

where c:\temp already exists

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

> What does this mean? It appears to be keeping the wizard from running the
> distributor setup on the server.
[quoted text clipped - 11 lines]
> Server\MSSQL\DATA\distribution.MDF"'. Check 'instdist.out' in the install
> directory.

Reply to this Message

thejamie - 12 Oct 2006 13:05 GMT

Unfortunately, it does not exist on the server.

Signature

Regards,
Jamie

> What does 'instdist.out say?
>
[quoted text clipped - 24 lines]
> > Server\MSSQL\DATA\distribution.MDF"'. Check 'instdist.out' in the install
> > directory.

Reply to this Message

thejamie - 12 Oct 2006 13:08 GMT

Let's try again... the last post appears blank on my screen.
Hilary,
We have searched the server hoping to find this file. The file does not
exist on the server so I don't know what it says. Thus my question - any
idea what it may mean?

Signature

Regards,
Jamie

> What does 'instdist.out say?
>
[quoted text clipped - 24 lines]
> > Server\MSSQL\DATA\distribution.MDF"'. Check 'instdist.out' in the install
> > directory.

Reply to this Message

Hilary Cotter - 12 Oct 2006 15:36 GMT

There is a script called instdist.sql which is run. Any errors are logged to
a file called instdist.out. Somehow you are having a problem running this
script.

Signature

> Let's try again... the last post appears blank on my screen.
> Hilary,
[quoted text clipped - 33 lines]
>> > install
>> > directory.

Reply to this Message

thejamie - 28 Nov 2006 21:29 GMT

Someone deleted one of the folders that SQL Server installs. We reinstalled
SQL and voila, the file is there now.

Signature

Regards,
Jamie

> There is a script called instdist.sql which is run. Any errors are logged to
> a file called instdist.out. Somehow you are having a problem running this
[quoted text clipped - 37 lines]
> >> > install
> >> > directory.

Reply to this Message