Order of operations to restore SQL SDE after DB upgrade?

376
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

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.

https://support.esri.com/en/technical-article/000008079

Then you should be able to connect to the SQL Geodatabase from the ArcGIS client.

Geodatabase

--- George T.
TravisJowell1
New Contributor III

You answered the question I didn't even know I asked. Just now noticed all the users migrated don't have logins.

Will try this.

thx

TravisJowell1
New Contributor III

Ran those SQL queries and can connect locally now. Trying to figure out the odbc drivers needed for our client machines now.

Thx George

0 Kudos
George_Thompson
Esri Frequent Contributor

What version of ArcGIS clients are being used?

Take a look here for a cheat sheet; https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-sqlserver.htm#ESRI_SE...

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

I downloaded the odbc 17.3.1.1 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.

0 Kudos
TravisJowell1
New Contributor III

I can't install the 32 bit driver for some reason on Windows 10...

0 Kudos
George_Thompson
Esri Frequent Contributor

I would install the 64-bit regardless of the O/S bit level.

Report back the results of the 64-bit driver.

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

I did that first. Getting the generic 'cannot connect' error from catalog.

On the SDE host I connect with same credentials and it works fine.

0 Kudos
TravisJowell1
New Contributor III

checking user permissions on server and will get back to you

0 Kudos