How can we help you today? How can we help you today?

General Network Error with SQL Data Compare v3.4.0.8

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.
Francis
0

Comments

2 comments

Sort by
  • Francis
    The licensed version ran successfully on my XP Pro desktop against the local WS2003 and remote WS2000 systems.
    Francis
    0
  • Daniel Handley
    Hi Francis

    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
    Daniel Handley
    0

Add comment

Please sign in to leave a comment.