Avatar of Ora_Techie

asked on 

How to restrict access to SQL Server from Enterprise Manager, SQL Server Management Express etc

I am using SQL Server 2000. I want to restrict users from logging on trough Enterprise Manager/SQL Server Management Express etc (thery should be able to logon through application only).

I tried scheduling job whic finds the desired sessions from sysprocesses and kills them. But the problem is as long as the user navigates between databases/tables egc, a new connection is automatically established so practically this restriction is of no use.

Can anyone suggest better method?

Note: We can not make changes in the application.
Microsoft SQL Server

Avatar of undefined
Last Comment
Raja Jegan R

8/22/2022 - Mon