Re: Someone downloads information from my SQL Server

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 16:53:45 +0200

Use the Profiler to trace what's going on. Use strong security settings to
prevent unauthorized access. SQL Server has quite advanced security, so
don't rely on firewalls only. 

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Kungsmann" <sql_mannen@hotmail.com> wrote in message
news:0ca801c36d6e$54911410$a401280a@phx.gbl...
> I have seen that a lot of information is being sent from
> my computer on some occations lately. To protect myself, I
> installed a fire wall (Zone Alarm). Could then see that
> SQL Server was the program someone connected to.
>
> I noticed the problem when connected via modem. It did not
> occur every time I connected. If I disconnected and
> connected with another supplier, it would continue. If I
> restarted the machine, it would end.
>
> When looking at the size of one of the databases, I saw
> that it was almost 5 Gig instead of 300MB. This was only a
> demo-database, so I deleted it. Even after this, the
> download continued.
>
> Is there anyone that knows what this could be about? How
> do I protect myself in the future from things like this?
> (Of course, I have blocked SQL Server through Zone Alarm,
> but I would feel more safe if I knew what has happened).
>
> Kungsmann

Relevant Pages

  • Someone downloads information from my SQL Server
    ... To protect myself, I ... installed a fire wall. ... SQL Server was the program someone connected to. ... (Of course, I have blocked SQL Server through Zone Alarm, ...
    (microsoft.public.sqlserver.security)
  • Re: XLANG schedules could not rehydrated
    ... The problem was in the security settings on the Windows 2003 SQL ... check Allow Remote Administration ... Check enable Transactions Internet Protocal Transactions ... Reboot both the SQL server and the BizTalk server. ...
    (microsoft.public.biztalk.general)
  • Login failed for user sa. Reason: Not associated with a trusted SQL Server Server Connection.
    ... I have set the security settings inside Enterprise Manager to allow logins ... for both SQL Server and Windows. ...
    (microsoft.public.sqlserver.connect)
  • Re: Security Hotfix 8.00.0655
    ... servpriv is used to tighten the security settings as part of the hotfix. ... It is not something that is actually used by SQL Server after the application of the files. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner Role (SQL Server 7.0 v/s SQL Server 2000)
    ... > db_owner Role in SQL Server 7.0 and SQL Server 2000. ... > allocations and other permissions. ... > there are some Security Settings which can control this behavior. ... > Shrenik. ...
    (microsoft.public.sqlserver.security)