generating user instances in sql server is disabled. use sp_configure user instances enabl

When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances."

I am currently using SQL server 2005 Express.

What do I need to do, to create an SQL database? Thanks in advance.

Execute this statement:

sp_configure'user instances enabled', 1;RECONFIGURE

You can execute it either from Management Studio for SQL Express (http://msdn.microsoft.com/vstudio/express/sql/download/) or from Visual Stuido (create new connection to SQL Express instance then New Query, then execute it!).

Good luck.

|||

Thanks for the advice. Being so new to this, a lot of that went over my head. So I have two questions...

1. How do I create a new connection the SQL Express instance?

2. How do I execute a query after creating it? (With F5?)

Thanks for your help CS4Ever

|||

Select theData | Add New Data Source menu command. This launches theData Source Configuration Wizard.

In theData Source Configuration Wizard, in theChoose a Data Source type step, selectDatabase and then clickNext,then complete the wizard.

Checkout this link:http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/VS2005pro/Smart_Client/DataBinder.htm

Good luck.

|||Ok I got it to work. Thanks!