Multipile Instance in MSDE

I have installed 2 MSDE 2000 engines in to the PC. one is no instance name, another one's instance name is 'TEST'.

I could use a GUI MSSQL manager to connect both with local machine.

But when I tried to connect both with other machine, I found that I only could connect either one which is start in service earlier.

My case is normal?

Are they conflict by the same network port? If yes, could I change the portnumber of the MSDE??

Thanks for your support!!Hi Walama,

I haven't used MSDE a whole lot, but it does sound like changing the port number might be the trick.

The SVRNETCN.EXE program can do that for you. SVRNETCN.EXE configures the remote protocol for your MSDE instances - but maybe you already know that because it sounds like you got at least one instance hooked up.

You can select which instance to configure, what protocol and the "Properties..." button for TCP/IP has a place to set a port number.

The program is located in your "C:\Program Files\Microsoft SQL Server\80\Tools\Bin" folder.

I posted some screen-shots of how to connect to MSDE from Enterprise Manager recently - although I haven't done the write up yet.

http://kb.xmlx.ca/article.aspx?id=10065

Hope this helps...|||Hi Scott,

Thx for you suggestion. I am changing the port number now, but I want to know that if I use the 3rd party tool to manage the database. So do you know how do I enter the portnumber for those tools??