topic Re: arcgis database owner connection will not allow me to register as versioned SQL 2012 in Data Management Questions https://community.esri.com/t5/data-management-questions/arcgis-database-owner-connection-will-not-allow-me/m-p/186680#M10501 <HTML><HEAD></HEAD><BODY><P class="">Bryan, have you granted create procedure, create view, create table, create function to you data owner user? Also what is the geometry type that you used when you created the data, if you did not use side binary then this could be the problem.</P></BODY></HTML> Sun, 17 Sep 2017 00:18:04 GMT RobertScheitlin__GISP 2017-09-17T00:18:04Z arcgis database owner connection will not allow me to register as versioned SQL 2012 https://community.esri.com/t5/data-management-questions/arcgis-database-owner-connection-will-not-allow-me/m-p/186679#M10500 <HTML><HEAD></HEAD><BODY><P>I have moved sde to new instance of sql server 2012 (same version as it was moved from) and i know the problem is permissions related but am having hard time tracking problem down&nbsp;</P></BODY></HTML> Sat, 16 Sep 2017 20:40:48 GMT https://community.esri.com/t5/data-management-questions/arcgis-database-owner-connection-will-not-allow-me/m-p/186679#M10500 BryanPrice 2017-09-16T20:40:48Z Re: arcgis database owner connection will not allow me to register as versioned SQL 2012 https://community.esri.com/t5/data-management-questions/arcgis-database-owner-connection-will-not-allow-me/m-p/186680#M10501 <HTML><HEAD></HEAD><BODY><P class="">Bryan, have you granted create procedure, create view, create table, create function to you data owner user? Also what is the geometry type that you used when you created the data, if you did not use side binary then this could be the problem.</P></BODY></HTML> Sun, 17 Sep 2017 00:18:04 GMT https://community.esri.com/t5/data-management-questions/arcgis-database-owner-connection-will-not-allow-me/m-p/186680#M10501 RobertScheitlin__GISP 2017-09-17T00:18:04Z Re: arcgis database owner connection will not allow me to register as versioned SQL 2012 https://community.esri.com/t5/data-management-questions/arcgis-database-owner-connection-will-not-allow-me/m-p/186681#M10502 <HTML><HEAD></HEAD><BODY><P>Check the possibility that&nbsp;the login does not have 'sysadmin' server role on the new instance or vice versa.</P><P></P><P>Any login with sysadmin server role granted to it, uses the DBO schema. Other logins use the schema similar to their login names..</P></BODY></HTML> Sun, 17 Sep 2017 05:04:48 GMT https://community.esri.com/t5/data-management-questions/arcgis-database-owner-connection-will-not-allow-me/m-p/186681#M10502 Asrujit_SenGupta 2017-09-17T05:04:48Z Re: arcgis database owner connection will not allow me to register as versioned SQL 2012 https://community.esri.com/t5/data-management-questions/arcgis-database-owner-connection-will-not-allow-me/m-p/186682#M10503 <HTML><HEAD></HEAD><BODY><P>Make sure there are no locks (user) on the dataset(s).&nbsp; This will prevent turning versioning on.</P></BODY></HTML> Thu, 21 Sep 2017 20:51:44 GMT https://community.esri.com/t5/data-management-questions/arcgis-database-owner-connection-will-not-allow-me/m-p/186682#M10503 Anonymous User 2017-09-21T20:51:44Z Re: arcgis database owner connection will not allow me to register as versioned SQL 2012 https://community.esri.com/t5/data-management-questions/arcgis-database-owner-connection-will-not-allow-me/m-p/186683#M10504 <HTML><HEAD></HEAD><BODY><P>Did you get your new machine?</P><P></P><P>Angela VanderPas</P><P>City of Lewiston</P></BODY></HTML> Thu, 21 Sep 2017 21:17:27 GMT https://community.esri.com/t5/data-management-questions/arcgis-database-owner-connection-will-not-allow-me/m-p/186683#M10504 AngelaVanderPas2 2017-09-21T21:17:27Z