Re: log connection to named pipe



kenko
If you are in SQL Server 2005 (SP2) take a look into LOGON triggers(or
Profiler) to capture the info, however it could be that somebody tries to
attack you



"kenko" <kenko@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F5B2F85E-9E99-4E1E-B91F-C7E3D838F785@xxxxxxxxxxxxxxxx
Hi,

My problem,

We have a few SQL databases on SLQ2005 and MSDE on the same machine with
SBS
server 2003.
Every week i have some logs who tell that a compleet unknown user 'Login
failed for user 'XXX'. [CLIENT: XXX]. The name of the user is always the
same
but the client machine is always a different PC in the lan.
Their is an application that uses the SQL2005 and wich is installed on all
pc's in the lan. But their is no user like the 'XXX' in the log file.
The external software company who wrote the application says that it is
inpossible that it is something in their application.
So how can I log are check the traffic to the SQL server to find what
(application) is trying to connect with the unknown user ?????

Thanks
Koen




.



Relevant Pages

  • Re: Installation OK, but cant connect
    ... > Does that mean that it has to be on my specific lan? ... on your lan the server name is YourComputerName, while on my lan the server ... instance of SQL Server we are using... ... SQL Server's login for each user to whom grant login privilege to SQL ...
    (microsoft.public.sqlserver.msde)
  • Re: The SA Mess
    ... At least if a script is trying to log in and returned user unknown then they ... That info has to come from SQL Server. ... > This problem is not restricted to access via the Internet - the problem ... since LAN speed is typically 100 Mbps and Internet ...
    (microsoft.public.sqlserver.security)
  • SQL Server Question
    ... be the approprate to post to. ... I an running a 2 PC lan. ... PC is my SQL server DB and hosts my website. ... the SQL server on my LAN through the dot net app? ...
    (microsoft.public.sqlserver.setup)
  • SQL Server Question
    ... be the approprate to post to. ... I an running a 2 PC lan. ... PC is my SQL server DB and hosts my website. ... the SQL server on my LAN through the dot net app? ...
    (microsoft.public.sqlserver.setup)
  • Re: Publish Sql on the internet
    ... What you need to do is NOT allow connections into your LAN. ... Create a DMZ ... Do not allow SQL Server to connect to anything else on your network. ...
    (microsoft.public.sqlserver.server)