I need to be able to log on to a test database from home, I created a VPN from home to the office but SQL wouldn't let me connect. I assumed it was an issue with the VPN so the next morning I took the laptop in and hard wired it to the network, desktop (domain) PC works fine but laptop (non domain) gives me this error :
Just to test I nicked a colleagues domain PC, all worked fine, nicked his non-domain laptop, same error...
I have a sneaky feeling its to do with authentication, maybe to do with pipes but I don't want to start playing and break anything... Any idea how I can get around this??
Oh SQL server is a domain member and its configureed to use SQL Authentication not windows authentication...