2 Replies Latest reply on Nov 19, 2002 1:38 PM by mitchell ackerman

    SQLException

    Eric Morris Newbie

      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

        • 1. Re: SQLException
          Juha Lindfors Master

          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.

          • 2. Re: SQLException
            mitchell ackerman Newbie

            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