Hani M .S. Al-habshi
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"
How to enable\Disable this APP to connect SQL Server 2008 r2 for some "Domain users's"
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
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
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 ?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.