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"
Hani AlhabshiSystems EngineerAsked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
you can set your sql server firewall to restrict  to just approved Servers\PC access

more
Configure the Windows Firewall to Allow SQL Server Access
https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access
0
 
als315Commented:
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
0
 
Eugene ZCommented:
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
0
 
Hani AlhabshiSystems EngineerAuthor Commented:
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 ?
0
 
als315Commented:
How this application connects to SQL server? With stored account?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.