SQLserver2005 and SQLserver2000 on the same computer: cannot access SQLserver2000

I've installed SQLserver2005 and SQLserver2000 on the same machine.
SQLserver2005 has an instance named MyMachine and SQLserver2000
MyMachine\My2000. SQLserver2005 is accessible from any other pc on my
LAN but SQL2000 is only visible on my pc; the other pc on the LAN
cannot access SQLserver2000. I've configured both SQL20005 and SQL2000
on the 1433 port.

What can I do?

Tnx

PS: sorry for my bad english

acadam
Can you create a linked server from another PC to thisd instance?


"acadam" <acadam@gmail.com> wrote in message
news:1166024880.154646.45020@80g2000cwy.googlegroups.com...
> I've installed SQLserver2005 and SQLserver2000 on the same machine.
> SQLserver2005 has an instance named MyMachine and SQLserver2000
> MyMachine\My2000. SQLserver2005 is accessible from any other pc on my
> LAN but SQL2000 is only visible on my pc; the other pc on the LAN
> cannot access SQLserver2000. I've configured both SQL20005 and SQL2000
> on the 1433 port.
>
> What can I do?
>
> Tnx
>
> PS: sorry for my bad english
>

>  I've configured both SQL20005 and  SQL2000
> on the 1433 port.

You can't have two services using the same port number. Use 1433 for the def
ault instance and
something else for the named instance. Also make sure that the SQL Server Br
owser service is
started.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/


"acadam" <acadam@gmail.com> wrote in message
news:1166024880.154646.45020@80g2000cwy.googlegroups.com...
> I've installed SQLserver2005 and SQLserver2000 on the same machine.
> SQLserver2005 has an instance named MyMachine and SQLserver2000
> MyMachine\My2000. SQLserver2005 is accessible from any other pc on my
> LAN but SQL2000 is only visible on my pc; the other pc on the LAN
> cannot access SQLserver2000. I've configured both SQL20005 and SQL2000
> on the 1433 port.
>
> What can I do?
>
> Tnx
>
> PS: sorry for my bad english
>

Mmm. I've still the problem. I configured SQLserver2005 on 1500 port
and SQLserver2000 on 1433 port. SQLserver2005 is ok, it's visible by
all the other machines. SQLserver2000 is not visible yet. SQLserver
Browser service starts automatically but nothing.

What can I do?

Please advice.

Tnx very much.