Hi all i have a query regarding login authentication.
Is there any way to prevent sa user from remote login other than WINDOW AUTHENTICATION AND ACTIVE DIRECTORY AUTHENTICATIONS?
How can we prevent sa user from remote login using SSMS?-- Krishnakant Joshi
asked Dec 20, 2011 at 03:51 AM in Default
I think you should specify the reason why you want this. Then we could lead you to a better path.
As far as how it could be done is, At the moment I can only think of a DDL LOGON TRIGGER as the solution
You could try something like this in the LOGON TRIGGER
Hope it will help your cause, but please do let us know why you want it.
Your best solution to prevent remote login by the 'sa' account is to change the password and stop letting people use it. Security wise, this account should not be used for day-to-day activity.
If access is required by a user or application, a dedicated account should be created so you know who is doing what in your system.
answered Dec 20, 2011 at 08:43 AM