Normally, with an Express database that runs under a user instance (that is, the connection string has User Instance=True) there isn't much to configure. The "current user" becomes the service account with full permissions when the database is opened, because a copy of the database is created and attached to SQL that runs within the scope of the user. That's why you can normally just hit F5 and have everything running without configuration issues.

The problem you describe may have to do with debugging or security issues. Check out the section Common Issues of this article. The rest of the article is pretty interesting though, and may shed some light on how things actually work.

The same applies to this article: http://msdn.microsoft.com/library/de...seoverview.asp

Cheers and have a good weekend.

Imar
---------------------------------------
Imar Spaanjaars
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.

Imar,

You have been such a huge help. I've bothered you enough. Trust me, it just confirms my decision to choose Wrox books as that which I purchase to learn this stuff. As I said, this is my third Wrox book I have bought in 4 months--and I plan on continuing.

Thank you very much for your courtesy, kindness and direction.

Regards,
Rob Searing

You're welcome. I know it's confusing stuff, but I hope my posts clarified a lot of the confusion. For you, and for others reading this thread.

This sounds like an ideal moment to plug my latest book: ASP.NET 2.0 Instant Results.

In this book, you'll find twelve complete working applications (a Photo Album, a Web Shop, a Bug Tracking application and more) that show you how to accomplish more complex tasks with ASP.NET 2.0. Instead of providing just little code snippets, the book provides an architectural overview of each application, and then digs deep into its code.

It doesn't go as deep in configuring SQL Server (Express or normal editions) but it does show you how to use a number of new SQL features....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
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.