I am having trouble executing queries on a new Windows 7 64-bit machine. The target database is accessed through a Cisco VPN tunnel. I have tried to use SSMS from the original install and from an Express installer. I also tried both 32 and 64 bit installs of SSMS. All result in the same errors.
My errors are very similar to the ones found in this posting. But I have issues while I am connected to the VPN connection. I am not sure how to troubleshoot this as the error changes. However, if I query to a local database, I don't get the same error all the time, but they seem to occur when the query is returning many rows. I do have success when the queries are simple and only affect very few rows.
My local database is running 10.0.1600 and the remote database is running 10.0.4000, and this is working with existing XP machines.