Create Database failed.

Hi!

First of all: I don't really know a lot about MSSQL-Servers, so this question might sound a bit silly ;)

Today I wanted to test an application, that uses a MSSQL-Server for the databases. As they said, that a MSSQL7-Server is required, I thought that a MSSQL-Express 2005-Server would also do the job.

But when it's time to set up the database, I get the following error:

Procdure:CreateDatabase Message:[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE DATABASE failed. Primary file must be at least 3 MB to accommodate a copy of the model database.

With searching the net, I didn't found a solution to my problem...

Does this in the end mean, that I need to install (and buy!) a MSSQL7-Server, because the application won't run with a MSSQL-Express2005-Server? Or is there any way to get this thing up'n'running?

Thanks a lot for your answers!

Martin
Hi,

thats usally a problem of obsolete functions in the procedures in your database. THe best thing is to install the database first on a SQL Server 7.0 (Perhaps you can get somewhere a Developer Edition or another edition which shouldn′t be expensive because they are right now two editions *old*). If you want to leave it on the 7.0 Machine your are fine. If you want to migrate it, do a backup of the database and a restore on the SQl Server 2005 Express Machine. Then search after the *now* buggy procedures and try to eliminate them.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Hi Jens!

Thanks a lot for your answer.

OK, if it's like this, I'll try to find a MSSQL7-Server...

Martin