News and Announcements icon

Dynamics 365 CommunityForums Supply chain | Supply Chain Management, Commerce How do I create a prov...

Supply chain | Supply Chain Management, Commerce

Suggested answer

How do I create a provider for an on-prem SQL Server instance?

(0) Share

Report

Report

Posted on by MZ_980

95

Hello,

I'm trying to create a new instance of the SQL Server provider for an on-prem instance. The SQL Server is located on a VM. I see the option to select a data gateway and connection, but I don't have an option to create these. How do I create the data gateway and connection?

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Umesh Pandit 9,261 User Group Leader on at

Like (0)

Report

How do I create a provider for an on-prem SQL Server instance?

Hope you have already followed https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install link, These gateways can be installed in the same server or in the networked server.

Again you have a separate service account and separate servers for UAT/PROD.

In case of any issues please post your question.
Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

How do I create a provider for an on-prem SQL Server instance?

Hi,

I found an official document for you that details how to Install an on-premises data gateway and the minimum requirements, recommendations, and related considerations for installing a gateway. The article is in the link below: Install an on-premises data gateway | Microsoft Learn.

Best regards,

Kevin

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans