[CR #623810] pdb_xlog init fails when a SQL Server instance is upgraded from Microsoft SQL Server 2005 standard version to the developer version. This is a limitation of Microsoft SQL Server—during SQL Server upgrading, the “Agent XPs” component is turned off, which prevents pdb_xlog init from succeeding.
Workaround:
Run these scripts using SQL Server Management Studio or SQLCMD to enable the SQL Server Agent extended stored procedures:
sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Agent XPs', 1; GO RECONFIGURE GO
Run pdb_xlog init to reinitialize Replication Agent.
