Is it possible to deny access to SQL Server from specific programs?

Posted by Paul McLoughlin on Stack Overflow See other posts from Stack Overflow or by Paul McLoughlin
Published on 2010-05-19T15:43:35Z Indexed on 2010/05/19 15:50 UTC
Read the original article Hit count: 137

Filed under:
|

Currently one of our databases (SQL Server 2008) is accessed via a number of different mechanisms: .Net SqlClient Data Provider; SQL Server Management Studio; various .Net applications and 2007 Microsoft Office system (basically Excel).

I see that in the sys.dm_exec_sessions DMV it is possible to see the program name of the program accessing the database for the current sessions. My question is: is it possible for one to deny access from a particular named program? First prize would be if this could be done for any named program, but we would gain a great deal of benefit from being able to deny access to this specific database from all Microsoft Office applications (especially Excel).

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2008