Posted by BD on 06/22/95 11:34

Hi, all:

I have been tasked with determining how many licenses of a certain SQL
Server 2000-based application are actually in use: in other words,
record or log connections made to the database by clients.

Client connections will be made with a generic SQL Server ID which has
been granted access to the DB; security is maintained inside the
application, and a user only logs in with their personal ID in the
application itself.

I know I can go in at any time into the management/Current
Activity/Process info and see current sessions against the target db,
grab the host name from that view, and do an "nbtstat -a" to glean the
login ID of the connected user.

If there were a way to record connections made to a DB in the event
viewer or SQL log, I could hopefully get the information I need.

But I see no way to have the SQL Server log connection information like
this.

Does anyone know how I might collect this info?

Thanks!

Cheers,

BD

• Next in forum: Re: Database security (crosspost)
• Prev in forum: Re: Text datatype as local variables in Trigger
• Thread view: Question: Recording login access to SQL Database

[Reply to this message]