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.
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?
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?
sp_configureVWD 2008SQL 2008SQL 2005 Express or Standard
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.
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!
justlearning...
Member
33 Points
27 Posts
Use sp_configure 'user instances enabled' to generate user instance Help
Jun 21, 2007 03:37 AM|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.
ardmore
Member
21 Points
59 Posts
Re: Use sp_configure 'user instances enabled' to generate user instance Help
Oct 14, 2007 08:38 PM|LINK
I get the same problem, how to reslove this issue?
Thanks
arijit.manda...
Member
14 Points
24 Posts
Re: Use sp_configure 'user instances enabled' to generate user instance Help
Jan 11, 2008 05:01 AM|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?
sp_configure
rblanton9982
Member
11 Points
12 Posts
Re: Use sp_configure 'user instances enabled' to generate user instance Help
Jan 16, 2008 07:42 PM|LINK
Hi,
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.
Robert
sql 2005 sp_configure VWD 2008
rblanton9982
Member
11 Points
12 Posts
Re: Use sp_configure 'user instances enabled' to generate user instance Help
Jan 19, 2008 06:38 PM|LINK
Someone posted this link from Scott Guthrie which got me started on the right path:
http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx
Also, Scott's webpage has some demonstrations which were also helpful.
http://www.scottgu.com/talks.aspx
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.
<configuration> <connectionStrings> <remove name=”LocalSqlServer”/> <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=appservicesdb;Integrated Security=True" providerName="System.Data.SqlClient"/> </connectionStrings></configuration>
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?
sp_configure VWD 2008 SQL 2008 SQL 2005 Express or Standard
Stoater
Member
151 Points
42 Posts
Re: Use sp_configure 'user instances enabled' to generate user instance Help
Feb 06, 2008 04:48 PM|LINK
Hi guys,
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.
<connectionStrings><
remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=;Initial Catalog=;User ID=;Password=;" providerName="System.Data.SqlClient"/><
remove name="ClubSiteDB"/><
add name="ClubSiteDB" connectionString="Data Source=;Initial Catalog=;User ID=;Password=;" providerName="System.Data.SqlClient"/></connectionStrings>
Thanks Stoater
wave00
Member
2 Points
21 Posts
Re: Use sp_configure 'user instances enabled' to generate user instance Help
Jul 21, 2008 08:52 PM|LINK
Hi to all, i've used this instruction and now application is running.
To activate "user istance" use this istruction:
[:D]
funes.ja
Member
2 Points
1 Post
Re: Use sp_configure 'user instances enabled' to generate user instance Help
Jul 23, 2008 10:21 PM|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...
KevInKauai
Member
233 Points
301 Posts
Re: Use sp_configure 'user instances enabled' to generate user instance Help
Aug 06, 2008 09:43 PM|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
Toncho11
Member
4 Points
3 Posts
Re: Use sp_configure 'user instances enabled' to generate user instance Help
Dec 20, 2008 09:40 AM|LINK
Thank you!
Removing the extension ".mdf" from the connection string helped me install DotNetNuke on Sql Server 2008 Express.
web.config asp.net SQL 2008