arcgis database owner connection will not allow me to register as versioned SQL 2012

09-16-2017 01:40 PM
New Contributor III

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 

0 Kudos
4 Replies
MVP Legendary Contributor

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.

0 Kudos
MVP Regular Contributor

Check the possibility that the login does not have 'sysadmin' server role on the new instance or vice versa.

Any login with sysadmin server role granted to it, uses the DBO schema. Other logins use the schema similar to their login names..

0 Kudos
by Anonymous User
Not applicable

Make sure there are no locks (user) on the dataset(s).  This will prevent turning versioning on.

0 Kudos
New Contributor III

Did you get your new machine?

Angela VanderPas

City of Lewiston

0 Kudos