Error: Generating Instances in SQL Server is disabled...

Use sp_configure 'user instances enabled' to generate user instances.

I get the above error when I attempt to add an SQL Database item into my VS (C#) project. I do not understand what needs to be done to correct the problem.

Any help is appreciated.

Thank You,

Klaus

From SQL Server 2005 Books Onlinetopic:

user instances enabled Option

http://msdn2.microsoft.com/en-us/library/ms187513.aspx

The user instance enabled option that you can access through sp_configure is not supported in Microsoft SQL Server 2005. This option works only with SQL Server 2005 Express Edition (SQL Server Express).

For more information about how user instances work, see User Instances for Non-Administrators.

User Instances for Non-Administrators

http://msdn2.microsoft.com/en-us/library/ms143684.aspx