topic Re: Can I connect SQL server 2022 with ArcGIS Enterprise 10.8.1? in ArcGIS Enterprise Questions

Can I connect SQL server 2022 with ArcGIS Enterprise 10.8.1?

sahook1 — Mon, 23 Sep 2024 14:54:43 GMT

Hi Everyone,

I am planning to migrate SQL server from 2014 to 2022 and connect with our existing Enterprise 10.8.1.

Let me know the challenges in this workflow please

Can anyone post here if its already done by someone ?

Thanks in advance.

Re: Can I connect SQL server 2022 with ArcGIS Enterprise 10.8.1?

George_Thompson — Wed, 25 Sep 2024 18:25:18 GMT

It looks like it is not certified for that combination; https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-sqlserver.htm

With that being said, it "may" work but you more than likely will hit some issues and when contacting support they will be limited.

Are you planning of moving to 10.9.1 or newer version in the future?

10.8.1 is now in Mature support.....https://support.esri.com/en-us/products/arcgis-enterprise/life-cycle

Re: Can I connect SQL server 2022 with ArcGIS Enterprise 10.8.1?

sahook1 — Mon, 23 Sep 2024 15:24:46 GMT

Hi @George_Thompson ,

Thanks for your ans.

Yes the upgrade to 10.9.1 & 11 in-line and just wanted to understand if there will be any blackout period or it will work fine until the enterprise upgrade to 10.9.1.

The issue is I have 2014 SQL server with enterprise 10.8.1 and if I move the enterprise 10.9.1 then it is not supporting 2014 SQL.

And if I move the database first to SQL 2022 then 10.8.1 is also not supporting.

Searching for a workaround to support both 2022 SQL server and 10.8.1 for at-least 15 days.

Re: Can I connect SQL server 2022 with ArcGIS Enterprise 10.8.1?

George_Thompson — Mon, 23 Sep 2024 15:28:29 GMT

Got it..... hard to give definitive response but upgrading to SQL 2022 "should" work for that gap time.......

I would target 10.9.1 then to 11.3.....

Re: Can I connect SQL server 2022 with ArcGIS Enterprise 10.8.1?

sahook1 — Wed, 25 Sep 2024 14:10:11 GMT

@George_Thompson Hi George,

I am thinking to use the SQL 2022 in compatibility mode of 2019 and connect with Enterprise 10.8.1.

Any thoughts on this?

Re: Can I connect SQL server 2022 with ArcGIS Enterprise 10.8.1?

George_Thompson — Wed, 25 Sep 2024 16:20:14 GMT

Again, this may work but there could be unintended consequences. I am not aware of anything but there is a level of risk.