Change IP address of a local (home) pc

This example is using Wanadoo Inventel Wireless Magic on Windows XP
The aim in this case is to change the IP address from using 192.168.1.x to using 192.168.0.x

Start > All Programs > Wanadoo > Configure the Live Box
Login > Configuration > Advanced > Network
Change LAN IP address, Broadcast LAN IP address, and 2 x DHCP addresses
Submit and wait for it to reset

My Network Places > View network connections > Right-click on Wireless Network Connection > Disable > Enable
This will force it to look for new IP address. Success

See Connection to SQL Server over VPN