topic Cannot edit Feature Service using SQL 2012 RDBMS in ArcGIS Desktop in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/cannot-edit-feature-service-using-sql-2012-rdbms/m-p/313467#M12014 <HTML><HEAD></HEAD><BODY><SPAN>I don't want to sound alarmist, but this has the potential to be a very big problem, and so far things are adding up. </SPAN><BR /><BR /><SPAN>A while back a support tech logged the following bug: </SPAN><A href="http://support.esri.com/en/bugs/nimbus/TklNMDg3ODE5">#NIM087819</A><SPAN style="font-style:italic;"> Feature service shows no editable layer error when the feature class was from workgroup sde (sqlexpress) with OS authentication </SPAN><SPAN>. Looking back on it, that was a 2012 instance (Express).</SPAN><BR /><BR /><SPAN>So now getting SQL Server 2012 Standard up and running (Enterprise) I spent some time with both the SDE/Geodata team and Server Implementation. When editing a feature service with a SQL 2012 RDBMS in you in ArcGIS Desktop receive an error 'no editable workspace'.</SPAN><SPAN style="font-style:italic;"> However,</SPAN><SPAN> when editing via arcgis online, the feature service edits as expected. All permission/privileges have been verified as correct. </SPAN><BR /><BR /><SPAN>This got one of the techs thinking about this bug: </SPAN><A href="http://support.esri.com/en/bugs/nimbus/TklNMDg1MDk2">NIM085096</A><SPAN> </SPAN><SPAN style="font-style:italic;">Uploading mobile edits to an SQL 2012 database fails with Mobile 3.0, 3.1, and 10.1.1 </SPAN><BR /><BR /><SPAN>The correlation here being that both ArcGIS Desktop and Mobile access the data via SOAP, while the ArcGIS online was using the REST endpoint. I'm starting to think that 2 Bugs are indeed related. If there is indeed a bug preventing SOAP based edits and feature services are not going to work for Desktop...then this is a</SPAN><STRONG> big issue.</STRONG><BR /><BR /><SPAN>Searching the web this morning I attempted to gain a little more insight into SOAP and SQL 2012. This subject is generally out of my league, but what i found was very unsettling:</SPAN><BR /><A href="http://vikasrajput.wordpress.com/2012/01/16/sql-server-2012-removed-soaphttp-endpoint/">http://vikasrajput.wordpress.com/2012/01/16/sql-server-2012-removed-soaphttp-endpoint/</A><BR /><A href="http://social.msdn.microsoft.com/Forums/en-US/sqldenengine/thread/c5e75052-3a63-45c7-b234-f4d55dea8b67/">http://social.msdn.microsoft.com/Forums/en-US/sqldenengine/thread/c5e75052-3a63-45c7-b234-f4d55dea8b67/</A><BR /><A href="http://msdn.microsoft.com/en-us/library/cc645577.aspx">http://msdn.microsoft.com/en-us/library/cc645577.aspx</A><BR /><BR /><SPAN>Again, I'm quite ignorant to the means by which server/sde handles the editing transactions so I can only hope the above isn't implying what I think its implying (no fix). Even then, not being able to edit a feature service is a big deal.</SPAN><BR /><BR /><BR /><SPAN>I expect to hear a follow-up on this soon, and will post any additional info I receive.</SPAN></BODY></HTML> Fri, 01 Mar 2013 14:10:36 GMT ZacharyHart 2013-03-01T14:10:36Z Cannot edit Feature Service using SQL 2012 RDBMS in ArcGIS Desktop https://community.esri.com/t5/arcgis-enterprise-questions/cannot-edit-feature-service-using-sql-2012-rdbms/m-p/313467#M12014 <HTML><HEAD></HEAD><BODY><SPAN>I don't want to sound alarmist, but this has the potential to be a very big problem, and so far things are adding up. </SPAN><BR /><BR /><SPAN>A while back a support tech logged the following bug: </SPAN><A href="http://support.esri.com/en/bugs/nimbus/TklNMDg3ODE5">#NIM087819</A><SPAN style="font-style:italic;"> Feature service shows no editable layer error when the feature class was from workgroup sde (sqlexpress) with OS authentication </SPAN><SPAN>. Looking back on it, that was a 2012 instance (Express).</SPAN><BR /><BR /><SPAN>So now getting SQL Server 2012 Standard up and running (Enterprise) I spent some time with both the SDE/Geodata team and Server Implementation. When editing a feature service with a SQL 2012 RDBMS in you in ArcGIS Desktop receive an error 'no editable workspace'.</SPAN><SPAN style="font-style:italic;"> However,</SPAN><SPAN> when editing via arcgis online, the feature service edits as expected. All permission/privileges have been verified as correct. </SPAN><BR /><BR /><SPAN>This got one of the techs thinking about this bug: </SPAN><A href="http://support.esri.com/en/bugs/nimbus/TklNMDg1MDk2">NIM085096</A><SPAN> </SPAN><SPAN style="font-style:italic;">Uploading mobile edits to an SQL 2012 database fails with Mobile 3.0, 3.1, and 10.1.1 </SPAN><BR /><BR /><SPAN>The correlation here being that both ArcGIS Desktop and Mobile access the data via SOAP, while the ArcGIS online was using the REST endpoint. I'm starting to think that 2 Bugs are indeed related. If there is indeed a bug preventing SOAP based edits and feature services are not going to work for Desktop...then this is a</SPAN><STRONG> big issue.</STRONG><BR /><BR /><SPAN>Searching the web this morning I attempted to gain a little more insight into SOAP and SQL 2012. This subject is generally out of my league, but what i found was very unsettling:</SPAN><BR /><A href="http://vikasrajput.wordpress.com/2012/01/16/sql-server-2012-removed-soaphttp-endpoint/">http://vikasrajput.wordpress.com/2012/01/16/sql-server-2012-removed-soaphttp-endpoint/</A><BR /><A href="http://social.msdn.microsoft.com/Forums/en-US/sqldenengine/thread/c5e75052-3a63-45c7-b234-f4d55dea8b67/">http://social.msdn.microsoft.com/Forums/en-US/sqldenengine/thread/c5e75052-3a63-45c7-b234-f4d55dea8b67/</A><BR /><A href="http://msdn.microsoft.com/en-us/library/cc645577.aspx">http://msdn.microsoft.com/en-us/library/cc645577.aspx</A><BR /><BR /><SPAN>Again, I'm quite ignorant to the means by which server/sde handles the editing transactions so I can only hope the above isn't implying what I think its implying (no fix). Even then, not being able to edit a feature service is a big deal.</SPAN><BR /><BR /><BR /><SPAN>I expect to hear a follow-up on this soon, and will post any additional info I receive.</SPAN></BODY></HTML> Fri, 01 Mar 2013 14:10:36 GMT https://community.esri.com/t5/arcgis-enterprise-questions/cannot-edit-feature-service-using-sql-2012-rdbms/m-p/313467#M12014 ZacharyHart 2013-03-01T14:10:36Z