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

Question

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?

AnatoliiTerentiev · Answer

Could it be the fact that the field names are not correct?  What are the options for finding a solution to the problem? The table and the field of type "geometry", I have created in sql server 2012 managemant studio. The connection have made from the sa.

AnatoliiTerentiev · Answer

I introduced in the x, y- table "events" field, which contains geometry (loc) with the following query :
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 errorFailed 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?

AnatoliiTerentiev · Answer

Thank you! Now I am finding how to create a layer on x,y -table in geodatabase (SQL server)