Moved from SQL Express 2008 to SQL E 2017 with a clean install.
I have a full back up of the DB available that I restored into the new install and location with the old users but having trouble figuring what tool I need to run to restore it for ArcGIS use.
Right now I can't connect to the old SDE schema with the old admin usr/pw in ArcCatalog to do the enable Enterprise GDB in Catalog.
Once you restore the DB on the new server. You need to make sure that you have all the same users in the SQL instance.
Then you should be able to connect to the SQL Geodatabase from the ArcGIS client.
I downloaded the odbc 22.214.171.124 driver and tried connecting but get the generic 'unable to connect' message. I have 10.6.1 on my laptop. Others have 10.5 or 10.7 Desktop.