topic Enable Enterprise Geodatabase doesnt work in ArcGIS Enterprise Questions

Enable Enterprise Geodatabase doesnt work

SebastianBosbach — Mon, 13 Jun 2022 13:40:49 GMT

HI,

I'm unable to enable enterprise geodatabase on an existing MSSQL db.

As the lincense input parameter I tryed the original ecp file of the arcgis server and the keycodes file under "C:\Program Files\ESRI\License10.8\sysgen".

When I run the tool, a file dialog opens to pick a license file.

Then the geoprocess runs and exits withe the error "bad login user".

If I look into the database on the sql server, I can see a lot of tables and procedures created by the geoprocess.

But if I try to connect from ArcGIS Pro to the database I get an error saying table "GDB_Release" not found.

So it seems to me that the license file is causing this errors.

But the arcgis server is licensed an doesn't have an expire date.

The server itself is an ArcGIS Standard server working as a hosting server of the portal on the same machine.

Can anyone help me with my problem?

Thanks Sebastian

Re: Enable Enterprise Geodatabase doesnt work

George_Thompson — Mon, 13 Jun 2022 14:56:53 GMT

What user is the connection file using (SDE / DBO / etc.)?

Did you follow this process; https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/setup-geodatabase-sqlserver.htm#ESRI_SECTION1_0CB5A7EBA7EB4F69AA7180F0FA84779E?

Re: Enable Enterprise Geodatabase doesnt work

Scott_Tansley — Mon, 13 Jun 2022 22:49:33 GMT

Just ruling something out. I once responded to a similar question on these forums and it transpired that the person had a workgroup license for the geodatabase, but was trying to create an Enterprise geodatabase. Just to be sure can you open the ecp file in a text editor and confirm you have a current 'enterprise' GDB license in there please?

Re: Enable Enterprise Geodatabase doesnt work

SebastianBosbach — Tue, 14 Jun 2022 07:22:37 GMT

Hi Scott,

thanks for your Input, I checked the licence and from what I can see, the licence should be fine.

Re: Enable Enterprise Geodatabase doesnt work

SebastianBosbach — Tue, 14 Jun 2022 07:29:47 GMT

Hi George,

the User im using is the owner of the db.

I created the sde schema and set it as the default schema for this user.

The following points I did a screenshot of are all done.

We also did the exact same things on an internal database and tried the "Enable Enterprise Geodatabase" geoprocess, which worked fine.

Re: Enable Enterprise Geodatabase doesnt work

SebastianBosbach — Tue, 14 Jun 2022 07:57:07 GMT

I look into the created database and saw that it should be created correctly.

If I try to connect to it through ArcGIS pro the first time, I get an file dialog, to pick a new "valid" licence.

I input my licence but then get the same error (table GDB_Release not found).

If I look into the sql db I see that the database version is 10.9.

How ever, my arcgis server licence is 10.8. But I also tried creating the enterprise gdb with a 10.9 licence, which also doesn't work.

I don't now if these two have to match or not...

What I also can see in the sql db, is that the licence i provided should be correctly set in the db.

I don't know what I could try anymore...