question

SaimonNajashi-6397 avatar image
0 Votes"
SaimonNajashi-6397 asked GeethaThatipatri-MSFT commented

Difference between Azure Arc Server with SQL Server extension and Azure Arc SQL Server

I want to onboard(normal) Servers and SQL Servers to Azure Arc.
I see two Possibilities to do that:

Onboard all servers as Azure Arc Servers (Powershell Script) and install the SQL Server extension on those Servers that are SQL Servers.
Onboard the normal Servers as Azure Arc Servers (Powershell script) and onboard the SQL Servers as SQL Servers (with a different Powershell script). Both Powershell scripts come from the Azure Portal and are generated whenever you click the Add button on either Servers, or SQL Servers.

My questions are:

What is the difference between those two methods?
Why are all servers, no matter which methods I've used only showing up as Servers, but not as SQL Servers in the Azure Portal?


azure-sql-databaseazure-arc
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

GeethaThatipatri-MSFT avatar image
0 Votes"
GeethaThatipatri-MSFT answered GeethaThatipatri-MSFT commented

Hi, @SaimonNajashi-6397 Welcome to the Microsoft Q&A forum, and thanks for reaching out.

Azure Arc-enabled servers let you manage Windows and Linux physical servers and virtual machines hosted outside of Azure, on your corporate network, or another cloud provider. With SQL Server extension on top of Azure -Arc server, let you manage SQL Server instances from Azure. In order for SQL Server arc enabled, the server must be arc enabled at first.

  1. If the server is not hosting SQL Server, you will just arc enable your server. Plan and deploy Azure Arc-enabled servers - Azure Arc | Microsoft Docs

  2. If the server also hosting SQL Server, there are multiple ways you can arc enable your SQL Server.
    a. If the Server is already Arc enabled by using step#1, then you can simply register the SQL Server extension. Go to Server -Arc resource \Settings \Extensions \Add “SQL Server Extension -Azure Arc”. This will install SQL Server Arc extension and start managing SQL Server from Azure.
    b. If you need to register several SQL Servers on Arc connected servers, you can also register SQL Server at scale using Azure Policy Connect SQL Servers on Azure Arc-enabled servers at scale | Microsoft Docs

  3. If the server hosting SQL Server, but not arc enabled yet, then you can use the method directly:Connect your SQL Server to Azure Arc | Microsoft Docs This method first enable Arc -server under the hood and register SQL Server.

Please let me know if the information is helpful.

Regards
Geetha



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, @SaimonNajashi-6397 We haven't heard back from you, Please let me know if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha

0 Votes 0 ·