General Network Error with SQL Data Compare v3.4.0.8
Francis
Posts: 3
We successfully used SQL Data Compare in demo mode between a local XP Pro desktop, a local windows 2003 server with db, and a remote windows 2000 server with db across the WAN in our domain.
The licensed version on a local windows 2003 server with db and the same remote windows 2000 server gives us the error "General Network Error. Check your network documentation".
We tried "tcp:myhost,1433" for the remote system but the same error occurred.
We tried the SQL Server Client Network Utility and created an alias for the remote server that will force it to use the IP network library which returned a different error message, “SQL Server does not exist or access deniedâ€.
Is there a problem running SQL Data Compare on a windows 2003 server? Any help will be appreciated.
The licensed version on a local windows 2003 server with db and the same remote windows 2000 server gives us the error "General Network Error. Check your network documentation".
We tried "tcp:myhost,1433" for the remote system but the same error occurred.
We tried the SQL Server Client Network Utility and created an alias for the remote server that will force it to use the IP network library which returned a different error message, “SQL Server does not exist or access deniedâ€.
Is there a problem running SQL Data Compare on a windows 2003 server? Any help will be appreciated.
This discussion has been closed.
Comments
We had this problem once before and tried may different t things to try and fix it - connection settings, patches, etc.
However in the end it turned out to be an intermittent fault on the network. it was never tracked down but I feel it was probable a full duplex / half duplex mismatch between a switch and nic.
If the problem doesn't just go away please have a look at your hardware setup.
If you are still drawing a blank get in touch with us at support@red-gate.com
Regards
Dan
Red Gate Software Ltd