There was a problem looking up the JNDI data source 'sbtcd'

[kavle]

Hi All,

I am trying to do a SQL DB integration with call studio app. Getting below error.

"""The error was: A built-in element encountered an exception of type com.audium.server.AudiumException.
There was a problem looking up the JNDI data source 'sbtcd'. The root cause was: javax.naming.NameNotFoundException: Name [sbtcd] is not bound in this Context. Unable to find [sbtcd]"""

below are the jar files I have in my CVP server.

 under the location - C:\Cisco\CVP\VXMLServer\Tomcat\lib

mysql-connector-java-8.0.11.jar
mssql-jdbc-12.2.0.jre8.jar

below is my context.xml parameters.

<Resource name="jdbc/sbtcd"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
DriverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://Hostname:1433;databaseName=sb_abcd;
user=abdcxyz;
password=abcd123;encrypt=true;trustServerCertificate=true"/>

[bill.king1]

There are a few threads on the community about the JNDI setup. Here's one of them that went into it in detail https://community.cisco.com/t5/contact-center/need-to-know-what-files-should-be-updated-with-jndi-and-db/td-p/4037102 
Personally, I typically see username and password broken out separately, and not included in the URL like you did. I can't say if that's the issue, but that's one thing I would check.
Also, did you restart VXML after you added that?
Please rate helpful posts.

[kavle · Accepted solution]

Hi Bill,

sorry issue was resolved already ... thank you for your reply sir.

I had to remove this parameter - trustServerCertificate=true