SAP Knowledge Base Article - Preview

2748808 - server_admin failed Could not connect to <mssql.PDB> - SRS

Symptom

  • Replicating from Microsoft SQL Server (MSSQL) to SAP Adaptive Server Enterprise (ASE) using SRS.
     
  • After applying Microsoft SQL Server (MSSQL) Patches, stored procedure sp_SybSetLogforReplTable  is no longer there.
     
  • To resolve the missing procedure, followed  the instructions in this document,  SAP Replication Server Options 15.7.1, (step 4 Applying Microsoft SQL Server Patches) to regenerate the objects in the MSSQL system resource database.  That approach failed and server_admin is failing with the following error:
      

    • Command <server_admin> failed - Could not connect to <mssql.PDB> because:Can't connect to PDB


Read more...

Environment

  •  SAP Replication Server Option (RSO) for Microsoft SQL Server 15.7.1
  •  SAP Replication Server Heterogeneous Edition (RSHE) 15.7.1 & 16.0
  •  SAP Replication Server (SRS) 15.7.1 & 16.0
  •  Microsoft SQL Server 2014

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0 ; SAP Replication Server, heterogeneous edition 16.0 ; SAP Sybase Replication Server 15.7, heterogeneous edition ; SAP Sybase Replication Server 15.7, option for Microsoft SQL Server

Keywords

RAM; sp_SybSetLogforReplTable ; 2536849 , KBA , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RSO , Rep Server Options (RSO) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.