I am stumbling along learning about Branch Versioning. At the stage of publishing (Share As Web Layer), I needed to register the datastore. I pulled up Manage Registered Datastores and created a connection to my SQL Server. Doing it that way fails (error 00231).
Workaround: if I push on and try to Share As Web Layer, let the error happen in Analyze, and then in the Options ellipsis for the 00231 error message I select Register Data Source With Server then it works.
In each case, a connection string (that you cannot edit) is displayed. They look like this.
- Created by official documented process, does not work:
SERVER=cc-thesql;INSTANCE=sde:sqlserver:cc-thesql;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=cc-thesql;DATABASE=gis_sandbox;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS
- Responding to error message, works:
SERVER=cc-thesql;INSTANCE=sde:sqlserver:cc-thesql;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=cc-thesql;DATABASE=gis_sandbox;USER=sde;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT
So that's it, a bug in the official workflow and a workaround. Apparently the bug can only create "traditional versioning" connections.
It took me most of the day to figure that out, then I pressed on at 16:45 and found I could not add the new services to my map. That's what I am working through today. I think I have found more bugs in 2.9+10.9 in the last three weeks than any release since ArcMap 8.0.
I'm testing in ArcGIS Pro 2.9, maybe they just added this. I did not work with Branch Versioning before.