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.