Error during export of visual process

Max_20905

I'm currently trying to setup a visual process that has a database source connected to a workspace then 2 exports, however, it keeps failing on the export steps. Here's the error I keep receiving:

The 'SQLNCLI11.1' provider is not registered on the local machine.

Is it referring to my computer or the server and how do I go about fixing this issue?

Thanks

------------------------------
Max Strahan
SQL Developer
------------------------------

Mahmoud

Hi Max,
It is referring to the server.  All Automator processes run on the server.  If a process needs to connect to a database via ODBC or OLEDB, then the ODBC driver or OLEDB provider must be installed on the Automator server.
You need to install the SQL server provider v11 on the server.  You can refer to the 'Monarch Server v15.3 Automator Project Editor Connection Strings Guide.pdf' document for creating connection string.
If you installed Automator x64 you can install the msodbcsql_x64.msi on the server which can be located in the 'Monarch Server v15.3 Release Image.zip\Installer Single Server 32&64-bit\ISSetupPrerequisites\' path of the installation package.
if you run the ODBC Data Source Administrator (64-bit) on the server and click on the Add button you can see what SQL Server provider was installed on the server.

Regards
Mo

------------------------------
Mahmoud Abdolrahim
Senior Implementation & Integration Engineer
Datawatch Corporation
MA
(978) 935-3840
------------------------------
-------------------------------------------
Original Message:
Sent: 02-05-2020 11:31 AM
From: Max Strahan
Subject: Error during export of visual process

I'm currently trying to setup a visual process that has a database source connected to a workspace then 2 exports, however, it keeps failing on the export steps. Here's the error I keep receiving:

The 'SQLNCLI11.1' provider is not registered on the local machine.

Is it referring to my computer or the server and how do I go about fixing this issue?

Thanks

------------------------------
Max Strahan
SQL Developer
------------------------------
"

Baba_Majekodunmi_703

Hi @Max Strahan !

Sounds like you may need to verify the SQL Server credentials. Here's an example of the one we are using internally;
Then you need to make sure that the Service Account has the right privileges to write to the database you are exporting it.

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325
------------------------------
-------------------------------------------
Original Message:
Sent: 02-05-2020 11:31 AM
From: Max Strahan
Subject: Error during export of visual process

I'm currently trying to setup a visual process that has a database source connected to a workspace then 2 exports, however, it keeps failing on the export steps. Here's the error I keep receiving:

The 'SQLNCLI11.1' provider is not registered on the local machine.

Is it referring to my computer or the server and how do I go about fixing this issue?

Thanks

------------------------------
Max Strahan
SQL Developer
------------------------------
"

Max_20905

Baba Majekodunmi_21731 said:

Hi @Max Strahan !

Sounds like you may need to verify the SQL Server credentials. Here's an example of the one we are using internally;
Then you need to make sure that the Service Account has the right privileges to write to the database you are exporting it.

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325
------------------------------
-------------------------------------------
Original Message:
Sent: 02-05-2020 11:31 AM
From: Max Strahan
Subject: Error during export of visual process

I'm currently trying to setup a visual process that has a database source connected to a workspace then 2 exports, however, it keeps failing on the export steps. Here's the error I keep receiving:

The 'SQLNCLI11.1' provider is not registered on the local machine.

Is it referring to my computer or the server and how do I go about fixing this issue?

Thanks

------------------------------
Max Strahan
SQL Developer
------------------------------
"

Hi @Baba Majekodunmi, that might be it because I've verified that I have SQL Server Native Client 11 on my workstation, going to check the server next. Then I'll verify the credentials  and service account permissions as well.

Thanks for the response.

------------------------------
Max Strahan
SQL Developer
------------------------------
-------------------------------------------
Original Message:
Sent: 02-05-2020 12:56 PM
From: Baba Majekodunmi
Subject: Error during export of visual process

Hi @Max Strahan !

Sounds like you may need to verify the SQL Server credentials. Here's an example of the one we are using internally;
Then you need to make sure that the Service Account has the right privileges to write to the database you are exporting it.

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325
------------------------------

Original Message:
Sent: 02-05-2020 11:31 AM
From: Max Strahan
Subject: Error during export of visual process

I'm currently trying to setup a visual process that has a database source connected to a workspace then 2 exports, however, it keeps failing on the export steps. Here's the error I keep receiving:

The 'SQLNCLI11.1' provider is not registered on the local machine.

Is it referring to my computer or the server and how do I go about fixing this issue?

Thanks

------------------------------
Max Strahan
SQL Developer
------------------------------
"

Mahmoud

Hi Max,
It is referring to the server.  All Automator processes run on the server.  If a process needs to connect to a database via ODBC or OLEDB, then the ODBC driver or OLEDB provider must be installed on the Automator server.
You need to install the SQL server provider v11 on the server.  You can refer to the 'Monarch Server v15.3 Automator Project Editor Connection Strings Guide.pdf' document for creating connection string.
If you installed Automator x64 you can install the msodbcsql_x64.msi on the server which can be located in the 'Monarch Server v15.3 Release Image.zip\Installer Single Server 32&64-bit\ISSetupPrerequisites\' path of the installation package.
if you run the ODBC Data Source Administrator (64-bit) on the server and click on the Add button you can see what SQL Server provider was installed on the server.

Regards
Mo

------------------------------
Mahmoud Abdolrahim
Senior Implementation & Integration Engineer
Datawatch Corporation
MA
(978) 935-3840
------------------------------
-------------------------------------------
Original Message:
Sent: 02-05-2020 11:31 AM
From: Max Strahan
Subject: Error during export of visual process

I'm currently trying to setup a visual process that has a database source connected to a workspace then 2 exports, however, it keeps failing on the export steps. Here's the error I keep receiving:

The 'SQLNCLI11.1' provider is not registered on the local machine.

Is it referring to my computer or the server and how do I go about fixing this issue?

Thanks

------------------------------
Max Strahan
SQL Developer
------------------------------
"