0

I've created a project in installshiel program uses SQL Server 2008 and written in C#.

Everything works fine and scripts of database also works fine but I had error when trying to install program which is created by installshield

error is

Error 27506. Error executing SQL script db_name.sql. Line 9
The CREATE DATABASE statement failed. The primary file must be at least 3 MB to accomodate a copy of the model database. (1803)

I tried to search in google but I couldn't find any results

please help

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Scorpio
  • 153
  • 1
  • 5
  • 13
  • Well - the error really says it all - the database you're trying to create obviously has a file that is **too small** to hold a copy of the `model` database. Can you please check this, and/or post your SQL script that creates the database? – marc_s Aug 15 '12 at 14:31

1 Answers1

0

There is absolutely nothing wrong with the installer. It's doing exactly what it was told to do: Execute a SQL script that was injected into it and report any errors that occur.

You didn't actually provide the contents of the SQL but basically you need to look at the CREATE DATABASE statement paying attention to the SIZE, MAXSIZE and FILEGROWTH arguments.

Christopher Painter
  • 54,556
  • 6
  • 63
  • 100