sql server connect: Connect to 2K on machine with both 2K and 2K5 -- sql server connect

Connect to 2K on machine with both 2K and 2K5

Karl Perry
12/22/2006 10:00:33 AM

sql server connect: I have both SQL Server 2000 Developer Edition SP3 and SQL Server 2005
Developer Edition (9.00.2047.00) installed on my WinXP SP2 notebook.

I'm connecting from a Windows PocketPC 2003 Second Edition device which is
running a custom app which uses SQL Server CE 3.0.

The database I need to connect to from the PocketPC device is attached to my
SQL Server 2000 instance.

When my PocketPC application connects to the IP address of the notebook and
displays a list of attached DBs, it shows the DBs attached to the 2005
instance, not the 2000 instance. The application accessing the DBs is
currently looking at port 1433. The app was written by our developers so we
can change it to look at another port if necessary.

I can't figure out how to get the PocketPC device to look at SQL Server 2000
rather than 2005. Can anyone help?

If I need to repost this message on another NG, please let me know the one
most appropriate and I'll repost.

TIA,

Karl Perry

Re: Connect to 2K on machine with both 2K and 2K5

Helmut Woess
12/22/2006 8:08:53 PM

Am Fri, 22 Dec 2006 10:00:33 -0800 schrieb Karl Perry:

[quoted text, click to view]

I think, this two servers use different ports. And port 1433 is occupied by
SQL2005. Now you can check which port is used by SQL2000 and change your
program on the PocketPC. Or you reconfigure your SQL-Servers, that SQL2000
use port 1433 again and SQL2005 use another port. I have the same scenario
where MSDE without instance is using port 1433 and three instances are
running with SQLExpress, every instance has another port address. Works
perfect (port number can be used in the connection string).

bye,