Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 disable sa remote login

Author  Topic 

jar21

51 Posts

Posted - 2010-10-05 : 12:24:43
I have a web application that allows remote users to login and view data, however I recently noticed on 3 separate occasions on the same day someone tried logging in as SA. is there a way to only allow local logins? would I have to disable remote access completely?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-05 : 12:28:36
A few things you can do:

- change the sa password
- remove sysadmin provelege from sa
- use login trigger to kill spid connecting as sa if host_name() <> server name
Go to Top of Page
   

- Advertisement -