Restrict user to connect database through SSMS.

• Alone

  Right there with Babe

  Points: 783

  More actions

  December 29, 2013 at 10:53 pm

  #396038

  Hi ,

  I have created one SQL logins .This login should be able to access database through third party application but not through SSMS.

  How is it possible? Please suggest.

• Mark Eckeard

  Hall of Fame

  Points: 3462

  More actions

  January 2, 2014 at 6:24 am

  #1676871

  Here's a post that may be of some use:

  http://www.sqlservercentral.com/Forums/Topic1236514-391-1.aspx#bm1236743

  Mark