Database upgrade via python fails requiring Administrator but am using an Admin Connection

538
2
03-19-2021 07:58 AM
Labels (1)
JonathanPollack
Occasional Contributor

I am trying to upgrade a bunch of databases via Python.  I am using the following command...

arcpy.UpgradeGDB_management(d_conn"PREREQUISITE_CHECK""UPGRADE")
 
I get an error saying the connection must be administrator.  "d_conn" is an admin connection.
 
The same command works when I run it in ArcPro.  What am I doing wrong?
0 Kudos
2 Replies
Raj-Chavada
New Contributor III

Difficult to pinpoint the root cause of your issue without details. Is this sql server or oracle? It could be insufficient permission of your admin account ? Are there any users connected? Have you tried upgrading the EGDB via ArcGIS Pro using GP tools using this same account? 

 

Have you reviewed documentaction here -https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/upgrade-geodatabase.htm

0 Kudos
JonathanPollack
Occasional Contributor

Thanks, am using SQL Server.  The exact same account (database connection) works in Pro using GP tools.  I actually copied the python command from Pro and pasted it into my Python script.  No users are connected.

0 Kudos