If doesn't set the default schema name for SQLServer the error "Login failed for user 'username'" could happen in runtime

If doesn't set the default schema name for SQLServer the error "Login failed for user 'username'" could happen in runtime

book

Article ID: KB0081828

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database 7.1.0,7.2.0

Description

For SQL Server database, the Active database adapter test connection is successful in Designer but after starting, the adapter throws an exception:
**********
"java.sql.SQLInvalidAuthorizationSpecException:
[tibcosoftwareinc][SQLServer JDBC Driver][SQLServer]Login failed for user 'username'.
***********
 

Environment

Product: TIBCO ActiveMatrix Adapter for Database Version: All supported versions OS: All Supported Operating Systems

Resolution


To resolve this issue, provide the default schema name in the Active Database Adapter Configuration​ of the run-time connection tab. 

 

Issue/Introduction

The Active database adapter test connection is successful in designer while after starting the adapter throws an exception "java.sql.SQLInvalidAuthorizationSpecException: [tibcosoftwareinc][SQLServer JDBC Driver][SQLServer]Login failed for user 'username'.
Powered by Wolken Software