Setting User Permission

Discussion created by sabitat on May 8, 2012
Latest reply on May 11, 2012 by jskinner-esristaff

Like • Show 0 Likes0
Comment • 6

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]

Attachments

Data Connection.png104.5 KB

Outcomes

6 Replies

vangelo-esristaff May 8, 2012 5:36 PM
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
Like • Show 0 Likes0
Actions
sabitat May 8, 2012 8:49 PM
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]
Attachments
- Data Connection.png106.8 KB
Like • Show 0 Likes0
Actions
jskinner-esristaff May 9, 2012 5:06 AM
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.
Like • Show 0 Likes0
Actions
sabitat May 9, 2012 9:23 AM
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]
Attachments
- Database Connection.png.zip7.6 KB
- SQL Users.png.zip7.6 KB
Like • Show 0 Likes0
Actions
sabitat May 9, 2012 10:49 AM
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]
Attachments
- Database Connection1.png411.7 KB
- Picture1.jpg136.6 KB
Like • Show 0 Likes0
Actions
jskinner-esristaff May 11, 2012 3:23 AM
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'?
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

Setting User Permission

Attachments

Outcomes

Attachments

Attachments

Attachments

Related Content

Recommended Content