June 15, 2009 at 5:21 am
Under status tab of sql server login properties, there are two settings 'permission to connect to database engine' and 'login'. What is difference between using these both? I want to confirm that is it possible to restrict a user to not login through SSMS but only through application.
Regards
DBDigger Microsoft Data Platform Consultancy.
June 15, 2009 at 1:13 pm
In practical terms, they do the same thing: either allow a login to connect to the SQL Server instance or not allow it. They just do it in different ways.
Neither can be used to restrict the use of SSMS. You could consider application roles to restrict connection via an application only.
Greg
June 16, 2009 at 7:18 am
HI friend,
During creation of logins , you can set option of status associated with its properties.
with regards
Vinay Goley
June 17, 2009 at 2:48 am
A server may contain different sql server services like 'SSAS','SSRS' etc.other than the database engine.
If Permission to connect to database engine checked deny then user cannot connect to database engine only but can access 'SSAS','SSRS'
if Login is enabled.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply