Hi There experts.
I have been using ArcGIS and oracle for the past few years, with no hassles, and have multiple schemas(geodatabases) in Oracle.
Recently we acquired a new customer that uses MS SQL 2012,I have been struggling for the past few days setting up a ArcSDE 10.0 enterprise geodatabase (multiple spatial database).
As a note I am a complete newbie in MS SQL server, and lots of the terms and setups seems strange to me as I have been working with Oracle for the past 10 years.
I have managed to setup the SDE correctly, I can connect to the SDE import, create, add, edit ext.
But I am missing something like roles or user setup or something for my database in MS SQL 2012.
I am able to make the connection and see al my data/tables in MS SQL 2012,but as soon as n select one of my spatial tables(GEOGRAPHY) I get the error message "Failed to edit selected object, Layer not found" .In my sdedc_SQL Server.log I get the following error Cannot Get Access to Instance sde:sqlserver:[Thu May 09 08:50:51 2013] [13] [XXX] Table list query: {call sp_tables}
I have also tried to register the layers through sdelayer -o register -l xxx,GEOMETRY -e a -C GID,USER -t GEOGRAPHY -G 4148 -i sde:sqlserver:XXX,1433 �??D XXX -u XXX -p XXX, But I receive the following error.
Error: Underlying DBMS error (-51).
Error: Could not create a connection.
Extended DBMS error code: -1
Unknown error
No extended error.
The database I am using is an existing database in MS SQL 2012.
Any help would greatly be appreciated.
Thanks in advance.
