PRB: SQL 7.0 Upgrade Fails w/ 'Could not find stored procedure' Msg

• Microsoft SQL Server version 7.0

SYMPTOMS

The upgrade from SQL Server 6.5 to 7.0 fails while importing the replication setting with the following error reported in the Import Replication Settings.err file:

Microsoft SQL-DMO (ODBC SQLState: 42000) returned error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure ''.

CAUSE

This error is caused by improper distributor settings in SQL Server 6.5 for a publisher.

In SQL Server 6.5, each publisher server must have a distribution server defined in sysservers. This setting is imported into SQL Server 7.0 to determine which distribution database to use on SQL Server 7.0. If the distributor is not defined properly on SQL Server 6.5, the distribution server value becomes NULL.

With default ANSI settings for SQL Server 7.0, the stored procedure name concatenated to a NULL distribution server name yields NULL and the error occurs.

WORKAROUND

Determine the distribution server in SQL Server 6.5 by running sp_helpdistributor. If this does not return the proper value, fix the distribution server setting using the SQL Enterprise Manager by selecting Server, Replication Configuration, Publishing.

Additional query words: distribution server

Keywords : kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbprb