MSSQLCity.Com - All about MS SQL
     
About Us  
SSWUG Articles  
Articles  
FAQ  
Administration  
Backup/Restore  
Connectivity  
Development  
General  
Installation  
OLAP  
Replication  
Transfer/move  
Trouble  
SQL 6.5  
Scripts  
Tips  
Test Exams  
Advertise  
Download  
History  
Search  
Traffic  
Related Links  
     
Your button logo
Add to Favorites
 
     
 


Can I use the SQL Server 7.0 tools to connect to SQL Server 2000?

Answer:

Yes, you can use the SQL Query Analyzer, osql and isql SQL Server 7.0 tools to connect to SQL Server 2000.
To connect to a named instance of SQL Server 2000, you must set up an alias using the Client Network Utility.

This is from SQL Server 2000 Books Online:

When using the SQL Server client connectivity components from SQL Server 7.0
or earlier, you must set up an alias using the Client Network Utility before
you connect to a named instance of SQL Server 2000. For example, on a
SQL Server 7.0 client, to connect to a named instance of SQL Server 2000,
you must add an alias that points to
\\computername\pipe\MSSQL$instancename\sql\query. If you use an alias name
of computername\instancename, clients can connect by specifying this name
in the same way as SQL Server 2000 clients do. For the TCP/IP Sockets and
NWLink IPX/SPX Net-Libraries, you must use the Client Network Utility to
define an alias on the client that specifies the port address on which the
named instance is listening.

 

 
Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

(c) 1997, 2005 Bits on the Wire, Inc