MSSQL Database manager

[emsol]

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.

 

[visupport]

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?

 

[emsol]

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