how to use windows login to SQL Server from Linux and jsp

For several years now I have been connecting from jsp on linux to a Windows SB server running SQL Server 2005. Currently, this is always done through a single SQL login that is not also a Windows login.

Now I would like to be able to let individual uses in the office Windows LAN use their Windows login IDs. SQL server Management Studio  > Object Explorer > Security > Logins, shows these IDs of the form hprs\Name. I've tried using "hprs\Name" and just "Name" in the  dbUser parameter of my connection URL, but neither work. I get the exception message:

Status: 18456 Login failed for user 'hprs\mark'

I'm stuck. What am I doing wrong?
LVL 1
jmarkfoleyAsked:
Who is Participating?
 
RiteshShahConnect With a Mentor Commented:
I guess there is not way to do so.
0
 
RiteshShahCommented:
you can't use windows authentication from Linux to Windows. If you make connection string for windows authentication, there is nothing when you can set id/pass in connection string. it uses your current user of windows so it won't work for Linux. You have to go for SQL Authentication.
0
 
objectsCommented:
yes, you'll need to be windows
plus you'd need to specify integratedSecurity to true in your connection string
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
jmarkfoleyAuthor Commented:
So, there is no way to connect to my SQL Server login from linux? There are no provisions for Windows authentication at all?
0
 
jmarkfoleyAuthor Commented:
What about winbind? Would that work in this case?
0
 
objectsCommented:
haven't used winbind sorry, so not sure
but I would suspect not

from memory integratedSecurity actually requires the user to be logged in
0
 
objectsCommented:
which is what I had already said :)
0
All Courses

From novice to tech pro — start learning today.