Forum Discussion
Zubin_roy
Mar 19, 2021Copper Contributor
Connecting to an SQL Server ODBC via a Mac using Excel
Hi there,
I am trying to connect to a SQL Server Analysis services Cube on my macOS Big Sur (version 11.2.3) through Excel (version 16.47). I go to get External Data > new database query > SQL server ODBC and type in the server details but get an error whenever I try to connect. (See attached image)
"odbc driver 17 for sql server tcp provider: error code 0x102"
This is normally a straightforward enough task to do using a Windows PC and Excel but cannot seem to get it to work on a Mac. Any help/advice would be appreciated as I have been struggling with this for a while. Our connections to a SQL servers via Excel in Mac possible to do?
Thanks!
- SaraOliveiraCopper Contributor
Hi Zubin_roy did you ever fix this, I am getting the same problem
- rodrigovcCopper Contributor
Zubin_royI have the same error message that you report. I solved it adding, port number (in my case, 57151). So I was able to enter my SQL database, however access to the databases gives me an error. I can see the list of my databases but when I try to access one of them it does not extract the information from the database and reports a nonsense table (see attached photos). Tell me if you were able to solve the access to your database and if you had the same problem?