We have SQL server installed on one server & SSAS stand-alone installation on other server(2017 on windows 2016). The SSAS server is not able to communicate to the SQL server. I can able to connect to SQL from my local machine. No issues with SQL server.
How to identify which driver is using when connecting to SQL server?
I can see ODBC 11, ODBC 17 , OLEDB 19 & SQL native client 11 is installed on SSAS server. If the data source is Native client 11, which driver it will be using to communicate with SQL Server?