Search code examples
sqlsql-servermacosdbvisualizer

Set up SQL Server connection in Dbvisualizer on Mac


I am trying to set up an SQL server connection in db visualiser on mac but i am getting the error "cannot connect to port 1433". I have tried to connect to the port through the terminal but i get the exact same message.

Can anyone advise me on how to set this up? i am a total noobenter image description here

enter image description here


Solution

  • Is the database really running on the same Mac as DbVisualizer? If so, is it configured to accept TCP/IP connections on localhost (127.1.1.1) on port 1433? As I recall, SQL Server does not accept TCP/IP connections by default, and you need to enable it explicitly for each network interface.

    Best Regards, Hans