![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
To connect to Sqlserver from Linux with a domain account you use kerberos. Basically you connect with kinit first, then use trusted_connection:
note: on a Mac you can just ticket viewer to connect.
How to connect to SQL Server using JDBC Driver, with the user as myDomain\myUser, from Linux without DotNet?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
How to connect to SQL Server using JDBC Driver, with the user as myDomain\myUser, from Linux without DotNet?
- JDBC driver .jar file being used is mssql-jdbc-12.8.1.jre8.jar
- MS SQL Server version being used is 16
- Requires encryption = true
- The computer trying to connect to the SQL Server is a Linux box without any DotNet infrastructure
PS: (edited, fixed user in this question from myUser\myDomain to myDomain\myUser)
SQL Server | Other
3 answers
Sort by: Most helpful
-
Olaf Helper 47,616 Reputation points2024-11-01T09:40:25.0333333+00:00 with the user as myDomain\myUser
If the Linux server is joined to a domain, then you can use the connection string property "integratedSecurity", see
https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16
-
Anonymous
2024-11-11T12:34:55.9+00:00 Hi.
We do not want our Linux host to join a domain. We just want to connect to MS-SQL-Server by supplying it a domainName and a userName.
The same domainName and userName are used to successfully connect to MS-SQL-Server using a range of other technologies, including PERL. In fact, only the JDBC driver seems to be failing so far.
-
Deleted
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Sign in to comment -
-
LiHongMSFT-4306 31,621 Reputation points2024-10-31T03:23:26.3+00:00 Hi @Anonymous
Please check this article for detailed steps: Microsoft SQL Server JDBC for Linux.
Best regards,
Cosmog
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 24%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAQ%3C/text%3E%3C/svg%3E)
Andy Qian 0 Reputation points2024-11-01T09:14:53.28+00:00 HI, Cosmog,
The article does not mention connection with domain user. any more specific information for domain user case?Thanks.
Andy
-
Andy Qian 0 Reputation points
2024-11-01T09:16:24.52+00:00 hi, Cosmog
the article does not mention the use case involving domain user for connection. do you have any more specific information about connecting with domain user?
Thanks.
Andy
Sign in to comment -