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

172
4
09-16-2017 01:40 PM
Highlighted
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 

Reply
0 Kudos
4 Replies
Highlighted
MVP Esteemed 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.

Reply
0 Kudos
Highlighted
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..

Reply
0 Kudos
Highlighted
New Contributor III

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

Reply
0 Kudos
Highlighted
New Contributor III

Did you get your new machine?

Angela VanderPas

City of Lewiston

Reply
0 Kudos