Solution : https://service.sap.com/sap/support/notes/738371 (SAP Service marketplace login required)
Summary :
Connection errors may arise when attempting a multiconnect setup to a remote SQL Server via a configured DBCON entry in SAP systems. The errors are typically due to configuration settings in the DBCON table impacting reliability. Essential settings include USER_NAME, PASSWORD, and CON_ENV, with USER_NAME enabling SQL Server or Windows Authentication and PASSWORD being sensitive to case. CON_ENV allows for specifying SQL Server options like server name and connection protocol (TCP/IP or named pipes). Modifications to network protocols and server name prefixes can determine the connection method and require alignment on all connecting SAP application servers. Use tools like osql or Query Analyzer for troubleshooting connections, ensuring settings are correctly implemented.
Key words :
ccms database management tools sap/sql server database monitor monitoring remote sql server databasesyou, checking control panel -> administrative tools -> services, ms sql server dbsl library dbmssslib, ms sql server porting group made, databases sap/ms sql server 2000 dba, monitoring remote sql server databases, sid\dvebmgs00\work named dbsl_w, sql server client network utility, sap monitoring applications starting, sid\dvebmgs00\work\dev_w
Related Notes :
| 1248222 | ODBC DBSL profile parameters and connect options |
| 687866 | R/3 can't connect to SQL Server |
| 323151 | Several DB connections with Native SQL |
| 178949 | MSSQL: Database MultiConnect with EXEC SQL |
| 116735 | OLEDB Connections and Security |
| 98678 | SQL Server Connection Issues |