Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Print Bookmark Alert me when this article is updated


Profiling of SQL Server fails with error "Function Name: Connect, Database driver error..., Database Error: Failed to connect to database using user [USER string [DSN].]"
Problem Description
Profiling of SQL Server fails with the following error:

[ExecuteThread-{Task_IndWeb_ProfileScanner_ProfileExecutor}] INFO ProfileValidator- An error occurred during profile run: - ParentName: pres , SourceName: SOURCE_CONNECTION , ErrorMessage: (java.util.concurrent.ExecutionException: com.informatica.sdk.dtm.ExecutionException: [LDTM_0072] RR_4036 Error connecting to database [ 
523 630 
Database driver error... 
Function Name : Connect 
Database driver error... 
Function Name : Connect 
Database Error: Failed to connect to the database using user [USER] and connection string [DSN].].)
​The encountered issue happens when ODBC configurations are not done properly in DOMAIN.
Set the following environment variable in the Domain:

export ODBCINI=$INFA_HOME/ODBC7.1/odbc.ini
export ODBCINST=$INFA_HOME/ODBC7.1/odbcinst.ini
export PATH=$INFA_HOME/ODBC7.1/bin:$PATH​

There are 2 ways to access data in SQL Server Resource:

Using DSN and without DSN 

In case [Use DSN] set to [NO]:

In the Informatica Administrator > Connection tab, Go to the Connection and in the [Data Access Properties], set [Use DSN] to FALSE (uncheck) and Connection String [SQL_SERVER_HOST_NAME@DB_NAME] 

In case [use DSN] set to [YES]:

Edit the odbc.ini file  [$INFA_HOME/ODBC7.1/odbc.ini] and Create a DSN with the name [DSN_NAME].
  • Edit the file: $INFA_HOME/ODBC7.1/odbc.ini
  • Copy and paste the complete section [SQL Server Wire Protocol] (with all the below values) and rename it to [DSN_NAME].
  • Provide the below 2 details:

More Information
Applies To
Product: Enterprise Data Catalog
Problem Type: Configuration
User Type: Administrator
Project Phase: Onboard; Configure
Product Version: Enterprise Data Catalog 10.2.1; Enterprise Data Lake 10.2.2
Operating System:
Other Software:

Last Modified Date:8/9/2019 4:25 AMID:577739
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)