I want to link a SQL Server Expess 2005 Database to a simple Java application. The resulting error is:
Exception: Fehler bei der Anmeldung für den Benutzer 'terencewin'. Der Benutzer
ist keiner vertrauenswürdigen SQL Server-Verbindung zugeordnet. (means: The user is not associated with a trusted SQL Server connection)
Microsoft reccommends: Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)". But in the Express versions there is no Mixed Mode. Either can I find some security tab to change the secuity authentication mode to "SQL Server and Windows".
The database is called ppverwaltung and the table person. The database can be accessed by Microsoft SQL Server Management Studio Express.
I use sqlcjbc4.jar as driver in a correct classpath statement.
The user "terencewin" is a SQL-Server-Authentication user with the password "test".
I alternatively tried to get access by a Windows-Authentication, no luck.
I too tried to eshablish a DataSourceName, but this did not work too.
Sql Server Express 2008 works well on a XP 32 bit System.
I first installed Sql Server Express 2005 and then Sql Server Express 2008 without deinstalling the 2005 version on a XP 64. This gave a mess. I just recommend to deinstall an old Express version before installing a new one. I'm not sure, if the errors came because of the 64 bit XP.
The installation instructions for SQL Server itself (the server component anyway) state you need to uninstall previous versions first. I believe you can have multiple versions of the client tools. If you need multiple versions of the server, run them in a VM.