I really like this book and think it has been a great tool helping me teach myself. I am a little stuck at the beginning of chapter 11 when connecting to the .mdl file that has the sample database. I keep getting the 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." I have SQL 2005 downloaded and permission to access the folder but I do not know this means or how to fix it. Any advice would be greatly appreciated. I am running windows vista if it makes a difference.
Thanks,
Justin

Hi there,

What version of SQL Server are you using? SQL Server Express, as explained in Chapter 1?

Also, did you check out Appendix B?


Cheers,

Imar


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

Hi,

I got a lot of problems with the connection to the database(SQL). I'm using Windows Vista and it is quite difficult to get everything match. But something you can test is that you right-click the icon for VS and "Run as administrator".

http://www.workidoo.com

The book was written on Vista, so typically, if you follow the setup instructions in the first chapter and use SQL Server Express, you should be fine.

If you're using the full version of SQL Server, take a look at Appendix B for configuration instructions. Still, to follow along with the book and to generally develop your web applications, SQL Server Express should be your database of choice.

Cheers,

Imar

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