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: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
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.
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.
Ok I got it to work. Thanks!