SQL Server user store fails from ArcCatalog

[deleted-user-pYdfRjvSAbTJ]

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:

• 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

But I have a problem: I cannot access any service from ArcCatalog.
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

[nicogis]

do you use Integrated Security? who is the user sisal2? what do you see via fiddler?

[deleted-user-pYdfRjvSAbTJ]

SQL Server connection authentication doesn't use integrated security, it's another server, so it uses SQL Server security: there is a specific user that is configured to access the membership DB from ArcGIS Server.
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.)

[nicogis]

when you connect from arccatalog you use web_adaptor or gis_server?
Have you tried use IP?

[deleted-user-pYdfRjvSAbTJ]

we use web adaptor with ssl, because is the only way to avoid ssl certificate warning message from ArcMap.
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).

[JustinRodriguez]

Hello,
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-

[deleted-user-pYdfRjvSAbTJ]

I forgot to mention that I've installed the ArcGIS Server 10.1 SP1 (10.11 version).
I didn't first install the 10.1 base version.

[EynarGallegos]

There were some initial bugs logged for using an Existing SQL Db from 10.0 but since then have been resolved with SP1. Can you verify sp1 is installed for Server by running the patch utility finder on your GIS Server? See link below:

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

[nicogis]

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