By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,669 Members | 1,634 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,669 IT Pros & Developers. It's quick & easy.

Question: Recording login access to SQL Database

P: n/a
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

Does anyone know how I might collect this info?




Dec 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
oops - found something:

Server Properties / Security / Audit Level.

I guess that will work!

Dec 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.