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

Urgent: Reconfigurator and MSSQL 2005 Errors

Discussion in 'Plesk 10.x for Windows Issues, Fixes, How-To' started by MuratC, Dec 19, 2010.

  1. MuratC

    MuratC Guest

    0
     
    Hello,

    Yesteday, I've upgraded Plesk 9.5 to 10. My problem was on 9.5 and I hope that it will fixed when I upgrade 10 but it is still continue. My server is Windows 2008 Standard.

    I executed Plesk Reconfigurator -> Check component and folder permissions on Plesk 9.5.
    It finished without problem. But, when I reboot machine, MSSQL will down. Errors are:

    Unable to open the physical file "C:\Program Files\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\Data\database.mdf". Operating system error 5.

    Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.


    It never come back if I didn't delete tempdb.mdf and templog.dlf in C:\Program Files\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\Data and after I recreate MSSQL database / user and dumb data in it.

    I really tried to do this and I need a fix for this.
    Does anyone have same problem or any advice for fix this issue without reinstall whole system.

    Thanks now.
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,557
    Likes Received:
    1,242
    Location:
    Novosibirsk, Russia
    This happens because Network Service account does not have necessary rights to access databases folder C:\Program Files\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\Data\
    This account is included into "psacln" group that is denied full access to this folder by Parallels Plesk Panel security design.

    There are actually two ways to fix such sort of problems:
    - either grant Network Service access to DATA folder.
    - start SQLSERVER as a local system account
     
  3. MuratC

    MuratC Guest

    0
     
    Yeap, fixed. Thank you so much.
     
Loading...