Share via

Failed to connect to SQL Server on Mac

Alex S 1 Reputation point
2020-09-30T09:54:45.243+00:00

Hi,

If anyone can help me, I really appreciate it! I am new to this and not understanding why I cannot connect. I get the following error message:

[SqlServerODBC] (15) Failed to connect to the SQL Server instance: [HY000]: Connection broken unexpectedly.

I've looked at many posts online and have followed some solutions - installing the SQL from Docker and then the ODBC Driver for SQL from the Microsoft website but I am still getting the same error.

Should I start from scratch and can anyone explain to me the steps I need to take?

Thanks!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,131 Reputation points Microsoft Vendor
    2020-10-01T09:02:20.87+00:00

    Hi @Alex S ,

    Did you enable SQL server authentication for SQL server instance? Please restart SQL server instance to make this change effect. Please refer to Change server authentication mode.

    Did you try to add the port number to the server name or using OP address to connect to SQL server? Check if this thread could help you.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Alex S 1 Reputation point
    2020-10-02T08:54:46.92+00:00

    Hi Cathy,

    I am actually trying to set up an FTP so that I can download data from something I subscribe to.. so I am not sure if the above steps that I have taken are actually necessary of this is an error on their side?

    Thanks,
    Alex

    0 comments