Hello, I am having trouble using Ant and MS SQL Server... Here's the info: <target name="run.prelim.sql" depends="" > <sql driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" url="jdbc:microsoft:sqlserver://baba:1433;database=FishStore" userid="foobar" password="barbaz" rdbms="mssqlserver" > <transaction src="E:\Apps\FishStore\FishScripts\test.sql"/> </sql> </target> When I run this ant target: BUILD FAILED 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,
Hi Unnsse, By the sound of it I suspect it 's the security settings of the SQL Server instance you 're working with. Could it be the instance is set to accept only windows authentication, thus barring logins using explicit username/password? Good riddance, Rudy.
Unnsse, Bear, possibly others, Please accept my apologies for any rudeness. I am afraid I have tried to leap further than my knowledge of english allows for in using the term 'good riddance'. I have in the meantime found out it is not exactly related to riding, as I thought. I must say, though, that I have not really found why it 'd be rude. Anyway, inappropriate is also out of place, so I 'll close my post with: Good riding, Rudy.