I took out a windows
VPS Hosting that was handed to me about 2:30pm today but is still not in a working state.
MSSQL2005 wasn't installed, that was rectified relatively quickly.
I then found a problem in that I couldn't connect via FTP. When I logged in, I was authenticated but got an error saying home dir not accessible.
Logged a support case (#OVW-69547-341) and the reply came back that this was a router issue with the IP of my
VPS Hosting and they had changed the IP address of my
VPS Hosting 
. So my nameservers and any domains I had transferred(luckily no live ones yet) all of sudden would have gone offline.
In addition, all of the DNS records on the
VPS Hosting were left with the old IP addresses so i'll have to go and amend all of those myself.
The thing I really don't understand about this IP thing is that the addresses allocated to me were xxx.xxx.xxx.196 & 197 and the new ones are xxx.xxx.xxx.214 & 215 - in the same Class C subnet . So as the addresses are in the same class C subnet, why is changing the address of the server going to fix this - surely it just needs a tweak of the routing tables.