After reinstalling the SQL Server I get the following error when I attempt to access my local DNN Installation:


Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.


I checked around and they talk about sp_confgure everywhere.

But where do I find it and change the settings?


Cheers


Olle...

OK, Nine hours later and Getting nowhere.

I’ve read 100 forum post and Not One can say how find “SP_Configure” Settings or how to Enable “User Instances”

Just did Issue32 of the Tutorials. Setting up the Database connection and creating Queries works fine – but I can’t get access to the Local Host installation:

Here’s the error – and I have tried reinstalling user a couple of times.

Login failed for user 'ollepersson'. The user is not associated with a trusted SQL Server connection.

I then tried to reinstall DNN 4:8:4 on my XP-Pro – in a different folder.

All worked fine until I tested the database connection and got this error.

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 15383
Message: Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.


Any Ideas Please??


Olle…

Finally!!!!!!

I found this string in a forum:

'user instances enabled' is a server option of SQL Express, you can right click VS->new a Data Connection to the SQL Express instance->new a query->execute the following statements:
sp_configure 'user instances enabled', 1; RECONFIGURE


Congratulations
Congratulations, you have successfully installed DotNetNuke.


God Night!!!

Glad that you got this solved.

Hello,

Yes thanks for posting the info, I'm sure others will find it useful,