Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restrict user to connect database through SSMS. Expand / Collapse
Author
Message
Posted Sunday, December 29, 2013 10:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:12 AM
Points: 27, Visits: 282
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.
Post #1526387
Posted Thursday, January 2, 2014 6:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 9, 2014 11:34 AM
Points: 128, Visits: 489
Here's a post that may be of some use:

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

Mark



Post #1527080
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse