• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

SQL database in App_Data under Plesk 9.5.4

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?
 
Back
Top