Publishing With Feature Access - Server Object instance creation failed on machine

Question

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 . No Layer or Table was initialized. From the server logs: The Layer:'Sites' in Map:'Layers' is invalid. Bad login user process='5672' thread='7304'>Initialization failed. thread='2864' elapsed='1.21900'>Server Object instance creation failed on machine . No Layer or Table was initialized. Configuration CDA/Sites.MapServer can not be started. 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? Thanks in Advance!

JordanParfitt · Answer

That did the trick. Thanks.

JakeSkinner · Answer

Hi Jordan,

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.