Link to home
Start Free TrialLog in
Avatar of Hani M .S. Al-habshi
Hani M .S. Al-habshiFlag for Yemen

asked on

How to enable\Disable domain users Application in PC's to connect SQL Server 2008 r2

I have some PCs have APP connect to SQl server
How to enable\Disable this APP to connect  SQL Server 2008 r2 for some "Domain users's"
Avatar of als315
als315
Flag of Russian Federation image

Go to SQL Management Studio and assign proper rights for your database. Usually we use groups in active Directory. You can assign users to group with rights to access SQL data and they will have access. Other ones will have no access
if your users have sql login
you can do this by using this command

ALTER LOGIN youruserlogin DISABLE
ALTER LOGIN youruserlogin ENABLE

more
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-login-transact-sql
Avatar of Hani M .S. Al-habshi

ASKER

1-Application connect to SQL server ?
2-this Application installed on uses PC's ?
how i prevent this application to connect to SQl server from any user PC ?
How this application connects to SQL server? With stored account?
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial