problem with the user name and password
8 10月, 2009
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.
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.
It could be failing because it is only using Windows Authentication.
To modify the Yellowfin connection to use windows authentication add ";domain=" to the end of the connection URL.
ie.. jdbc:jtds:sqlserver://:/;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..
To modify the Yellowfin connection to use windows authentication add ";domain=" to the end of the connection URL.
ie.. jdbc:jtds:sqlserver://:/;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..