I would like to allow only administrators to access to SQL Server Management Studio using "Windows autentication". How can I avoid simple users to access with Windows autentication? Or in alternative avoid users to open SSMS?
-
2Setup permissions accordingly but honestly it would be better to just setup the correct database permissions.– SethCommented Feb 8, 2019 at 9:42
-
You can revoke read/execute filesystem rights for SSMS executable (or the whole folder) for Windows users who are not Administrators group members. No access - cannot start.– AkinaCommented Feb 8, 2019 at 9:50
Add a comment
|