1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

SQL database in App_Data under Plesk 9.5.4

Discussion in 'Plesk 9.x for Windows Issue, Fixes, How-To' started by davejuk, Jul 3, 2012.

  1. davejuk

    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?