wood burning stoves 2.0
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 Java Interview Guide this week in the Jobs Discussion 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: http://aspose.com/file-tools
subject: MS SQL Server / JDBC / Ant problems
It's not a secret anymore!