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.
I would anticipate that you can connect from the Geodatabase machine as it has SQL Server installed.
Right. I was checking the DB user had the right permissions to access the schemas.
Can't connect even with a UDL file with the connection info. Digging deeper.