register sql2000 on SQL2005 manager

I have two servers 2003, one running sqlserver 2005 and the second sqlserver
2000.
I'd like to register the sql2000 on the sqlserver management studio provides
with sql2005.
when I trie to connect to server with sql2000 I get an time out error. I've
already activated all the protocol : tcp/ip, named pipe ...
The target is to restore sql2000 database on sqlserver 2005.
thanks for your help.Hi,
Welcome to MSDE Managed NewsGroup. This is Justin from Microsoft.
It is supported to manage SQL2000 in SQL 2005 Management Studio. However,
if you only need to restore SQL2000 database to SQL2005, I recommend you
backup the SQL2000 database in the SQL2000 Enterprise Manager and copy the
backup file tot he SQL 2005 machine and then restore the backup file to
SQL2005.
I do not see much benefit to manage SQL2000 in Management Studio in this
case.
If you really need to register SQL2000 in Management Studio, please verify
that you can connect to the SQL 2000 from the 2005 machine.
1. Ping the 2000 server from the 2005 box and see if it succeeds
2. Telnet to the particular port and see if it works:
Telnet ServerName 1433
NOTE: Please run the Server Network Utility from the 2000 box to
determine the port SQL Server is listening. It might not be 1433 if it is a
named instance.
3. Create a UDL file to connect to the 2000 and see if it works.
- You can create a .txt file on the desktop, change its extension to
UDL and double-click it to launch the Data Link dialog box
If the step 1 & 2 do not work, you need to contact your network team and
see if there is any problem in the Network.
If you have any question, please feel free to let me know.
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: register sql2000 on SQL2005 manager
| thread-index: AcYmlKMdyn41f0o1QSWXgimqxWzbcg==
| X-WBNR-Posting-Host: 82.228.221.13
| From: "examnotes" <pbenisty@.newsgroups.nospam>
| Subject: register sql2000 on SQL2005 manager
| Date: Tue, 31 Jan 2006 10:32:06 -0800
| Lines: 11
| Message-ID: <4F8CEDBF-7DBF-4699-BADF-8D20D12B3A15@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419556
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have two servers 2003, one running sqlserver 2005 and the second
sqlserver
| 2000.
| I'd like to register the sql2000 on the sqlserver management studio
provides
| with sql2005.
|
| when I trie to connect to server with sql2000 I get an time out error.
I've
| already activated all the protocol : tcp/ip, named pipe ...
|
| The target is to restore sql2000 database on sqlserver 2005.
|
| thanks for your help.
|