generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances.

 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. 

0 rich2912 9/28/2007 6:49:46 PM

Execute this statement:
                

                     0 
                    CS4Ever
                    9/29/2007 9:28:20 AM
                
            

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
 

0 rich2912 9/29/2007 3:03:35 PM

Select the Data | Add New Data Source menu command. This launches the Data Source Configuration Wizard.
In the Data Source Configuration Wizard, in the Choose a Data Source type step, select Database and then click Next, then complete the wizard.
Checkout this link: http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/VS2005pro/Smart_Client/DataBinder.htm
 
Good luck.
Regards,
CS4Ever
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Dont forget to click "Mark as Answer" on the post that helped you.
This credits that member, earns you a point and marks your thread as Resolved so we will ALL know you have been helped. 
This will help me, you and others.

0 CS4Ever 9/30/2007 6:14:19 AM

Ok I got it to work. Thanks!

0 rich2912 10/1/2007 9:25:03 PM