free asp.net web hosting


Login         Members       Shared Hosting   |                       New Features   |   Advertise   |   Tutorials   |   Product Reviews in India   |   Free aptitude test questions  |   TATA Nano Car reviews






Total members: 82075
Average new registrations per day (in last 7 days): 44


New Registration: Open

Register Now













Home » Questions & Answers » Generating user instance in sql server disabled





Generating user instance in sql server disabled

7/5/2008


Author: Aashish

http://aspspider.biz/Partner02

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.

SQLExpress database file auto-creation error:

The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:

  1. If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist.
  2. If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
  3. Sql Server Express must be installed on the machine.
  4. The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.



I am getting the above error while i want to log into my site or make any changes in my database on my localhost it works fine. why is this error generated  have i done something wrong in attaching the database or what. Pleaase help.........

Answers .............
Author: Webmaster

webmaster - AspSpider.NET

Posted Date: 7/5/2008 		http://aspspider.info/manjaly

My Beta site
User instances are disabled in AspSpider.
Author: Aashish

Posted Date: 7/6/2008 		http://aspspider.biz/Partner02
If user instanes are disabled in aspspider what does this mean is it that i will never login to my site if i use membership,roles and profiling features i dont know much about sql server please help me is there a workaround for my site to work
Author: Webmaster

webmaster - AspSpider.NET

Posted Date: 7/6/2008 		http://aspspider.info/manjaly

My Beta site
Read this page - http://www.aspspider.com/tips/Tip16.aspx


Author: Aashish

Posted Date: 7/6/2008 		http://aspspider.biz/Partner02
Hi i have already uploaded the database to the database folder my database are ASPNETDB.mdf and Horoscope.mdf
Do i also need to upload the .ldf file from my local machine.
Also do i have to upload the database to App_Data folder also the link you suggested tells to only upload the database to the database folder and attaching process will do the rest. I have done all the things and now i am feeling hopeless please help.
Author: Webmaster

webmaster - AspSpider.NET

Posted Date: 7/7/2008 		http://aspspider.info/manjaly

My Beta site
What is the problem now? Are you not able to attach database and connect to it? What are the steps you have done so far? Where is it failing? What are the error messages?
Author: Aashish

Posted Date: 7/7/2008 		http://aspspider.biz/Partner02
Visit my site at this link http://aspspider.biz/Partner02/login.aspx and enter any username and password it will generate this error before going to check for any username or password.
I have already attached the database successfully but before connecting to it this error message is generated.

Server Error in '/Partner02' Application.

Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.

You can check for yourself on http://aspspider.biz/Partner02/login.aspx
Author: Aashish

Posted Date: 7/7/2008 		http://aspspider.biz/Partner02
Hi webmaster the problem is solved.
I added this piece of code to my connectionstring section in the web.config file and than it ran fine.
Thanks for all your help and quick responses.

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer"  connectionString="Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=Partner02_ASPNETDB"  />

You must login to post answer for this question.
 







Partners   Privacy Policy   Terms of use   Contact Us

SpiderWorks Technologies.
All Rights Reserved.