You cannot use DBO in the SQL Server Geodatabase when working with Branch Versioning. The ArcSDE Geodatabase Repository must be owne by an user named "SDE", also the data cannot be loaded with the "SDE" user, you need to create a data owner user.
see my community.esri.com blog below.
Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices
read the production mapping database guide books for SQL Server, and download my database template scripts for SQL Server, also read the database connection best practices.
| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |
