Trying to use MSSQL 2008 database as Primary DS but keep Getting "Un

geneb over 11 years ago

Trying to use MSSQL 2008 database as Primary DS but keep
Getting "Unable to get managed connection for java:/jdbc/PrimarySQLServerDS" and further down in the log "Login for user XXX Failed" The login is good. What do I need to check?...

Discussion posts and replies are publicly visible

0 Zakee Rawn
Appian Employee
over 11 years ago

Is the password for the login credentials encrypted in standalone.xml?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 geneb over 11 years ago

Yes
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Zakee Rawn
Appian Employee
over 11 years ago

Just to verify, what version of Appian are you working on? Also, does the jndi-name in your *ds.xml file match the conf.data.primary.datasource property in custom.properties?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 geneb over 11 years ago

I'm on 7.2 and they do match: From ds.xml
jndi-name="jdbc/PrimarySQLServerDS"
jndi-name="jdbc/BusinessSQLServerDS"

From custom.properties
conf.data.primary.datasource=java:/jdbc/PrimarySQLServerDS
conf.data.datasources=java:/jdbc/BusinessSQLServerDS
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Zakee Rawn
Appian Employee
over 11 years ago

Gene, are you still having issues?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 geneb over 11 years ago

No I'm set now. Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Zakee Rawn
Appian Employee
over 11 years ago

What was the fix?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 geneb over 11 years ago

I dedicated seperate databases to the Primary and Business datasources. It started working after that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel