Article ID: 1330, created on Oct 6, 2008, last review on Apr 30, 2014

  • Applies to:
  • Plesk 8.1 for Windows
  • Plesk 7.6 for Windows
  • Plesk 7.5 for Windows


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.


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.


Remove role db_denydatareader from the user.

c0c38d2367acfa8909699e0b34b01dea 7000fbc03a7e92b93bc676a7c04a4ce6 85a92ca67f2200d36506862eaa6ed6b8 a914db3fdc7a53ddcfd1b2db8f5a1b9c eeda7e5e81623f3acf0bdb69fa51d540 e115c1a9652baf38f4af4f18d5b7ac6e c45acecf540ecd42a4bbfb242ce02b1d 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF