You need to Register for free and Login to post a message in the forum.

Forum

Forums > Users Lounge > Everything Else
Subject: Stuffed up LocalHost and SQL
Prev Next
You are not authorized to post a reply.

Author Messages
ollep
DNN Creative Magazine Subscriber
Nuke Master
Nuke Master
Posts:100
29 Sep 2008 11:24 PM  

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...
ollep
DNN Creative Magazine Subscriber
Nuke Master
Nuke Master
Posts:100
30 Sep 2008 6:59 AM  
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…
ollep
DNN Creative Magazine Subscriber
Nuke Master
Nuke Master
Posts:100
30 Sep 2008 7:30 AM  
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!!!
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2520
30 Sep 2008 8:48 AM  
Glad that you got this solved.
Joe Craig
DNN Creative Support
Subscribe to the website
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3426
01 Oct 2008 8:35 AM  
Hello,

Yes thanks for posting the info, I'm sure others will find it useful,
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
You are not authorized to post a reply.
Forums > Users Lounge > Everything Else > Stuffed up LocalHost and SQL


ActiveForums 3.7

Latest Forum Posts

RE: Child portal to live site by jncraig
Is there any URL that will get me to your site?
RE: Child portal to live site by jncraig
"Ok I changed the A record of the Jackson site to point to the IP address of the DNN portal. I than...
RE: Child portal to live site by jncraig
I'm sorry that I offended you.  I was trying to give an honest answer.  That answer is, I continue t...
RE: Child portal to live site by psgrzelak
Kind of a round about way of answering my question without answering it.... I prefer the straight fo...
RE: Child portal to live site by jncraig
A subscription to this site will let you view the tutorials.  I believe that will be useful.  In fac...
RE: Child portal to live site by psgrzelak
Ok I changed the A record of the Jackson site to point to the IP address of the DNN portal. I than w...
RE: DotNetNuke News 8th Dec 08 by jncraig
Yes, I'm getting an error, also. But ... you can probably get the podcast from this link: http...
RE: Can't Login! Login Page can't be accessed... by jncraig
This table is part of your DotNetNuke database.You might first want to review these tutorials to hel...
DotNetNuke News 8th Dec 08 by pwadding
When I attempt to download the  Podcast I get an error message. Tried both servers. The first few li...
RE: Can't Login! Login Page can't be accessed... by e-kreator
a database that you mean.
RE: DotNetNuke 4.9.1 and 5.0.0 by jncraig
Yes, lots of learning, lots of new things and new ways.  I played a little with Beta6 of DotNetNuke ...
RE: PDF File Content by jncraig
If you want to just serve up the PDF files as PDF files, upload them using the File Manager.  You ca...
RE: Navigating between modules by jncraig
What is the URL that is generated? To which page does it send you?
RE: New Logo cant display by jncraig
There is nothing wrong with this, provided that you did it correctly.  I would have to look at your ...
RE: Child portal to live site by jncraig
You should set DNS to point the URL to the IP address of the DotNetNuke installation.  Inside of the...
RE: PopUp Page by jncraig
To open a link in a new window, format the link this way:Link to us! It is the target="_blank" that...
RE: How to Change fckeditor alignment by jncraig
It might be easier to use a different skin for your administrative pages. There have been some ot...
RE: Can't Login! Login Page can't be accessed... by jncraig
If you have access to your database, look at the Portals table.  Make sure that LoginTabID is set to...
RE: Can't Login! Login Page can't be accessed... by e-kreator
Hello my problem is that the configuration management in login page page was sent to a Web page that...
RE: Create new 'host' user? by jncraig
You can change a regular user to a Host, by setting the "Host" user's IsSuperUser set to True in the...
AppTheory
RSS Feeds