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 (I know the username and password - they never change),
different to the user
currently logged in to the machine running the application. I'm writing an
application for our automated build system and this domain user (and
password) is used for all aspects of the building. I really don't want to
have to create a user account on each SQL Server instance.

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. And if I don't do that, it seems
to require the use of a SQL Server 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

rgds

Rupert


.

Relevant Pages

  • Re: Balancing security needs in ADO.NET applications
    ... See my article http://www.developer.com/db/article.php/3693236 that shows how to put together a hierarchical TableAdapter using SPs. ... Hitchhiker's Guide to Visual Studio and SQL Server ... SQL Server credentials or the application's logon/pw. ... all they can do is run specific SPs that carefully guard the data and do not permit gross operations like dropping tables or changing rights. ...
    (microsoft.public.dotnet.framework.adonet)
  • JDBC connection to SQL Server 2005 with domain user
    ... I can connect to a SQL Server 2005 database using the Microsoft JDBC driver, ... uses the credentials of the current user. ...
    (comp.lang.java.databases)
  • Re: Login failed for user . The user is not associated with a trusted SQL Server connection.
    ... he never mentioned he is impersonating in asp.net - so no delegation needed. ... Cassini runs with the credentials of the interactive user - which seems to have access to sql - in contrast to the local ASPNET account - which i am trying to tell him since 2 days.... ... yes - use explicit credentials and enable mixed mode auth in sql server to get this to work. ...
    (microsoft.public.dotnet.security)
  • Re: Balancing security needs in ADO.NET applications
    ... you can't control security at this level) user access is determined by their ... SQL Server credentials or the application's logon/pw. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: IIS 6 and SQL Server - two seperate boxes
    ... make use of a risky solution. ... login to your SQL Server is that exploiting a "known vulnerability"? ... And the credentials could be stolen on ... the server (e.g. from a web.config file if you are using a static account), ...
    (microsoft.public.inetserver.iis.security)