Enable Enterprise Geodatabase doesnt work

[SebastianBosbach]

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

[George_Thompson]

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

[SebastianBosbach]

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.

[Scott_Tansley]

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?

[SebastianBosbach]

Hi Scott,

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

[SebastianBosbach]

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