Resolution:
1. Smartmapper does not support Tibco’s DD driver shipped by TRA5.6.0 when connects to Sql Server 2005, it gives error below when doing Create Relationship Instance while it works fine with TRA5.6.1:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
SmartMapper Exception: Failed to create mappings. SQL State: HY000. Vendor Error Code: 3971.
nested exception is:
java.sql.SQLException: [tibcosoftwareinc][SQLServer JDBC Driver][SQLServer]Server failed to resume the transaction, desc:  3f00000005.
caused by: com.tibco.solution.xref.XRefException: Failed to create mappings. SQL State: HY000. Vendor Error Code: 3971.
nested exception is:
java.sql.SQLException: [tibcosoftwareinc][SQLServer JDBC Driver][SQLServer]Server failed to resume the transaction, desc:  3f00000005.
java.sql.SQLException: [tibcosoftwareinc][SQLServer JDBC Driver][SQLServer]Server failed to resume the transaction, desc:  3f00000005.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

2. Smartmapper does not support Sql Server 2005 native driver when connects to Sql Server 2005, it gives error when doing Create Relationship Instance:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
SmartMapper Exception: Failed to create mappings. SQL State: null. Vendor Error Code: 0.
nested exception is:
com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
caused by: com.tibco.solution.xref.XRefException: Failed to create mappings. SQL State: null. Vendor Error Code: 0.
nested exception is:
com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Driver support issue with SM connects to Sql Server 2005 as a repository.