Last post Jun 18, 2011 12:23 PM by ismailawadat
Jun 20, 2007 11:37 PM|justlearningasp|LINK
I just downloaded the club starter kit and I tried to build but the following error was generated.
Server Error in '/ClubWebSite3' Application. Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.
I tried the solution that I found on the web that states
Open the SQL Server Management Studio Express. This is the downloadable program in the same site where you downloaded the SQL Server 2005 express used to manage SQL Server 2005 Express.
In the query editor type this text: exec sp_configure 'user instances enabled', 1.
Then type: Reconfigure.
Then restart the SQL Server database.
I ran the above query but still get this error.
I know that it has something to do with installing SQL Server Management Express.
Am I better off uninstalling this feature or can I troubleshoot through it.
Oct 14, 2007 04:38 PM|ardmore|LINK
I get the same problem, how to reslove this issue?
Jan 11, 2008 01:01 AM|arijit.mandal|LINK
I had made an WebParts Demo application, But when i want to see this application in Browser an error comes.
Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.
Can anyone suggest me what the problem is?
Jan 16, 2008 03:42 PM|rblanton9982|LINK
I recently installed Visual Web Developer 2008 and have been creating demos, etc. The DB creation and access worked fine. In order to follow some of the online webcasts I installed SQL 2005 Express and that is when the problem started with the sp_configure
Error Message as described in this thread. I was not able to use any of my demos for DB access after this point. I then uninstalled SQL 2005 Express edition but the problem still occurs in the VWD environment. Isn't VWD suppose to be self contained? Why
is the solution now to install SQL 2005 Express and execute the sq_configure command? Installing SQL 2005 Express caused the problem in the first place and a subsequent uninstall didn't reverse the changes so the problem persisted. Is there anyone that has
a detailed solution? Is it to reinstall SQL 2005 Express? Is this even compatible with VWD 2008 Express?
Thanks for any advice.
Jan 19, 2008 02:38 PM|rblanton9982|LINK
Someone posted this link from Scott Guthrie which got me started on the right path:
Also, Scott's webpage has some demonstrations which were also helpful.
One thing I will mention is this: Make sure when changing the connectionString in the web.config file to leave off the .mdf when using the "Initial Catalog" parameter. I did not remove the extension .mdf from the new DB (which I created in SQL2005 with
aspnet_regsql.exe) when changing from the "AtachDbFilename" to the "Initial Catalog" parameter. I spent several hours wondering why my connection could not be made in the ASP.NET Configuration wizard.
One thing I am curious about though is, in actual practice, do most companies create new providers (for each web app they are working on) and do not
even use the defaults used in VS and VWD?
SQL 2005 Express or Standard
Feb 06, 2008 12:48 PM|Stoater|LINK
I don't know if this is the answer or not but I had the same error and I made the following changes to my web.config file and everything is working fine now. I was using a remote sql server 2005 database.
Hope this helps.
Jul 21, 2008 04:52 PM|wave00|LINK
Hi to all, i've used this instruction and now application is running.
To activate "user istance" use this istruction:
EXEC sp_configure 'user instances enabled', 1;RECONFIGURE;
Jul 23, 2008 06:21 PM|funes.ja|LINK
Hi to all, yes i'm too use that instruction and everithing works ok...
Note: the service it's must stop and iniciate after run this...
Aug 06, 2008 05:43 PM|KevInKauai|LINK
I'm CURIOUS at to what circumstances cause this sudden cessation of the availability. To my knowledge, I didn't do anything explicitly to cause it. However, there was a "suspicious" Windows Update that mentioned SQL Server around at the time.
Inquiring minds NEED to know why these kinds of "showstoppers" erupt!
tia ... :) KevInKauai
Dec 20, 2008 05:40 AM|Toncho11|LINK
Removing the extension ".mdf" from the connection string helped me install DotNetNuke on Sql Server 2008 Express.
Feb 08, 2010 12:19 AM|bellsoft|LINK
Dec 23, 2010 12:23 AM|Kiran Viradiya|LINK
Thank you very much.
Jun 15, 2011 03:31 PM|ismailawadat|LINK
"user instances enabled" this only for express edition not for enterprise edition what i should do and i made it create a database but when i go web.config still point to datasourse "./express" not to the new database when you change the connection
string datasourse it make a problem in the connection
Jun 18, 2011 12:23 PM|ismailawadat|LINK
there a way to move all of that manualy and in very easy way
take the created database after changing web configuration then change the provider name don't leave it deafult then put your connection string it worked with me very will