Facebook
Twitter
D
davejuk
Guest
I like to be able to upload my SQL database to the App_Data directory and use a connection string like this to attach it:
Data Source=.\SQLEXPRESS;Integrated Security=true;User Instance=true;AttachDBFilename=|DataDirectory|\mydb.mdf;Initial Catalog=mydb.mdf;
However, in order for this to work I have to change the website to use the standard ASP.NET 4.0 application pool instead of the one plesk likes to use "plesk(default)(4.0)(pool)". I then have to add permissions for NETWORK SERVICE to access the httpdocs directory for the site, and give it write access to App_Data. This does work but it's a little hacky and I'm worried it might confuse Plesk and I will end up with problems (such as a website that I am unable to delete properly).
Is there a better way to do this?
Data Source=.\SQLEXPRESS;Integrated Security=true;User Instance=true;AttachDBFilename=|DataDirectory|\mydb.mdf;Initial Catalog=mydb.mdf;
However, in order for this to work I have to change the website to use the standard ASP.NET 4.0 application pool instead of the one plesk likes to use "plesk(default)(4.0)(pool)". I then have to add permissions for NETWORK SERVICE to access the httpdocs directory for the site, and give it write access to App_Data. This does work but it's a little hacky and I'm worried it might confuse Plesk and I will end up with problems (such as a website that I am unable to delete properly).
Is there a better way to do this?
