Skip to Content
Former Member
Apr 16, 2014 at 06:54 AM

Destination connection error for SQL Server in OrgAudit


Hi Experts,

We are using below Nakisa product.

Name: Nakisa OrgAudit

Version: 4.0 SP1

Build: 0910021800

Database: SQL Server

When Im creating the destination connection with the following parameters and test the connection Im getting the error 'Connection Failed:while trying to invoke the method java.sql.Connection.close() of an object loaded from local variable 'conn'. '.

Server Name: host name:port:sid

Initial Catalogue : Instance of SQL Server

User Name: Userid

Password: **********

I had an experience working with Oracle database but getting confused with SQL Server 'Initial Catalogue' parameter. I searched the forum and found that the initial catalogue should be instance of databse. We have only one instance of SQL server and I tried with that but still Im getting the same issue. Please let me know where Im going wrong.Any inputs will be highly appreciated.