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
MarkAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
MarkAuthor 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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

MarkAuthor 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
RiteshShahCommented:
I guess there is not way to do so.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
objectsCommented:
which is what I had already said :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java

From novice to tech pro — start learning today.