Data Backup and Recovery Discussions

SnapCenter 4.0 - SQL Databases not showing up




I have just started evaluating SnapCenter and have already stumbled upon something I don't understand. However I think it's either a mis-use on my side or a "works as designed" that I don't understand rather than a bug.


So I have installed SnapCenter with a Dom Ad account for testing purposes, added a few hosts and an SQL Server. Setup was no problem, full- and log-backups are working fine. Now I went to take care of user management. What I did:


- Added an Active Directory Group to SnapCenterAdmin Role

- Users in Group can authenticate just fine but didn't see anyhting

- Of course, so under User Access - All I granted the permissions to every object for that group.


Now members of that group can see storage systems, hosts, policies and all that just fine.


However what does not show up are SQL databases (Resources - Databases). If I log in back as the DomAd I jused to set everything up, the databases are showing up just fine so I can do for example a restore.


However as one of the other AD users in the group, the databases do not show up. The instance appears and I can run a backup - but no restore, since for that I would require the database view.


What am I doing wrong?

Thanks guys 😉








Many changes have gone into RBAC feature over the releases in SnapCenter. Latest version available is 4.1.1


Can you please try adding the users which are the members of the AD group as SQL sysadmin users in your SQL host and then log in to SC and try discovery?


On Resources/Microsoft SQL Server/Database - if no, or not all databases are shown - use the "Refresh Resources" button.

After discovering, the databases are shown.


Dirk Giron.

NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner