This forum is now out of date, for our new forum Click Here
problem with the user name and password
Question Asked
Hi, I'm having a problem with the user name and password. I have changed the password of "sa" a few times and the connection still fails. Is this because when I connect to SQL Express via SQL Manager then I use Windows Authentication?

This is the error message I am receiving:

java.sql.SQLException: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.


Thu Oct 8, 2009 10:21 PM

It could be failing because it is only using Windows Authentication.
To modify the Yellowfin connection to use windows authentication add ";domain=<domain>" to the end of the connection URL.
ie.. jdbc:jtds:sqlserver://<host>:<port>/<database>;domain=<domain>

You can then use windows authentication for the connection..
If that fails I would recommend you try downloading Management Studio for SQL Server Express and re-enable SA authentication..


Thu May 26, 2011 10:42 AM