search

dbcli / mssql-cli

A command-line client for SQL Server with auto-completion and syntax highlighting
BSD 3-Clause "New" or "Revised" License
1.35k stars 192 forks source link

Trying to connect to MS-SQL server on Windows from MacOS #554

Open rockwayschool opened 1 year ago

rockwayschool commented 1 year ago

This might be user error... I am running mssql-cli v1.0.0 Names and domains are changed because this is a work computer mssql-cli -S myserver,myport I do believe I am successfully connecting to the server, because when I forgot to put the port I got a connection error. After putting in the port, I got a login error. For the user I put mydomain/myuser. I also tried myuser and \mydomain/myuser I am on macos monterey. The Directory utility app says I am in AD mydomain.mycompany.us I have tried both a user created for the db and also my AD SSO account. I have connected before using both users to this db from windows but I no longer have the laptop.

Am I missing some step in authenticating?

azinsharaf commented 1 year ago

maybe use sqlcmd to test the connectivity. I would facilitate the troubleshooting.