SDE Database

ShannonSmith · ‎10-22-2015

I recovered a SQL arcsde database from a year ago so that i can retrieve some information from it. In the last year we have updated SDE from 10.0 to 10.3. I can see my database with no problems in SQL but when i try to connect to it in arccatalog i get the following error message. Failed to connect to database. No ArcGIS server license found. How do i give it the server license. i have tried the Enable Enterprise Geodatbase toolbox and it does not like the database connection.

JakeSkinner · ‎10-22-2015

Hi Shannon,

You will want to connect to the geodatabase as the owner of the SDE repository. For example, if the repository is owned by the user 'SDE', make your connection with this user. You should then be presented with a pop-up requesting a license file.

You can then specify an ECP or PRVC file. If you do not have these, but have ArcGIS Server installed on a server, browse to the C:\Program Files\ESRI\License10.3\sysgen folder on that server and choose the keycodes file located there.

View solution in original post

JakeSkinner · ‎10-22-2015

Hi Shannon,

You will want to connect to the geodatabase as the owner of the SDE repository. For example, if the repository is owned by the user 'SDE', make your connection with this user. You should then be presented with a pop-up requesting a license file.

You can then specify an ECP or PRVC file. If you do not have these, but have ArcGIS Server installed on a server, browse to the C:\Program Files\ESRI\License10.3\sysgen folder on that server and choose the keycodes file located there.

ShannonSmith · ‎10-22-2015

Thank you thank you. I was connected not as 'SDE' user and as soon as i did that, bam. it all works like magic. I am so grateful for your help!!

ChrisDonohue__GISP · ‎10-22-2015

Adding some ESRI folks knowledgeable in Enterprise Geodatabases (SDE) in case they have ideas to add:

Asrujit SenGupta

Jake Skinner

Vince Angelo

EDIT - Jake replied while I was typing this up

Chris Donohue, GISP