Solution : https://service.sap.com/sap/support/notes/1458291 (SAP Service marketplace login required)
Summary :
This SAP Note details how to connect SAP Solution Manager 7.1 to a remote Microsoft SQL Server database for monitoring or for utilizing the Database Performance Warehouse and Alerting functionalities. Required SAP Solution Manager versions vary depending on cluster specifications, with SP02 needed for non-clustered setups and SP05 for clustered. Monitoring clustered SQL Server necessitates SMD Agents installed on each cluster node and specific configurations for SAPHostAgent and services under domain accounts. The note advises on technical prerequisites, such as network access, SQL Server minimum versions, and configuration setups including database connection via DBCON, and the necessity of certain service packs and patches.
Key words :
sql agent job titled sap_<monitor schema>_prd_mssql_collector, management -> sql server logs -> current log section, <sapsid>gosetuser '<monitoring schema>'gothen truncate, microsoft sql server snac client library, jobs -> back end configuration action, local solution manager sql server database system, external microsoft sql server database system, bc-db-ora application area, dbacockpit job configuration directs jobs, /wiki/display/smsetup /diagnostics+agent+
Related Notes :
| 1774329 | Preparing your SAP instance to connect to remote SQL server |
| 1644499 | Database connectivity from Linux to SQL Server |
| 1610030 | SOLMAN_SETUP wizard corrections for the local system |
| 1560717 | ST 7.0 and 7.1 SP01 and higher: Roles for SOLMAN_SETUP |
| 1558394 | MSS: Solution Manager SOLMAN_SETUP corrections |
| 1534235 | Solution Manager SOLMAN_SETUP implementation for SQL Server |
| 1316740 | Set up remote monitoring for Microsoft SQL Server databases |
| 1265134 | DBA Cockpit: Connecting a remote database |
| 1027512 | MSSQL: DBA cockpit for basis release 7.00 and later |
| 178949 | MSSQL: Database MultiConnect with EXEC SQL |
| 151603 | Copying an SQL Server database |