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?