Denying MSAccess connections to SQLServer

• matzcarlos

  SSC Rookie

  Points: 31

  More actions

  January 15, 2008 at 6:31 am

  #121775

  Hi,

  Anyone knows if there is a way to deny MSAccess (Or other App) connections to SQL Server.

  Basically I have a lot of users running queries from Access to my Server. The idea is to block connections based on the program name

  Thanks

• Piotr.Rodak

  SSCrazy Eights

  Points: 9376

  More actions

  January 15, 2008 at 6:58 am

  #768099

  Perhaps you could consider logon triggers?

  ...and your only reply is slàinte mhath