Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
2 years ago
Originally Published: 2007-12-27
Article Number
000053123
Applies To
RSA Key Manager Server 2.1.x
Apache Tomcat 5.5.x
Issue
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Cause
keymanager.properties contains:
  use.container.credentials=true
Resolution
If you are using Tomcat as the Java Application Server for RSA Key Manager Server, you must set use.container.credentials to false.
If setting use.container.credentials to false does not eliminate the null logins, add automaticTestTable="rkmtesttable" to both connection pools specified in kms.xml.
Notes
use.container.credentials means that KMS will use the file databaseCredentials.properties when creating database connections. Some supported application servers, like BEA WebLogic and IBM WebSphere uses credentials created from their Admin Console, so the file databaseCredentials.properties is not needed.