topic Re: Setting User Permission in Data Management Questions

Setting User Permission

SabitaTripathi — Tue, 08 May 2012 23:31:57 GMT

I have added a user with read/write permission in sql server (direct connection). Using the same user account I can create a msd file but I can't publish it to the ArcGIS server. I get an error message regarding the data connection. See the attachement. Any suggestions on how to fix this issue?

[ATTACH=CONFIG]14190[/ATTACH]

Re: Setting User Permission

VinceAngelo — Wed, 09 May 2012 00:36:22 GMT

Please attach graphics in an image format, not in a document format capable of transmitting macro
viruses. Many folks are unwilling or incapable of opening anything but PNG or JPEG attachments.

In fact, you will get more responses if you transcribe the error text as ASCII in the posting window.
The most powerful aspect of Forums like this is the free-text search capability. Posting something
which cannot be searched is often considered a violation of "'netiquette" (it is seen as being unwilling
to share the knowledge you are asking others to provide to you for free) and will result in less interest
in helping with your problem.

Finally, it is highly recommended that you include a complete description of your environment (operating
system, database, and Esri tool version numbers *and* service pack names) in every initial post. Please
help us help you by providing as much relevant information as possible.

- V

Re: Setting User Permission

SabitaTripathi — Wed, 09 May 2012 03:49:23 GMT

Vince, Thank you for the suggestion. I'll keep in mind for the next posting.
I have changed the attachment to image now. I'm using ArcGIS 10, SQL Server 2008 (Direct Connection). What I am trying to do is basically add a user in the database with windows authentication and that user should be able to use the data stored in SQL server and publish it as a map service in ArcGIS server. I am getting a "data connection errors" message when publishing the map to ArcGIS Server. Therefore, I was wondering if there is a proper way to setup a user account and grant read/write permissions in the database.

[ATTACH=CONFIG]14191[/ATTACH]

Re: Setting User Permission

JakeSkinner — Wed, 09 May 2012 12:06:56 GMT

Hi Sabita,

If the owner of the SDE feature class is a windows authenticated user you will need to grant 'View' privileges to the ArcGISSOC user. First, you will need to add the ArcGISSOC user to the SQL Server database. After the ArcGISSOC user is added to the database right-click on the feature classes that you will be publishing to ArcGIS Server > Privileges. Specify the ArcGISSOC user and under VIEW, select 'Grant'. Also, the ArcGISSOC user will need 'Read' privileges to the folder where the SDE connection file (.sde) is stored. The easiest way to ensure this is to copy the SDE connection to the same directory the MXD you are trying publish resides in.

Re: Setting User Permission

SabitaTripathi — Wed, 09 May 2012 16:23:34 GMT

I can connect to the database using the admin account and ArcGISSOC account has been added to the database. But I want to be able to add another user into the database and that user should be able to connect to the db and publish to the ArcGIS Server (say user 200930 in the first image below). Which is where I am getting an error.
[ATTACH=CONFIG]14208[/ATTACH]

This image shows the connection to the database using admin account and if I were to connect as a user 200930; I would like to use windows authentication and be able to publish the data to ArcGIS server.
[ATTACH=CONFIG]14209[/ATTACH]

Re: Setting User Permission

SabitaTripathi — Wed, 09 May 2012 17:49:29 GMT

I can connect to the database using the admin account and ArcGISSOC account has been added to the database. But I want to be able to add another user into the database and that user should be able to connect to the db and publish to the ArcGIS Server (say user 200930 in the first image below). Which is where I am getting an error.
[ATTACH=CONFIG]14211[/ATTACH]

This image shows the connection to the database using admin account and if I were to connect as a user 200930; I would like to use windows authentication and be able to publish the data to ArcGIS server.
[ATTACH=CONFIG]14212[/ATTACH]

Re: Setting User Permission

JakeSkinner — Fri, 11 May 2012 10:23:50 GMT

From the error it looks like the ArcGISSOC user does not have 'View' privileges to the feature class and/or does not have have 'Read' privileges to the SDE connection file. Did you grant 'View' privileges to the ArcGISSOC user? Also, where is your SDE connection file? Are you creating the SDE connection under 'Database Connections'?