Order of operations to restore SQL SDE after DB upgrade?

897
12
06-28-2019 11:20 AM
TravisJowell1
New Contributor III

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.

Tags (3)
0 Kudos
12 Replies
George_Thompson
Esri Frequent Contributor

I would anticipate that you can connect from the Geodatabase machine as it has SQL Server installed. 

--- George T.
0 Kudos
TravisJowell1
New Contributor III

Right. I was checking the DB user had the right permissions to access the schemas.

TravisJowell1
New Contributor III

Can't connect even with a UDL file with the connection info. Digging deeper.

0 Kudos