login as domain user with win auth

microsoft / mssql-scripter

Repository for the new SQL cross-platform command line tools

Other

738 stars 147 forks source link

login as domain user with win auth #266

Open elpyrulez opened 2 years ago

elpyrulez commented 2 years ago

Hello,

i have a problem about logging as a domain user with mssql-scripter. I've been working with "pymssql" lately to manipulate with our company databases, and it went quite well even with domain user. But when i want to use domain user in mssql-scripter, i usually land on error saying that i need "Keberos ticket", can someone explain me, why i can connect with pymssql/tsql without providing anything, but not with mssql-scripter?

Thanks in advance

xiaounbound commented 2 years ago

Integrated auth is only set if a user name is not provided per https://github.com/microsoft/mssql-scripter/issues/111#issuecomment-313439429. I've been able to see this working: mssql-scripter --server <your-server>