Connectivity with SQL Server Express 2008 r2 and SQL Server 2000 on same machine
- by Jim R
At first glance this may same a duplicate of Installing both SQL Server 2000 and SQL Server 2008 on the same machine, but it is not.
I have SQL Server 2000 and SQL Server 2008 R2 installed on the same machine and working fine.
My problem lies with connecting to the 2008 R2 server from a remote machine. My connectivity needs to be TCP. The…