I have a SQL Server Database that I have enabled as an Enterprise Geodatabase 10.5
This enabled fine however it appears that I can only register tables/layers which are held in the dbo schema of the database. I have numerous other spatial tables which are held in other schemas which had been set-up prior to our upgrade to an Enterprise Geodatabase which it appears I cannot register with the Geodatabase as the option is greyed out when I right click on the layer in ArcCatalog 10.5.
I really don't want to transfer these tables to the dbo schema if I can avoid it. Can anyone advise how I can register these spatial tables with the Enterprise Geodatabase?
You will need to connect as the data owner. For example, I have a table owned by vector called XY in a GIS geodatabase:
I will need to connect as the user 'vector' in order to register this table with the geodatabase.
Ok thanks. I would have thought connecting to the database as the database administrator through ArcCatalog would give me the power to register whatever layer I wanted to with Geodatabase regardless what schema the table/layer is in? This does seem a bit illogical to say the least! This means now I have to create users for all of the schemas I have in the database which seems allot of work in order to complete a simple task!