Order of operations to restore SQL SDE after DB upgrade?

[TravisJowell1]

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.

[George_Thompson]

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

[TravisJowell1]

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]

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

Thx George

[George_Thompson]

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...

[TravisJowell1]

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.

[TravisJowell1]

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

[George_Thompson]

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

Report back the results of the 64-bit driver.

[TravisJowell1]

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.

[TravisJowell1]

checking user permissions on server and will get back to you