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

Error: Failed to generate a user instance...

Hello,

When trying to add a new SQL database to a VS 2005 project I get this error:

Failed to generate a user instance of SQL server due to a failure in starting the process for the user instance. The connection will be closed. [CLIENT: <local machine>]

Any ideas what is causing this error and how to fix it?

Thanks

Tom

Hi Tom,

This question has been discussed several times in this forum, you should do a search and read other discussions to see if they address your issue.

The first step in troubleshooting this is to look at the User Instance error log located at C:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\<main instance name> (The default instance name is SQLEXPRESS) and see if it give any clues to the cause of the error.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

error while generating ad hoc model for Analysis Services Cube

hi,

I try to generate ad hoc reporting model for analysis services cube in reporting services.
in Management Studio I connected to reporting services, defined a data source to the analysis services database.
But If i try to generate model i get the error:
"While connection with a data source a mistake has appeared, or the query is invalid for the data source. (rsCannotPrepareQuery)(Report Services SOAP Proxy Source)"

Any ideas as to what may be the problem?
Thanks!

karaman

Moving to Reporting Services forum.|||I am having the same issue and can find no other reference to it, anywhere. Did you get this resolved?

error while generating ad hoc model for Analysis Services Cube

hi,

I try to generate ad hoc reporting model for analysis services cube in reporting services.
in Management Studio I connected to reporting services, defined a data source to the analysis services database.
But If i try to generate model i get the error:
"While connection with a data source a mistake has appeared, or the query is invalid for the data source. (rsCannotPrepareQuery)(Report Services SOAP Proxy Source)"

Any ideas as to what may be the problem?
Thanks!

karaman

Moving to Reporting Services forum.|||I am having the same issue and can find no other reference to it, anywhere. Did you get this resolved?