JDBC connection to SQL Server 2005 with domain user


I can connect to a SQL Server 2005 database using the Microsoft JDBC driver,
using either a SQL Server user, or using the credentials of the user
currently logged in without any problems.
However, I want to login using a domain user, different to the user
currently logged in to the machine running the application.

I've tried using both URL connection strings and a Properties object, but I
can't get it to work. As soon as I specify "integratedSecurity=true", it
uses the credentials of the current user.

I'm sure it must be possible, but I couldn't find anything on Google.
Could someone give me a clue (or an example would be even better!) please?

Many thanks


.

Relevant Pages

  • RE: Sharepoint Services problems
    ... attempting to connect to the SQL database under the credentials it was setup ... but these credentials are not valid in SQL. ... I would start by verifying the credentials under which WSS runs has ... > The SQL Server might not be started. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Probably a simple question
    ... passing user's credentials to the SQL Server. ... applications just keep a separate SQL login ID for database operations (all ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: What are the SharePoint WMSDE login credentials?
    ... I am using Enterprise Manager to connect to the database on another machine ... "SQL Server registration failed because of the connection failure displayed ... gets to the Windows login screen to put in credentials. ... >> credentials would they be the account from which the installation was ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Sharepoint Services problems
    ... I'm not familiar with the term WSS, ... there's a page to change database connection information. ... but these credentials are not valid in SQL. ... >> The SQL Server might not be started. ...
    (microsoft.public.sharepoint.windowsservices)
  • JDBC connection to SQL Server 2005 with domain user
    ... I can connect to a SQL Server 2005 database using the Microsoft JDBC driver, ... application for our automated build system and this domain user (and ... uses the credentials of the current user. ...
    (microsoft.public.sqlserver.jdbcdriver)