In SharePoint Server 2016, you create an Access database by creating a new. Now the error code changes from 28000 to HY000 and the message reads 'Connection broken unexpectedly'. Stop using clumsy MS Excel spreadsheet files and use a powerful6 License for. As the Microsoft Excel team noted in a recent blog post, Excel 2016 for Mac comes with a pre-installed and integrated SQL Server ODBC driver, which we worked hand-in-hand with Simba Technologies to provide. I then found some support that stated that I need to specify the Port number for the server (60198):Įrror Message: (15) Failed to connect to the SQL Server instance: : Connection broken unexpectedly Excel 2016 for Mac users can find the SQL Server ODBC connector on the Data tab under New Database Query. I do the following:Įrror Message: (15) Failed to connect to the SQL Server instanceL : Login failed for user 'crystal'. However, I try the same or similar settings with my Mac's Excel 2016 and I do not succeed in making the connection. I successfully manage to query the same SQL server in Windows using ODBC connections to the SQL server on our LAN. I tried to follow the Office Support info available on this link: We also have another SQL Server (SQL Server Express 2012) that I also access via ODBC on Windows Excel 2016. I am having trouble connecting to a SQL Server (2008 R2) via the new Excel 2016 for Mac SQL Server ODBC New Database Query feature.
