Hi,
When the SQL Compare tool attempts to accesss the remote server during a schema compare, I get the following error:
The tools says:
"Registering xxx.xxx.xxx.xxx.DBName" at the top
"Reading tables"
Then it hangs and then gives me an error:
"General network error. Check your network documentation."
I am running the latest version (3.41) of the red gate software. I am connected to a local server and have established a VPN connetion to a remote server. I am using the SA login to connect to both servers. When I enter the L/P for hte remote server, I can see the list of databases that exist on that server and have selected the one I want to compare to my local database.
Does anyone have any ideas as to what might be causing this? I can telnet to port 1433 and because I am getting the list of databases from the remote server, so I suspect that I can receive UDP traffic on 1434 too. The network admin who set this VPN connection up for me says that nothing should be blocked over this connection.
Also, I am specifing the IP address of the remote server, rather than a server name (it could not find it by name, I think DNS isn't set up to handle name resolution correctly).
Just for fun I ran the DTS compare utility between the two servers and it was able to compare them fine, which leads me to belive this is a problem with the software, rather than a network configuration problem.
Thanks,
Tom
Hi Tom
When the SQL Compare tool attempts to accesss the remote server during a schema compare, I get the following error:
The tools says:
"Registering xxx.xxx.xxx.xxx.DBName" at the top
"Reading tables"
Then it hangs and then gives me an error:
"General network error. Check your network documentation."
I am running the latest version (3.41) of the red gate software. I am connected to a local server and have established a VPN connetion to a remote server. I am using the SA login to connect to both servers. When I enter the L/P for hte remote server, I can see the list of databases that exist on that server and have selected the one I want to compare to my local database.
Does anyone have any ideas as to what might be causing this? I can telnet to port 1433 and because I am getting the list of databases from the remote server, so I suspect that I can receive UDP traffic on 1434 too. The network admin who set this VPN connection up for me says that nothing should be blocked over this connection.
Also, I am specifing the IP address of the remote server, rather than a server name (it could not find it by name, I think DNS isn't set up to handle name resolution correctly).
Just for fun I ran the DTS compare utility between the two servers and it was able to compare them fine, which leads me to belive this is a problem with the software, rather than a network configuration problem.
Thanks,
Tom