Solution : https://service.sap.com/sap/support/notes/98678 (SAP Service marketplace login required)
Summary :
This SAP Note addresses connection issues between SAP systems and Microsoft SQL Server, specifically covering timeout and connection errors. Key connection parameters—SERVER, DBNAME, and SCHEMA—are identified as crucial for SAP executables to connect to SQL Server using Windows Authentication. The note explains setting these parameters via SAP profiles and environment variables. It also details the use of network libraries (Named Pipes, Shared Memory, TCP/IP) and provides guidance on how to configure and troubleshoot connection settings for optimal performance across different network setups and SAP system releases. Troubleshooting tips for standalone and SAP connections are provided to aid in identifying and resolving connection problems effectively.
Key words :
terms timeout netlib tcp/ip named pipes shared memory netlib reason, set mssql_server=myserver\msdset mssql_dbname=msd set mssql_schema=msdset dbms_type=mss, case profile parameter dbs/mss/server = <server_name>\<sid>, add dbs/mss/dbsl_profile=1in, special environment variable called mssql_dbslprofile, dbs/mss/server profile parameter, environment variable mssql_server dbname, shared memory protocols, remove dbs/mss/dbsl_profile, \usr\sap\<sid>\dvebmgs
Related Notes :
| 1593183 | TCP/IP networking parameters for SQL Server |
| 738371 | Creating DBCON multiconnect entries for SQL Server |
| 551915 | R/3 won't start after database restore or database copy |
| 492966 | APO 3.0 liveCache administration/monitoring (LC10) |
| 455238 | MSSQL_* environment variables, profile parameters |
| 208632 | TCP/IP network protocol for MSSQL |
| 116735 | OLEDB Connections and Security |
| 28667 | Microsoft SQL Server Specific Profile Parameters |