Solution : https://service.sap.com/sap/support/notes/178949 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the configuration and operational guidance for utilizing EXEC SQL MultiConnect to access data on non-local MSSQL systems in an R/3 environment. Prerequisites include a Windows application server, installation of the DBSL library dbmssslib.dll for MS SQL Server platforms, and specific setup in the ABAP kernel directory for non-SQL Server environments. The note outlines how to create DBC iframe entries, manage connection settings, and utilize EXEC SQL commands for remote data access, highlighting special considerations for server name protocols in kernel release 6.40 and later. Comprehensive details are provided for managing changes in DBC entries and utilizing the dbacockpit and st04_mss transactions for configuration.
Key words :
sap netweaver -> application platform -> databases -> sap/ms sql server 2000 dba, database management tools -> monitoring remote sql server databases -> setting, terms connect dbcon oledb dblib reason, exec sql multiconnect open sql database accesses, documentation -> sap netweaver -> sap netweaver '04, mssql_server=<server_name> mssql_dbname=<db_name> db_user, sql server database platform, ms sql server section, remote ms sql server, exec sqlthis note describes
Related Notes :
| 829706 | MSSQL: DB Multiconnect in the MSSPROCS program |
| 738371 | Creating DBCON multiconnect entries for SQL Server |
| 512739 | BW external DB Connect for MS SQLServer |
| 323151 | Several DB connections with Native SQL |
| 160484 | DB2/390: Database multiconnect with EXEC SQL |
| 146624 | i5/OS: Database Multiconnect for IBM DB2 for i5/OS |
| 117261 | Multiconnect and DB procedure enhancements for 4.0B |
| 44977 | EXEC SQL: New features |