Unanswered: how do i connect via jdbc using Windows authentication mode?
What JDBC connection URL do I use to connect to SQL Server 2000 when the server is running in Windows authentication mode?
I understand the difference between the Windows authentication mode and the combined Windows/SQL Server authentication modes (or at least i think i do) - i.e when running in Windows authentication mode, the server checks the connecting process's Windows user ID rather than a separate SQL user id.
Fine, but then what URL do i use for the JDBC connection? Using the sql authentication i can do something like
but this does not work when the server is running in windows authentication mode because the user "sa" is an sql user. The above code gives the error "Login failed .... not associated with a trusted SQL Server connection ..."