Net address 000000000000

Does anyone know why in Activity monitor some processes will show the net
address as '000000000000' ? and does it indicate a problem that should be
resolved?
I see this in SQL Server 2000 and 2005 . These are TCP connections.
Thank you
Ellen
Thank you for sharing your knowledge
I've seen this behaviour when someone has been connected to SQL Server using
mobile device.
Regards
Pawel Potasinski
[http://www.potasinski.pl]
Uytkownik "Ellen" <DBAEllen@.community.nospam> napisa w wiadomoci
news:2513224B-1046-46A8-98C1-1D2B9377F0F4@.microsoft.com...
> Does anyone know why in Activity monitor some processes will show the net
> address as '000000000000' ? and does it indicate a problem that should be
> resolved?
> I see this in SQL Server 2000 and 2005 . These are TCP connections.
> Thank you
> Ellen
> --
> Thank you for sharing your knowledge
|||Hi Ellen,
Welcome to MSDN Managed Newsgroup.
From your description, I understand that you found that some processes
showed the Network Address as '000000000000' in Activity Monitor in both of
your SQL Server 2000 and SQL Server 2005. You would like to know if this is
an issue that should be resolved.
If I have misunderstood, please let me know.
I did not find any known issue regarding this for SQL Server. From my
research, the network address '000000000000' seems to indicate that a
computer's network address has not been assigned by DHCP Server. I
recommend that you run ipconfig.exe from the client computers to see if
they have an IP address assigned from your DHCP server.
For further research, could you please let us know more detailed of your
network environment? In my environment, all my machines are in a same
domain and dynamically get network addresses from a DHCP server in the
domain. I tried connecting to my local SQL Server instance from another
machine and I found that the Net Address/Network Address correctly matched
to the computer's network address.
Also, I would like to check with you whether or not you encountered
connection issues for those computers with network address '000000000000'.
There is also a monitor tool named Network Monitor on Windows. You can also
use it to monitor your server and check the trace file to see if the
clients' network addresses are '000000000000'. You can download the latest
version from this link:
Microsoft Network Monitor 3.1
http://www.microsoft.com/downloads/details.aspx?familyid=18b1d59d-f4d8-4213-
8d17-2f6dde7d7aac&displaylang=en
For the usage of Network Monitor, please refer to:
How to capture network traffic with Network Monitor
http://support.microsoft.com/kb/148942/en-us
Appreciate your coming back and confirming these questions with me. If you
would like, you may also mail me (changliw_at_microsoft_dot_com) the Netmon
trace file and your SQL Activity trace logs for further research.
If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Charles:
Thank you for your input & questions.
Our machines are all in the same domain.
I will check the machines as suggested. If the DHCP servier is not
assigning a network address we will research the ramifications.
I am looking into this to see if this is a connection issue. The people
using the machines that create these sessions are constantly complaining of a
slow or non-responsive system. I am trying to figure out what is going on.
I will try the Netmon tool -- hopefully it will not put too much of an
additional performance hit on this already slow system!
Again, thank you.
I will let you know the results.
~Ellen
Thank you for sharing your knowledge
"Charles Wang[MSFT]" wrote:

> Hi Ellen,
> Welcome to MSDN Managed Newsgroup.
> From your description, I understand that you found that some processes
> showed the Network Address as '000000000000' in Activity Monitor in both of
> your SQL Server 2000 and SQL Server 2005. You would like to know if this is
> an issue that should be resolved.
> If I have misunderstood, please let me know.
> I did not find any known issue regarding this for SQL Server. From my
> research, the network address '000000000000' seems to indicate that a
> computer's network address has not been assigned by DHCP Server. I
> recommend that you run ipconfig.exe from the client computers to see if
> they have an IP address assigned from your DHCP server.
> For further research, could you please let us know more detailed of your
> network environment? In my environment, all my machines are in a same
> domain and dynamically get network addresses from a DHCP server in the
> domain. I tried connecting to my local SQL Server instance from another
> machine and I found that the Net Address/Network Address correctly matched
> to the computer's network address.
> Also, I would like to check with you whether or not you encountered
> connection issues for those computers with network address '000000000000'.
> There is also a monitor tool named Network Monitor on Windows. You can also
> use it to monitor your server and check the trace file to see if the
> clients' network addresses are '000000000000'. You can download the latest
> version from this link:
> Microsoft Network Monitor 3.1
> http://www.microsoft.com/downloads/details.aspx?familyid=18b1d59d-f4d8-4213-
> 8d17-2f6dde7d7aac&displaylang=en
> For the usage of Network Monitor, please refer to:
> How to capture network traffic with Network Monitor
> http://support.microsoft.com/kb/148942/en-us
> Appreciate your coming back and confirming these questions with me. If you
> would like, you may also mail me (changliw_at_microsoft_dot_com) the Netmon
> trace file and your SQL Activity trace logs for further research.
> If you have any other questions or concerns, please feel free to let me
> know. It is my pleasure to be of assistance.
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>