mssql-cli icon indicating copy to clipboard operation
mssql-cli copied to clipboard

Published 20 hours ago • verified publisher icon dbcli

unable to connect mssql from Linux centos

Open shiva1232 opened this issue 2 years ago • 1 comments

I am trying to connect for automation from Linux centos VM to windows MSSQL servers below .

mssql-cli -S XXXXXXX,1433 -U pamus-adm -d Password: Error message: Login failed for user 'pamus-adm'.

user account(pamus-adm) has access. I am able to log in manually. How to troubleshoot and fix. Please help.

shiva1232 avatar Apr 06 '22 05:04 shiva1232

It looks like you may be using a Windows-style server argument whereas Linux just uses hostname. Try -S localhost if you're running it from the database server.

greenseeker avatar Jun 03 '22 17:06 greenseeker