SQLException

[ermorris]

Hi,

I'm running Jboss 3.0.0 on Win2K w/ SQL2000. When I try a hot deploy of the .ear file. I get a error message:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. The sa user is there by default. I think this one is something simple. I just don't know what. Thanks for your help.

Eric

[juha]

Which JDBC drivers are you using with sql server? It's most likely a config issue at the JDBC driver. Either the driver needs to provide the login information when it creates the db connection, or it needs to be able to create 'trusted connections' to the db server.

I seem to remember something vaguely similar from couple of years back when trying to work JDBC with MS SQL server but can't remember the details very well.

[mcacker]

make sure your server is set up to accept sql server authentication as well as windows authentication. the error you are gettting is a windown auth error