Using Windows authentication, is there a way to prohibit users from connecting via ODBC to the database?
SQL Server Trusted Connection – Additional Security Measures
connectivitySecuritysql serversql-server-2017
Related Question
- Sql-server – Integrated Security Success on Master, Fails on Other Database
- Sql-server – If the users need INSERT/UPDATE/DELETE permissions, is Windows auth still more secure than SQL Server auth
- Sql-server – Is it possible to convert existing users from SQL Server authentication to Windows (AD) authentication? (SQL Server 2008 R2)
- SQL Server Management Studio – Slow Connection or Timeout with Windows Authentication
- Sql-server – Connecting to server which located remotely throws timeout exception
- Sql-server – Deny INSERT/UPDATE/DELETE to a particular schema
- Sql-server – SQL Server Connection Problem
Best Answer
The feature designed to help in this scenario is Application Roles. With an Application Role you can allow the user to connect to the target database, but not be able to run any queries until the application supplies a secret to activate the Application Role.