MAckBook -> DB visualizer --> MSSQL server on windows server
r
rajavardhan k
started a topic
over 2 years ago
I have windows authentication on SQL server, previously when I used windows laptop I used to connect fine using MSSQL studio with windows authentication.
driver: SQL server JTDS
DbVisulizer Free version is being used, not sure if that is an issue.
My LAptop: MasOS Monterey
Error MEssg:
Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
Details:
Type: java.sql.SQLException
Error Code: 18452
SQL State: 28000
Observation: I was not able to find the Autentication mode and select windows autentication
Below is the screenshot
Tried following suggestion on this thread but not able to find the windows authentication option under authentication section. -
In some places I have seen Windows usernames specified as DOMAIN\username, you could try that and see if it helps.
Are you using any other applications with Windows authentication on your Mac? If possible it would be great if you could check if it is possible for you to authenticate with Windows authentication from your Mac at all.
When you were using a Windows laptop, were you logged in as an AD user? Is your Mac part of the same AD?
None of the above suggestions solved the issue.
What finally worked was setting Properties -> Driver Properties-> USENTLMV2 to true
rajavardhan k
I have windows authentication on SQL server, previously when I used windows laptop I used to connect fine using MSSQL studio with windows authentication.
driver: SQL server JTDS
DbVisulizer Free version is being used, not sure if that is an issue.
My LAptop: MasOS Monterey
Error MEssg:
Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
Details:
Type: java.sql.SQLException
Error Code: 18452
SQL State: 28000
Observation: I was not able to find the Autentication mode and select windows autentication
Below is the screenshot
Tried following suggestion on this thread but not able to find the windows authentication option under authentication section. -
-> https://confluence.dbvis.com/display/UG91/Using+SQL+Server+Single-Sign-On+or+Windows+Authentication
->