We have applications connected to SQL using windows authentication. While having connection with Application user can also access to Database instance on the same time as well. We need to limit the access of user outside application. How we can limit user to access DB from application but not outside application? In other word: I have develop and application with is connecting to SQL DB using windows Authentication and its working perfectly fine. What i want is to limit the access of the User to SQL management studio and may be some other application to access my Database. May be they can connect to SQL but cannot access (Read/Write) to my Database.