How to make a connection from 2000 to 2005?

We are using SQL Server Enterprise Manager to connect to all of our SQL 2000
servers - one server, one box. Now we have a new box running SQL Server
2005. Is there anyway we can make a connection from a SQL Server 2000 box to
SQL Server 2005 box? We need a way to 'see' the new server from the 2000
box. SQL Server 2000 box is running .NET Framework 1.1 and SQL Server 2005
box is running .NET Framework 2.0.
Thanks in advance.
-tcInstall the SQL Server 2005 Client Tools on the SQL Server 2000 server. This
will give you the SQL Server Management Studio, which can be used to connect
to SQL Server 2005.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"tcw" <tcwangs@.msn.com> wrote in message
news:%23w5rLqXtGHA.1216@.TK2MSFTNGP03.phx.gbl...
We are using SQL Server Enterprise Manager to connect to all of our SQL 2000
servers - one server, one box. Now we have a new box running SQL Server
2005. Is there anyway we can make a connection from a SQL Server 2000 box to
SQL Server 2005 box? We need a way to 'see' the new server from the 2000
box. SQL Server 2000 box is running .NET Framework 1.1 and SQL Server 2005
box is running .NET Framework 2.0.
Thanks in advance.
-tc|||You should be able to create a linked server between the boxes. You could
probably use openquery/openrowset to "see" the SQL 2005 box from the SQL
Server 2000 box.
As you have probably discovered, Enterprise Manager does not connect to SQL
Server 2005 boxes. You will need to use Query Analyzer or SQL Server
Management Studio (which is the client tools for SQL Server 2005). SSMS can
connect to a SQL Server 2000 install.
--
Keith Kratochvil
"tcw" <tcwangs@.msn.com> wrote in message
news:%23w5rLqXtGHA.1216@.TK2MSFTNGP03.phx.gbl...
> We are using SQL Server Enterprise Manager to connect to all of our SQL
> 2000 servers - one server, one box. Now we have a new box running SQL
> Server 2005. Is there anyway we can make a connection from a SQL Server
> 2000 box to SQL Server 2005 box? We need a way to 'see' the new server
> from the 2000 box. SQL Server 2000 box is running .NET Framework 1.1 and
> SQL Server 2005 box is running .NET Framework 2.0.
> Thanks in advance.
> -tc
>|||I installed SQL Server Management Studio and it works fine. Thanks a lot.
-tc
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OQsFGHYtGHA.2020@.TK2MSFTNGP03.phx.gbl...
> You should be able to create a linked server between the boxes. You could
> probably use openquery/openrowset to "see" the SQL 2005 box from the SQL
> Server 2000 box.
> As you have probably discovered, Enterprise Manager does not connect to
> SQL Server 2005 boxes. You will need to use Query Analyzer or SQL Server
> Management Studio (which is the client tools for SQL Server 2005). SSMS
> can connect to a SQL Server 2000 install.
> --
> Keith Kratochvil
>
> "tcw" <tcwangs@.msn.com> wrote in message
> news:%23w5rLqXtGHA.1216@.TK2MSFTNGP03.phx.gbl...
>> We are using SQL Server Enterprise Manager to connect to all of our SQL
>> 2000 servers - one server, one box. Now we have a new box running SQL
>> Server 2005. Is there anyway we can make a connection from a SQL Server
>> 2000 box to SQL Server 2005 box? We need a way to 'see' the new server
>> from the 2000 box. SQL Server 2000 box is running .NET Framework 1.1 and
>> SQL Server 2005 box is running .NET Framework 2.0.
>> Thanks in advance.
>> -tc
>sql