asked on
Disable users from utilizing SSMS
Hi,
I have some users in my company that access our Production SQL instance via SSMS. I would like to know if there a way to block all domain users from using SQL Management Studio, except domain admin, as domain admin has 'sysadmin' rights.
We have software that utilizing Integrated Security. I would still like our users to be able to utilizing our software using the SQL Windows authenticate, but not able to logon via SSMS.
Thanks!!
I have some users in my company that access our Production SQL instance via SSMS. I would like to know if there a way to block all domain users from using SQL Management Studio, except domain admin, as domain admin has 'sysadmin' rights.
We have software that utilizing Integrated Security. I would still like our users to be able to utilizing our software using the SQL Windows authenticate, but not able to logon via SSMS.
Thanks!!
Microsoft SQL ServerMicrosoft SQL Server 2008Microsoft SQL Server 2005Active Directory
Last Comment
Pber
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I have recommended this question be closed as follows:
Split:
-- Muhammad Burhan (https:#a42052284)
-- chaau (https:#a42052281)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
Pber
Experts-Exchange Cleanup Volunteer
I have recommended this question be closed as follows:
Split:
-- Muhammad Burhan (https:#a42052284)
-- chaau (https:#a42052281)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
Pber
Experts-Exchange Cleanup Volunteer
If yes, you can deny those permissions and setup appropriate auditing. It is possible to configure such that users can only view the schema and select/add data.