473,320 Members | 1,900 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Question: Recording login access to SQL Database

BD
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

Dec 12 '05 #1
1 1595
BD
oops - found something:

Server Properties / Security / Audit Level.

I guess that will work!

Dec 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

43
by: nospam | last post by:
I got three (3) files (1) Untitled.aspx (2) Untitled.aspx.1.cs (3) Untitled.aspx.2.cs These three files must be used together to make file #1, Untitled.aspx, page work via J.I.T. when the...
3
by: Jussi Rasku | last post by:
Hello, I'm working on a small web-script that would allow me to remotely setup recordings to my tv-tuner (on my linux box). The idea is simple, but I'm unsure how to accomplish it. The idea:...
1
by: JB | last post by:
I have a table for recordings, a table for playlists, and a table for playlist details, that uses the primary key from the recordings and playists tables as its primary key. I would like to...
8
by: Chuck Insight | last post by:
Hi All, I have never tried to restrict what a person has access (Not Intended As A Joke) to. But my current class assignment requires that I present specialized switchboards to users based upon...
4
by: NWx | last post by:
Hi, I developed a small test app using ASP.NET. I left the vistual folder to be accessible only with windows integrated security. I try to access that app from another PC in my LAN. I don't have...
2
by: Bob | last post by:
I would like to use integrated security for DB connection for my ASP.NET applications. Since these apps have different databases (SQL Server), I want each app to be able to access its own...
4
by: haha | last post by:
I was thinking of making a music database i've created tables but I cannot make a good relationship out of those tables... here are the tables I created in access: CD(cdno,created on)...
7
by: Seymour | last post by:
I am trying to find a way to sign onto my Wall Street Journal account (http://online.wsj.com/public/us) and automatically download various financial pages on stocks and mutual funds that I am...
2
by: dylanhughes | last post by:
I'm looking for an example of a login system that has multiple fields (2 to be exact) + password. e.g username, company name and password, the user, company and password are checked against a mysql...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.