How to enable feature access for some layers from .mxd document

[AnatoliiTerentiev]

Dear Gurus!
I have .mxd document with 3 kind of layers.
1. topo layers
2. layers with constant information (cities, for example) with need to provide feature access for enabling query
3. layers with dinamic data, wich are changing in real time, for example, table of forest fires.
Can I publish 3 type of services from one .mxd file or I must create 3 .mxd files?
Can you get any reference to understand with this problem?

[JohanCarlsson]

I don't think you're in the right forums.

I think you have to publish them separately but nothing stops you from packaging them as grouplayer and load into your application as different layer types.

[AnatoliiTerentiev]

Thank you!
I am writing a program with using map services and silverlight API 3.1 , so I am on this forum. So as I am publishing this services I ask the same question on the arcgis for server forum too. I thought it was logical to have the opportunity to do service only from a part of the layers of the map document

[AnatoliiTerentiev]

I have registered database from SQL SERVER 2012 (enterprise edition) on arcgis server 10.1. I made layer from x,y-table. When I try publish service with this layer without feature access - all works fine, but when I try to publish service with feature access, then I get an error "Layers data source is not supported (Feature service)". Why?

[DenisT]

I have registered database from SQL SERVER 2012 (enterprise edition) on arcgis server 10.1. I made layer from x,y-table. When I try publish service with this layer without feature access - all works fine, but when I try to publish service with feature access, then I get an error "Layers data source is not supported (Feature service)". Why?

Because there is a restriction - XY event layers are not supported. You need a gdb:
http://resources.arcgis.com/en/help/main/10.1/index.html#//0154000002w8000000

[AnatoliiTerentiev]

Thank you! Now I am finding how to create layer from the x,y-table in gdb (sql server).

[AnatoliiTerentiev]

I introduced in the x, y- table "events" field, which contains geometry (loc) with the following query :
Code:

update events set loc = geometry :: STGeomFromText (concat ('Point (', ltrim (STR (x, 99, 11 )), '', ltrim (STR (y, 99, 11) ) , ')' ) , 28406 );

where srid = 28406 for Pulkovo 1942 Gauss-Kruger zone 6 (took away http://cs2cs.mygeodata.eu/)
And simply drag a table of events from the connection Catalog on the Map. Points layer - appeared .
But in order to publish a layer it's needed to register table in gdb. I am tried from the context menu in the Catalog - Manage -> Register with Geodatabase but get an error

Failed to register with the Geodatabase.

Underlying DBMS error [Microsoft SQL Server Native Client 11.0]: the metadata could not be derermined because statement 'EXEC (@ ececstring) in procedure' sp_renamed 'contains dynamic SQL. Consider using WITH RESULT SETS clause to explicitly describe the result set '

What could be the reason?

[DenisT]

Need to see an entire table creation script.
Also consider creating a thread in the appropriate forum, the question is not related to ArcGIS API for Silverlight.

[AnatoliiTerentiev]

Thank you, I solved the problem. The problem was that I was trying to register the table which was not belong to geodatabase.
I have cloned my table from sql database to geodatabase and after that register it.