Database user unable to publish service to REST server

[JonathanKelley]

Hi all,

I'm a new database administrator and one of my GIS analysts is unable to publish a map service to our REST server. When he tries, he gets error 00231: Layer's data source must be registered with the server. The confusion I have is because the source is already registered with the server. When I log in to the SDE as a db_admin user, I am able to publish the map service without issue. Is there a particular permission I need to assign his user within our MS SQL database? Currently, he only has SELECT privileges for that layer's dataset. We've had this problem with other services that we've published in the past month, and logging in with a db_admin user has been the workaround we've used each time.

Thanks in advance for any insights the community is able to provide.

Cheers,

Jonathan

[MichaelVolz]

Is the GIS Analyst trying to configure the mapservice to have feature access capability that allows editing of data thru the service?  If so, you might need to provide Edit and Create privileges for this user either with their existing connection or leave the existing read-only connection in place and create a new SDE connection for this user with edit privileges that you would then register with server.