Profiler and user password

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ET - 24 Apr 2005 20:13 GMT

Is it possible for profiler to show which password is used when a user logs
to a sql server and the users ip ?? If so how.

Reply to this Message

Jens Süßmeyer - 24 Apr 2005 20:22 GMT

Is it possible for profiler to show which password is used when a user logs

> to a sql server

Hehe, no that would be a security leak ;-) there has been an issue on some
providers in 7.0 but its fixed now in those which i know.

> a sql server and the users ip

No, as far as i know there is only the way to get the Hostname, once i wrote
a Function to get the IPAdress, but it was only used in TSQL rather than
profiler.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

> Is it possible for profiler to show which password is used when a user
> logs
> to a sql server and the users ip ?? If so how.

Reply to this Message

Mike Epprecht (SQL MVP) - 25 Apr 2005 12:44 GMT

Hi

And the host name is the value supplied by the client. If the host name is
hard coded in the connection string, it may not be the real name of the host
that is making the connection.

Regards
Mike

> Is it possible for profiler to show which password is used when a user logs
> > to a sql server
[quoted text clipped - 17 lines]
> > logs
> > to a sql server and the users ip ?? If so how.

Reply to this Message