Wrox Programmer Forums
|
BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6
This is the forum to discuss the Wrox book ASP.NET 2.0 Instant Results by Imar Spaanjaars, Paul Wilton, Shawn Livermore; ISBN: 9780471749516
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 4th, 2007, 11:24 PM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 119
Thanks: 0
Thanked 0 Times in 0 Posts
Default Asp.Net 2.0 instant results Sql Server connectivty

 i put the database in the database folder it doesn't work. it shows this error

: 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.

<connectionStrings>


      <add name="ConnectionString" connectionString="Data Source=(local)\SqlExpress;AttachDbFilename=|DataDi rectory|\SurveyDB.mdf;Integrated Security=True;User Instance=False" providerName=" System.Data.SqlClient"/>



    </connectionStrings>







 
Old June 5th, 2007, 01:16 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

Can you please provide a little bit more information? What database did you put in what folder? How do you open the site? From VWD or from IIS?

Try removing the User Instance attribute, or set it to True.

Otherwise, search Google for this

There could be a number of reasons for this errors; many people reported it in different scenarios so you'll need to see what solution fits yours...

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
 
Old June 5th, 2007, 07:48 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 119
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I put data base in the App Data Folder. Double Click the database name in this case the Database Name SurveyDB.mdf and in the server explorer double click the data base. I open it through VWD

 
Old June 5th, 2007, 07:59 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Are you sure SQL Express is configured correctly? Are you sure the account used by the web server (probably your own account when you're opening it from VWD) has permissions for the App_Data folder?

Did you try removing and changing the User Instance attribute?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
 
Old June 5th, 2007, 11:07 PM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 119
Thanks: 0
Thanked 0 Times in 0 Posts
Default

 Tried removing User Instance. Didnot work. I am not sure SQL Express is configured correctly. Basically I dont know how to configure SQL Server. Also not sure the account used by the web server probably is my account when I open it from VWD has permissiond for the App_Data Folder. Dont know how to find it. Please guide me how to find it

 
Old June 6th, 2007, 12:24 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

Check out pages 162 and onwards for instructions about configuring the security of your database.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Instant Results - Add SubMenu Items jvm2552 ASP.NET 2.0 Professional 1 September 4th, 2007 01:13 PM
Blog project in Asp.net 2.0 instant results sriniblog ASP.NET 1.0 and 1.1 Basics 0 December 14th, 2006 05:44 PM
Instant Results - CMS Admin Problem NickNelson BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 3 November 30th, 2006 04:49 PM
ASP.NET 2.0 Instant Results Book -Survey Engine autolib BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 9 August 29th, 2006 01:05 AM
Errata available for ASP.NET 2.0 Instant Results Imar BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 0 July 31st, 2006 03:18 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.