[GIS] ArcGIS Server Error: “Feature service requires a registered database”

Question

I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered database".

When I validate the database registration it appears to succeed, but I still can't publish the service. The features I am publishing are located inside of the geodatabase that I am registering. This geodatabase is located on the same server that ArcGIS Server resides, but I am attempting to publish from another machine. Am I missing some crucial step?

Here is a bigger version of the screenshot.

Answer 1

I'd try some of the following things (in relevance order):

1. Restart ArcMap and try publishing again - the data store might not have been updated for the ArcMap session.
2. When adding the data from a SQL Server Express (under Database Servers), make sure your data path is identical to what you've registered the data store for. I.e., the ".\SQLExpress" is not the same as "servername\SQLExpress" when registering a data store - I remember having this problem myself. I never use the ".\" in the connections > use the machine name both when registering the data store and when establishing the connection to a SQL Server Express instance in the Database Servers section.
3. Make sure as Sunil mentioned that the ArcGIS Server Account has permissions at least to read the data. Double-click Database Servers in the Catalog tree. Right-click the database server containing the geodatabase and click Permissions. Click Add User and add the ArcGIS Server account. Click OK. Double-click the same database server. Right-click the geodatabase, click Administration, then click Permissions. Click the ArcGIS Server account to select it and choose the level of permissions you want it to have.
4. Restart the ArcGIS Server Windows service.
5. Restart the machine.