topic Re: Database upgrade via python fails requiring Administrator but am using an Admin Connection in Geodatabase Questions

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

JonathanPollack — Fri, 19 Mar 2021 14:58:15 GMT

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?

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

Raj-Chavada — Sat, 20 Mar 2021 02:26:56 GMT

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

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

JonathanPollack — Tue, 23 Mar 2021 14:43:26 GMT

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.