Doing Compare on database instance

Simon

I have installed SQL Server 2005 onto the same sever as I already have SQL Server 2000. I have installed the SQL Server 2005 as a named instance.

SQL Compare doesn't seem to be able to see the named instance.

The server name is IDMS-SQL, the instance name is idmssql01

I entered the server name as idms-sql\idmssql01 and version 5 cannot find it, version 3.1.7 which is my current licensed version can find it.

Any help appreciated.

P.S. I am in the process of upgrading to Version 5.

Brian Donahue

Hi,

It's sort of odd that v3 would work and v5 would not, as v5's detection and connection code is vastly improved.

I'd suggest trying the usual things first, though, to rule them out. Typically SQL Compare works best with SQL Server 2005 when it has the SQL Server discovery service running and the network configuration allows remote connections using TCP/IP. You can set these options in the SQL Server 2005 configuration manager.

In one case, moving the TCP/IP protocol as high up the list of protocols as it will go fixed the connection issue.

Hopefully these suggestions will get it working.

Simon

Thanks, I just needed to add the TCPIP protocol, then restart the service.