SQL 6.5 Publisher/Distributor to SQL Server 7.0 Subscriber

Microsoft® SQL Server™ version 7.0 can act as a Subscriber to a SQL Server 6.5 Publisher. You must add the SQL Server 7.0 Server as a Subscriber at the SQL Server 6.5 publishing server.

This action will also add an entry in the console tree of SQL Server Enterprise Manager. This is for replication purposes only, and you cannot administer this server using SQL Server Enterprise Manager in SQL Server 6.5. If you click this server in the console tree, the following warning message will be returned (and can be ignored for replication purposes):

A connection cannot be established to <SERVER> - (SQL Server) You must upgrade your SQL enterprise Manager and SQL-DMO (SQLOLE) to version 7.0 (SQLDMO) to connect to this server

You cannot use the replication topology or pull subscription features of SQL Server Enterprise Manager in SQL Server 6.5 to manage the SQL Server 7.0 Subscriber.

If you did not upgrade the ODBC driver at the Distributor (thus using the SQL Server 6.5 ODBC driver), you may encounter a login failure when the Distribution Agent connects to the SQL Server 7.0 Subscriber. You should upgrade the ODBC driver to successfully start the SQL Server 7.0 Subscriber.

To publish from a Publisher running SQL Server 6.5 to a Subscriber running SQL Server 7.0, add the SQL Server Authentication login, repl_publisher, with a blank password at the SQL Server 7.0 Subscriber.