I've installed ArcGIS Server 10.1 configuring security on a SQL Server user store (migrating from 10.0)
I used the admin REST to set up SQL Server connection string and everything went fine:
The connection to ArcGIS Server is fine (no error from ArcCatalog UI), but I cannot see any service
I set the log detail to DEBUG and what I have is in the attacched file: it seems that it cannot access the SQL Server user store when using SOAP.
Is there something wrong in my configuration or something I have to do I didn't?
Thanks in advance
I used the admin REST to set up SQL Server connection string and everything went fine:
- I can see and modify all the users and roles in the manager web interface
- I can set services user accessibility in the manager web interface
- I can log-in into the REST services web interface and see all the services the user can access
The connection to ArcGIS Server is fine (no error from ArcCatalog UI), but I cannot see any service
I set the log detail to DEBUG and what I have is in the attacched file: it seems that it cannot access the SQL Server user store when using SOAP.
Is there something wrong in my configuration or something I have to do I didn't?
Thanks in advance
sisal2 is one of the users stored in the membership db and created in the ArcGIS Server manager, its role has grants to access the map service I'm trying to show in ArcMap.
I don't have any problem if I try to access map service via REST protocol.
My guess is that when using SOAP protocol (the one used by ArcMap/Arc Catalog) ther is a problem trying to connect to the db server (I mean something related to ports, protocols, etc.)
Have you tried use IP?
with IP address it's the same, i cannot see any service if I specify username and password
everything works fine in ArcMap/ArcCatalog if I don't specify username and password at all and there are some services configured for anonymous access (I can browse and show them in the map).
There are a few different bugs reported with the legacy MSSQL Security Store work flow. Can you try disconnecting from the security store (just use the built in), update to SP1, and then reconnect to your MSSQL Security Store. This might correct the issue. Thank you very much-
I didn't first install the 10.1 base version.
http://support.esri.com/en/downloads/patches-servicepacks/view/productid/189/metaid/1913#idsp
Also, since you suspect it might be a port issue, please sure the proper ports are open per the following documentation:
http://resources.arcgis.com/en/help/main/10.1/index.html#//015400000537000000
You can run the following command prompt to check:
netstat -an |find /i "listening" > c:\openports.txt