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

[former_member368911]

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

[denis_konovalov]

I have fixed your tags to match the nature of your error.

[former_member193452]

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%2fwebsmp2...

[DellSC]

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