problem of creating database

I am using Visula Studio 2005. When i try to create database from the visual studio Tools option-> careate database and press ok then following error occur......

Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.

how can i fix the problem?

first of all you must have a clear picture what is this User intance and do u really want to create user instance. if the answer is yes refer this link the problem is discussed here

http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1

If you don't need user instance then go to SQL Server man agement studio and create database

Madhu

|||

i have told that when i am creating database in SQL SERVER 2005, it shows that it can't create instance of sql server. it clearly explains that the user instance is Sql Server instance. See my problem again.......

Here is the error

........

Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.

.........

|||

But...do you want to create user instance, or do you want to create a database on a server instance ? If the latter, you will have to use the server explorer, not the Add New Item > Database.

If you want to create a user instance, you will need to have SQLExpress installed on the machine and configured in the database option of Visual Studio.

Jens K. Suessmeyer

http://www.sqlserver2005.de