nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Siemens Community Catalyst Program

The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.

Nominate Now

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
------------------------------

Find more posts tagged with

English

Monarch

Accepted answers

Mo Abdolrahim

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
------------------------------
"

All comments

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.

Sample SQL Server Connection for Automator

------------------------------
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

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
------------------------------
"

Mo Abdolrahim

Quick Links

Upcoming Events

Advancing power electronics design with Simcenter PSIM and High-Performance Computing
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Getting Started with Faster Motor Building in Simcenter Simlab
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Practical hybrid solver workflows in Simcenter Feko
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…

View all community events