Skip to Content

The network layer OLEDB and database MS SQL Server 2016 is not a valid supported connectivity

Hi

I have a relational connection at IDT which uses MS SQL Server 2016 OLEDB driver and I have the driver installed at both my client machine as well as BO server.

I don't see any problem while creating single source universe on top of this connection in IDT but when I choose to create Multi Source Universe at data foundation layer, I could see the below error which stops me to proceed further.

"The network layer OLEDB and database MS SQL Server 2016 is not a valid supported connectivity"

Any thoughts to help me out on this please?

(Screenshot attached)

oledb-error.jpg

Thanks

Shankar

oledb-error.jpg (24.4 kB)
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Posted on Mar 26 at 01:38 PM

    I prefer using SQL Server Native Client instead of the specific OLEDb or ODBC driver for SQL Server. I've found it to be much more stable and the 32-bit version, which is needed for the IDT, is automatically installed when you install the 64-bit version which is needed for the BI Platform. For SQL Server 2016, you need version 11.0 of the Native Client - it won't work with the version that is installed as part of the OS.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 30 at 08:28 PM

    There are changes to the OLE DB support. For 2016 Sql Server it is not certified for 4.2 sp7. However, you can probably use the same driver, but when creating a connection, select Sql Server 2014. in Bi 4.2 SP8 the ole driver must be updated for support. check the PAM for your version here: https://apps.support.sap.com/sap(bD1lbiZjPTAwMQ==)/support/pam/pam.html?smpsrv=https%3a%2f%2fwebsmp201.sap-ag.de#ts=0

    Add comment
    10|10000 characters needed characters exceeded