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
Raja Jegan R
8/22/2022 - Mon
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat