File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Ant, Maven and Other Build Tools and the fly likes MS SQL Server / JDBC / Ant problems Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Engineering » Ant, Maven and Other Build Tools
Bookmark "MS SQL Server / JDBC / Ant problems" Watch "MS SQL Server / JDBC / Ant problems" New topic

MS SQL Server / JDBC / Ant problems

Unnsse Khan
Ranch Hand

Joined: Nov 12, 2001
Posts: 511
I am having trouble using Ant and MS SQL Server... Here's the info:
<target name="run.prelim.sql" depends="" >
When I run this ant target:
E:\Apps\FishStore\FishScripts\build.xml:45: java.sql.SQLException: [Microsoft][SQL Server 2000 Driver for JDBC][SQLServer]Login failed for user 'foobar'. Reason: Not associated with a trusted SQL Server connection.
Any suggestions, hints, & tips?
Kindest regards,
Philippe Ebersohl

Joined: May 04, 2004
Posts: 2
I am also playing with ant,
building a makefile for oracle/pgsql/mssql
1) I use rdbms="microsoft sql server" not rdbms="mssqlserver"
the later is not recognized. I use an SQL Server 2000 Enterprise Edition SP3a
What version/edition do you use ?
2) "Not associated with a trusted SQL Server connection."
May be the security settings
Use SQL Server Enterprise Manager, connect as "sa" or "security operator"
/ Right click on "YourServerName(Windows NT)"
/ "SQL Server Properties (configure)" choos "security" tab
/ Authentication:
(o) SQL Server and Windows
(_) Windows only
When Windows only, only trusted windows connections are allowed.
The scripting way (isql)
EXEC xp_loginconfig 'login mode'
should report 'mixed' or 'windows'
Hope that helps
I agree. Here's the link:
subject: MS SQL Server / JDBC / Ant problems
jQuery in Action, 3rd edition