topic add ArcGIS Server User connection and sql server identity store in ArcGIS Enterprise Questions

add ArcGIS Server User connection and sql server identity store

GerardoGarcia — Thu, 14 Mar 2013 11:41:50 GMT

We have windows server 2012 std hosting ArcGIS for Server 10.1 sp1 with clients running Win 7 Pro with ArcGIS for Desktop 10.1. In ArcGIS for Server, I've configured security to use the sql server identity store using the admin/rest site to update via json.

Now, when I try to "Add ArcGIS Server" connection in ArcCatalog using a valid user of a role type of "User", it will authenticate, but nothing will appear in ArcCatalog. I've verified that the user is associated with the correct role that's used for securing folders/services, but still nothing.

    I've even used fiddler to track http error messages. This is what I got from Tomcat (Response):
====================
    HTTP Status 400 -
    type Status report
    message
    description The request sent by the client was syntactically incorrect ().
====================

    My header request was:
====================
    POST http://gisdev1:6080/arcgis/services?...lhi7j-gZJTsO0f HTTP/1.1
    Accept: */*
    Content-Type: text/xml
    SOAPAction: ""
    Referer: http://www.esri.com/A99CFE30-BD5B-4A...3-984BCBF84E93
    User-Agent: ArcGIS Client Using WinInet
    Host: gisdev1:6080
    Content-Length: 332
    Connection: Keep-Alive
    Pragma: no-cache

    <?xml version="1.0" encoding="utf-8" ?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://www.esri.com/schemas/ArcGIS/10.1"><soap:Body><tns:GetFolders></tns:GetFolders></soap:Body></soap:Envelope>
    ====================

    Can anybody tell me what's going on or what I'm doing wrong? Thanks for any help.

Re: add ArcGIS Server User connection and sql server identity store

BubbaHey — Tue, 19 Mar 2013 13:33:44 GMT

Check that this bug does not apply.

NIM085535
http://support.esri.com/en/bugs/nimbus/TklNMDg1NTM1

Synopsis
Server Directory containing upper case characters in the name is not recognized in ArcGIS Server 10.1

Alternate Solution
Ensure the name of the Virtual Directory(Server Directory) contain only lower case characters.

Re: add ArcGIS Server User connection and sql server identity store

nicogis — Tue, 19 Mar 2013 16:16:52 GMT

Have you same problem in service directory?

see Bug NIM-086160 http://support.esri.com/en/bugs/nimbus/role/beta10_1/TklNMDg2MTYw

Re: add ArcGIS Server User connection and sql server identity store

GerardoGarcia — Wed, 20 Mar 2013 13:33:17 GMT

Thanks for your help and responses guys.

Domenico, that bug synopsis seems to state the same problem I'm having. Too bad it's resolved in 10.2; we just upgraded to 10.1. 😞
However, let me explain a bit further:

With the setup I initially posted in this thread, users of "User" type are the only ones that cannot see services. "Administrator" or "Publisher" type users from a SQL Identity store can see. However, when I revert back to arcgis server built-in security, the user type can see services as expected.

Again, thanks Bubba and Domenico for your help and responses. Let me know if you have any questions or if my additional details spawn any other questions/comments.

jerry

Re: add ArcGIS Server User connection and sql server identity store

nicogis — Wed, 20 Mar 2013 14:48:10 GMT

seems same problem this thread: http://forums.arcgis.com/threads/77403-SQL-Server-user-store-fails-from-ArcCatalog

Re: add ArcGIS Server User connection and sql server identity store

GerardoGarcia — Wed, 20 Mar 2013 15:47:21 GMT

Exactly! Oh well, I guess I'm stuck not using sql server identity store.

Thanks for your help.

jerry