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.
Joined: Nov 12, 2001
What's up with the "Good Riddance" closing greeting?
Joined: Jul 27, 2002
Nothing much. I just think it fits nicely with the ranch theme, just as my display name does. S' long, 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.