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

MSSQL Database manager

Discussion in 'Plesk for Windows - 8.x and Older' started by emsol, Oct 11, 2004.

  1. emsol

    emsol Guest

    Scenario - standard Plesk installation

    MSDE installed and configured by plesk install - not seperate MSSQL installation.

    Currently, we have these problems...

    When user tries to open the database manager they receive errors related to access for unrelated databases.

    If they try again a few times sometimes they can get access to their database.

    When they do have access, they are unable to modify any tables

    They are unable to delete the database or the database user from within plesk.

    I'd like to know how many other people are experiencing these problems.
  2. visupport

    visupport Guest

    It is possible to toggle off db_owner role for database user in mssql web interface. May be this user accidently toggled this off and is now longer db_owner?
  3. emsol

    emsol Guest

    It could be that the db owner role is not added at all. I will check this. Thaks for the suggestion.