Try to find out which host is connecting to the database (SQL7)

Question

Try to find out which host is connecting to the database (SQL7)

Ying Li

Newbie

Points: 3
More actions
April 12, 2005 at 2:25 pm

#102479

on SQL 7 database server, is there a way that I can track back to the host (mostly web servers) and find out which host is connecting to a particualar database?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 1

Unfortunately, unless you are passing in the Environ$("COMPUTERNAME") in as a parameter and logging it to an audit table sp_who2 will only show the web server due to connection sharing....

Good Hunting!

AJ Ahrens

webmaster@kritter.net

Ying Li Newbie Points: 3 More actions · Answer 2

Thanks for reply my question so quick! I am using SQL EM and checking current activity, some with their hostname listed but some don't! I am wandering how I can configure that to make them all show the hostname?

john-132685 SSCertifiable Points: 6134 More actions · Answer 3

He meant that the client application has to be coded in such a way as to provide it (hostname) when logging in. If the client app doesn't provide it, you don't get it. The standard apps SQL QA, EM, etc. are coded to provide it.

Ying Li Newbie Points: 3 More actions · Answer 4

Ying Li

Newbie

Points: 3

April 12, 2005 at 3:12 pm

#552254

Thanks!

Stewart Joslyn SSCertifiable Points: 6131 More actions · Answer 5

My VB6 application connecting through ADO puts 'Visual Basic' in the Program Name column. Can anyone suggest as to how to make this more informative?

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 6

In your connection string, add "Application Name=app_name;"

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Stewart Joslyn SSCertifiable Points: 6131 More actions · Answer 7

Stewart Joslyn

SSCertifiable

Points: 6131

April 13, 2005 at 4:15 am

#552344

Easy when you know how! Many thanks.

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 8

http://www.connectionstrings.com/ is a great resource.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 9

You can't. One of the flaws with the hostname in SQL Server 7 and 2000 with the sysprocesses table and the stored procedures that derive from it (sp_who and sp_who2) is that SQL Server trusts the client when it tells SQL Server what its hostname is. Meaning if it doesn't pass the hostname you get nothing and worse, if it decides to pass a spoofed hostname, you get the spoofed name, which doesn't do you any good. Short of dropping down to the network layer, this is as good as it gets with SQL Server right now.

K. Brian Kelley
@kbriankelley