Is there a way to block connections to SQL from "non-approved" applications? Or is there a way to set what applications to except?
I have looked at ApplicationRole and sp_setapprole, but they may not be the best way. If I read it right I would have to add that to all processes??????
So any suggestions on where to look? Is ApplicationRole what I need?