2949033 - How to test a Microsoft SQL Server OLE DB connection

• Using reports based on OLE DB Connections and drivers
• Connectivity with the reports shows database connection errors
• Want to verify whether or not the connection is valid 

• Microsoft SQL Server
• OLE DB Driver

The following steps and information are retrieved from the Microsoft documentation and are provided as-is.

For further details, please see the documentation at this link https://docs.microsoft.com/en-us/sql/connect/oledb/help-topics/data-link-pages?view=sql-server-ver15 or reach out to Microsoft.

1. Create a file called TestConnection.udl
2. Double-click the file to launch the UDL dialog.
3. In the Provider tab, select the OLE DB Driver in use by the reporting application
• 
4. In the Connection tab enter the connection details for your database
• 
5. Click Test Connection
6. In the event of errors, please review Microsoft help documentation or reach out to Microsoft Support. SAP Support is unable to provide assistance with specific errors as the OLE DB Drivers are provided by a third-party.

KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , How To