Select to view content in your preferred language

Enable Enterprise Geodatabase doesnt work

1820
5
06-13-2022 06:11 AM
SebastianBosbach
Occasional Contributor

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

Tags (1)
0 Kudos
5 Replies
George_Thompson
Esri Notable Contributor

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

--- George T.
0 Kudos
SebastianBosbach
Occasional Contributor

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.

SebastianBosbach_1-1655191576240.png

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

 

0 Kudos
Scott_Tansley
MVP Regular Contributor

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?

Scott Tansley
https://www.linkedin.com/in/scotttansley/
0 Kudos
SebastianBosbach
Occasional Contributor

Hi Scott,

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

SebastianBosbach_0-1655191318394.png

 

0 Kudos
SebastianBosbach
Occasional Contributor

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.

SebastianBosbach_0-1655193097490.png

 

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.

SebastianBosbach_1-1655193279638.png

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

0 Kudos