|
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
(comments are locked)
|
|
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 OR Hope it will help your cause, but please do let us know why you want it. +1 here's more on logon triggers
Dec 20 '11 at 10:25 AM
Scot Hauder
Hi Usman, Thanks for the reply. You have solved my query. There is no specific reason behind this question. One day i was just reading an article about authentication in SQL server which raised this question. :) Thanks Again
Dec 27 '11 at 11:26 PM
krishnakantj
(comments are locked)
|
|
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.
(comments are locked)
|

