I recently installed ArcSDE in AcrGIS Server 10.0. I added a feature class to my MXD just fine. When I went to publish I get the following error when I try to enable "Feature Access" otherwise it works fine.
Configuration CDA/Sites.MapServer can not be started. Server Object instance creation failed on machine <name>. No Layer or Table was initialized.
From the server logs:
<Msg time='2013-05-09T15:00:02' type='WARNING' code='10801' target='CDA/Sites.MapServer' methodName='MapServer.Connect' machine='' process='5672' thread='7304'>The Layer:'Sites' in Map:'Layers' is invalid. Bad login user</Msg> <Msg time='2013-05-09T15:00:02' type='ERROR' code='17000' target='CDA/Sites.MapServer' methodName='GraphicFeatureServer.Construct' machine=<name>process='5672' thread='7304'>Initialization failed.</Msg> <Msg time='2013-05-09T15:00:02' type='ERROR' code='1016' target='CDA/Sites.MapServer' machine=<name> thread='2864' elapsed='1.21900'>Server Object instance creation failed on machine <name>. No Layer or Table was initialized. </Msg> <Msg time='2013-05-09T15:00:02' type='ERROR' code='1008' target='CDA/Sites.MapServer' thread='7728'>Configuration CDA/Sites.MapServer can not be started.</Msg>
Bad Login User makes me think I have a permissions issue. Does anyone know what I'm doing wrong? Do I have to give ArcGIS Server access to something post-install?
Make sure the ArcGISSOC user has read privileges to your SDE connection file. Also, if you are using Windows Authentication to connect to the database, make sure the ArcGISSOC user is added to the database instance, database, and has read privileges to the feature classes you are trying to publish.
