2 IP addresses

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

profgeek

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

OK.. this is a sql server.. so I do not believe there is a VPN assigned to this machine.. is it possible to check if VPN is involved here through some commands?

when i run ipconfig in another sql server, i do not get the 192.168, but only only one address 201.x.x.x.. is that because that server has only one adapter?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

>>>you can go to your network adapter settings and remove or disable the PPP adapter...

what is PPP and what is the consequence of removing it?

it is a vpn connection.. if you don't know why its there, remove it or disable it. if you disable it and someone says something is broken then you just enable it.

ASKER

please tell me a test i can do it and then take it as a proof and ask why vpn is here to the team..

you can disable the adapter or enable it with one click
15-10-2011-4-45-59-AM.png

15-10-2011-4-47-48-AM.png

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

profgeek

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thinkpads_User, here is it:

The main symptom is that the sql server IP address comes as the 192.168.x.x which won't be right: http://www.sqlmag.com/article/tsql3/dynamically-obtain-a-sql-server-s-ip-address-in-t-sql-code
net.bmp

So the PPP connection is available to use but disconnected. That seems normal for most setups. Is it causing a problem? or is it just there?

... Thinkpads_User

ASKER

this is the /all details:

Windows IP Configuration
   Node Type . . . . . . . . . . . . : Hybrid
   IP Routing Enabled. . . . . . . . : No
   WINS Proxy Enabled. . . . . . . . : No

Ethernet adapter Broadcom NetXtreme Gigabit Ethernet Adapter - Onboard - Link A:


   Connection-specific DNS Suffix  . :
   Description . . . . . . . . . . . : Broadcom NetXtreme Gigabit Ethernet #2
   Physical Address. . . . . . . . . : 00-0D-56-BA-BD-1A
   DHCP Enabled. . . . . . . . . . . : No
   IP Address. . . . . . . . . . . . : 2xx.x.x.x
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . : 2xx.x.x.x
   DNS Servers . . . . . . . . . . . : 1x.x.x.x
                                       164.x.x.x
   Primary WINS Server . . . . . . . : 1x.x.x.x
   Secondary WINS Server . . . . . . : 1x.x.x.x
                                       2xx.x.x.x

Ethernet adapter Broadcom NetXtreme Gigabit Ethernet Adapter - Onboard - Link B:


   Media State . . . . . . . . . . . : Media disconnected
   Description . . . . . . . . . . . : Broadcom NetXtreme Gigabit Ethernet #3
   Physical Address. . . . . . . . . : 00-0D-56-BA-BD-1B

Ethernet adapter Broadcom NetXtreme Gigabit Ethernet Adapter - PCI Slot 3:

   Media State . . . . . . . . . . . : Media disconnected
   Description . . . . . . . . . . . : Broadcom NetXtreme Gigabit Ethernet
   Physical Address. . . . . . . . . : 00-10-18-06-55-FB

PPP adapter {0D22E43D-107F-47AD-9866-76BG95BA27H4}:

   Connection-specific DNS Suffix  . :
   Description . . . . . . . . . . . : WAN (PPP/SLIP) Interface
   Physical Address. . . . . . . . . : 00-53-45-00-00-00
   DHCP Enabled. . . . . . . . . . . : No
   IP Address. . . . . . . . . . . . : 192.168.x.x
   Subnet Mask . . . . . . . . . . . : 255.255.255.255
   Default Gateway . . . . . . . . . :
   NetBIOS over Tcpip. . . . . . . . : Disabled

Open in new window

ASKER

>>Is it causing a problem? or is it just there?

the only problem is a wrong ip address is giving back when querying for the sql server's instance ip address..

is the ppp existing to provide vpn, if needed?
should it show up in ipconfig.. that is where the sql proc above is reading to get the instance ip address and getting it wrong..

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

>>There may be another setup problem as well in SQL.

do you mean the code in the link i sent?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

25112 - Could you please verify:

Are you getting an operational error with 2 adapter occurences?

Or, Are you just seeing 2, but no errors?

Thank you. ... Thinkpads_User

ASKER

Thinkpads_User, the sql query gives the 192.168.x.x as the IP address and not the 2xx.x.x.x.. that is the main reason i ask.. other similar servers give only the 2xx.x.x.x IP address back.. and what we saw in the ipconfig /all is the reason for that..

now how do I disable in win 2003?

a.bmp

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

thanks for trying...

so regardless of the sql, what have we diagnosed so far?
*that for some reason the PPP adapter even not active, is showing up.. but we don't know the reason, right?