December 10, 2008 at 8:22 pm
Hi,
I'm running traces looking for clients connecting to the database using Microsoft access.
All users use the same read only account to access the server so we rele on the Host name to tell us who's who.
I have one host name which does not exist in the domain and I can't find it. Can't ping it and don't know how to find it. It doesn't even have a computer account. The computer account was deleted.
Can anyone think of a way of tracking this machine down...?
December 10, 2008 at 9:13 pm
IP?
December 11, 2008 at 10:56 am
I have no idea if this is related, but here's something I ran into today.
We've got Access databases linking in sqlserver tables thru odbc. The hostname we see reported in sqlserver activity monitor is the hostname of the machine that linked the table in originally, not the machine that has the Access database open and running.
If you have the same thing, maybe that missing computer is one that orginally was used to link in the tables used in the Access database???
December 11, 2008 at 12:09 pm
Like APP_NAME, HOST_NAME is not determined or detected by the Server, it is set and provided by the client software, which can set it to anything. The server just reports what the client sets.
If the HOST_NAME is not what you expect, its a problem with the client not the server.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 11, 2008 at 12:53 pm
Thanks guys!
to answer the quesiton, the IP doesn't resolve at all.
the linked table thing fits the problem perfectly!
thankyou
Gareth
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply