| Author |
SQLserver2005 and SQLserver2000 on the same computer: cannot access SQLserver2000
|
|
| acadam 2006-12-13, 7:12 pm |
| 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
| |
| Uri Dimant 2006-12-13, 7:12 pm |
| 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
>
| |
| Tibor Karaszi 2006-12-13, 7:12 pm |
| > 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 default instance and
something else for the named instance. Also make sure that the SQL Server Browser 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
>
| |
| acadam 2006-12-14, 5:25 am |
| 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.
|
|
|
|