Obtain Client IP for Login Failures (SQL 2000)

From: "Desiree Harris" <desiree@xxxxxxxxxxx>
Date: Tue, 26 Aug 2008 16:18:41 -0400

Hi All,

I have been trying to find a way to obtain the IP address of a login failure
against our SQL 2000 servers, but I have been unsuccessful. SQL Profiler
gives the HostName, but not the IP address.

SQL 2000 reports only a login failure, but doesn't give a Client IP address.

Sample: Login failed for user 'dhFromRemoteServe'.

SQL 2005 reports the information we need.

Sample: Login failed for user 'sa'. [CLIENT: xxx.xxx.xxx.xxx]

Is there any way to obtain the client IP or am I dead in the water?

--
Regards,

Desirée

.

Prev by Date: Re: sp_revoke login is not working as expected.
Next by Date: How to verify whether a user has been added to a database role?
Previous by thread: SSL on SQL Server
Next by thread: How to verify whether a user has been added to a database role?
Index(es):
- Date
- Thread

Relevant Pages

Re: Realbasic 2008 and MS SQL
... client is "sold" to MS SQL for their own reasons. ... in my mind, valentina is the best so far, even local or network. ... Your local app can generate reports from local databases, ...
(comp.lang.basic.realbasic)
Re: SQL Server Express with Advanced Services -- ? on limitations
... receive a message from teh client pc app to report and print local data? ... does webserver app accessing local server data violates the spirit of the ... Looking through the brief on SQL Express/AS the following line is included ... Run SQL Server Reporting Services reports on local relational data. ...
(microsoft.public.sqlserver.msde)
Query Engine Error
... I'm new to embedding CR in .NET applications and am hoping someone can help ... to set this up as a web app, I can't (client demands). ... the SQL is OK since I ... The reports are currently embedded ...
(microsoft.public.vb.crystal)
Re: SQL Code that is submitted to server changes when run on different clients
... > client, but when it is run on a different client the SQL code ... > I have an access ADP that in one of the reports, ... > run using SQL Profiler, I can see that when I run it on my PC, ... Did you try to use "SELECT * FROM dbo.yourUDF" as Recordsource ...
(microsoft.public.access.adp.sqlserver)
any problem with 2003 mdb using sql 2005 tables linked ot another mdb?
... I've got a client who has several Access 2003 mdb's linked together. ... My plan is to keep the reports in Access, but replace the front end forms with ... C# and the Access tables with SQL 2005 tables. ...
(microsoft.public.access.externaldata)