Saturday 15 January 2011

sql server - Authentication error connecting to MS SQL DB on Linux -



sql server - Authentication error connecting to MS SQL DB on Linux -

my current setup windows ms sql server set active directory. have business relationship on active directory. need utilize windows authentication log in. i'm trying connect sql server via tsql linux box. this, i'm running following:

tsql -s <server> -u <active_direct_domain\\username>

this failing error code:

locale "en_us.utf-8" locale charset "utf-8" using default charset "utf-8" msg 18452 (severity 14, state 1) symplectic03 line 1: "login failed. login untrusted domain , cannot used windows authentication." error 20002 (severity 9): adaptive server connection failed there problem connecting server

i've tried running without domain:

tsql -s <server> -u <username>

and next error:

locale "en_us.utf-8" locale charset "utf-8" using default charset "utf-8" msg 18456 (severity 14, state 1) symplectic03 line 1: "login failed user 'username'." error 20002 (severity 9): adaptive server connection failed there problem connecting server

i have no thought going wrong here. apparently, don't have ability connect via tsql through windows authentication, shouldn't if on active directory? tsql not back upwards windows authentication?

just guessing. first start see if can connect sql business relationship not advertisement account.

microsoft has odbc driver sql server linux. http://msdn.microsoft.com/en-us/library/hh568451(v=sql.110).aspx

sql-server linux tsql

No comments:

Post a Comment