p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 (http://p2p.wrox.com/forumdisplay.php?f=252)
-   -   Survey Engine (http://p2p.wrox.com/showthread.php?t=44422)

anitafn2005 June 23rd, 2006 06:14 PM

Survey Engine
 
I tried the survey and got this:
I copy the code from the book. Is this because of sql express?
or..??

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.


Imar June 25th, 2006 04:01 AM

Hi there,

How are you opening the application? Through IIS with the supplied installer, or directly in Visual Web Developer?

Does your machine have a local copy of SQL Server Express 2005 installed?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

anitafn2005 June 25th, 2006 10:55 PM

Hi Imar,

Thank you for the replied.
I open this through Visual Web Developer I have both sql express and sql 2005 installed.
The database doesn't look want to connect. Always closing down on me due to user instance.



Imar June 26th, 2006 01:25 AM

This error may be caused by the fact you installed SQL Server after you installed Express? Maybe this helps?

http://blog.krisvandermast.com/Faile...lBeClosed.aspx

http://www.differentpla.net/node/487

Other people have described other symptoms and different fixes, so you may want to Google for "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. " and see if that brings anything new up....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

anitafn2005 June 26th, 2006 11:17 AM

I have fixed the SQL express.
Now is working...

Thank you


csharpa February 18th, 2007 01:56 AM

If just install the visual studio completely you will recieve this error, To solve this problem u need to install the microsoft SQL server which is another CD. that is the resean that you cannt access the .mdf file and you will get this error message "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed."



All times are GMT -4. The time now is 04:40 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.