View Single Post
  #4 (permalink)  
Old November 9th, 2009, 12:54 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts

Maybe I should assume I'm using SQL Server 2005 and use your instructions in Appendix B to set up my site that way ?
Yes, you can always do that, as follows:

1. Attach the database to a non-Express version of SQL Server

2. Add the web server account (ASPNET or Network Service) (or use SQL Server security)

3. Grant permissions to this account

4. Change your connection string to point to your instance of SQL and use Initial Catalog instead of the attachdbfilename

Hope this helps,

Imar Spaanjaars
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
HungryCaterpillar (November 9th, 2009)