Product:
Search Type:

[FIX] Tables are not displayed in MSSQL DB Webadmin.

Article ID: 1330 
Last Review: Jul,17 2007
APPLIES TO:
  • Plesk 7.5.x for Windows
  • Plesk 7.5.6 for Windows
  • Plesk 7.5.5 for Windows
  • Plesk 7.6.x for Windows
  • Plesk 7.6.1 for Windows
  • Plesk 8.1.0 for Windows
  • Plesk 8.1.1 for Windows
  • Plesk 8.1 for Windows
  • Plesk 8.1.1.2 for Windows
  • Plesk 8.2 for Windows

SYMPTOMS

When browsing MSSQL database as domain user using MSSQL DB Webadmin no tables are displayed. But they can be seen when logged in as sa.

CAUSE

Plesk uses DB user that is created in a database to establish connection to MSSQL using DB Webadmin. It’s the first user listed in users list for a database. Actually all users in this database should have db_owner role on the database. The most likely reason of the is that the user has db_denydatareader role enabled.

RESOLUTION

Remove role db_denydatareader from the user.

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields