25112
asked on
2 IP addresses
when ip config is run, i see 2 IPs.. which is the right one for the machine...
Windows IP Configuration
Ethernet adapter Broadcom NetXtreme Gigabit Ethernet Adapter - Onboard - Link A:
Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 201.xxx.xxx.44
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 201.xxx.xxx.1
Ethernet adapter Broadcom NetXtreme Gigabit Ethernet Adapter - Onboard - Link B:
Media State . . . . . . . . . . . : Media disconnected
Ethernet adapter Broadcom NetXtreme Gigabit Ethernet Adapter - PCI Slot 3:
Media State . . . . . . . . . . . : Media disconnected
PPP adapter {0D22E43D-107F-47AD-9866-76BG95BA27H4}:
Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 192.168.xxx.xxx
Subnet Mask . . . . . . . . . . . : 255.255.255.255
Default Gateway . . . . . . . . . :
ASKER CERTIFIED 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.
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?
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-45-59-AM.png
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
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
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
... 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
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..
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?
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
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
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?
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?
Thanks. Disabled or inactive adapters will show up. I don't know why the SQL interaction, but otherwise it is normal. Thanks again. .... Thinkpads_User
ASKER
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?