Error Creating Distribution Database

• Chris Kitchen

  Hall of Fame

  Points: 3090

  More actions

  November 16, 2006 at 5:51 am

  #94822

  Hi,

  I'm using SQL Server 2000 EM to create a publication, and the step that creates the distribution database keeps failing with the following error message:

   

  SQL Server Enterprise Manager could not configure '%' as the Distributor for '%'.

  Error 1803: CREATE DATABASE failed. Could not allocate enough disk space for a new database on the named disks. Total space allocated must be at least 75 MB to accommodate a copy of the model database.

   

  There is loads on space on all the disks, and there are no restrictions on the model database.  Any ideas?

   

  Thanks in advance.

  www.sqlAssociates.co.uk

• N P-286063

  SSC Enthusiast

  Points: 164

  More actions

  November 19, 2006 at 1:33 pm

  #672844

  http://www.sqlteam.com/item.asp?ItemID=10060

  helpful? dunno.