Using a 10.0 .NET SQL Server security store in 10.1

SimonRoss_User

We're trying to connect to our previous 10.0 Security Store following the instructions here

http://resources.arcgis.com/en/help/main/10.1/index.html#/Using_a_10_0_NET_SQL_Server_security_store/0154000005pn000000/

We've moved the sql database onto the same machine running Server 10.1 and the natemtping to change the identitstore connection. Have tried multiple permutations of the JSON strings proposed on the help page but keep geting the same error message every time for which I find no reference in the help

The connection name 'SQLConnString' was not found in the applications configuration or the connection string is empty.

Can someone confirm whether they've had success with this connection syntax?
What is the correct syntax for a locally hosted SQL instance?
Any specific permissions that need to be granted on the database (e.g. which users should have access)?
any help appreciated
Thanks

Simon

SimonRoss_User

http://support.esri.com/en/bugs/nimbus/TklNMDgwODM2

1. Stop the ArcGIS Server service
2. Copy 'javaw.exe.config' from : C:\Program Files\ArcGIS\server\framework\runtime\jre\bin\
3. Paste into: C:\Program Files\ArcGIS\server\bin
4. Rename 'javaw.exe.config' to 'ArcSOC.exe.config'
5. Start ArcGIS Server service.

It should now work.

That does work (as ESRI support managed to tell me about an hour before you did!).  Unfortunately we still experienced another error after making this change.  Specifally covered by another bug with another workaround

http://support.esri.com/en/bugs/nimbus/role/beta10_1/TklNMDgxMjI1

good news is that both bugs are fixed at 10.1 SP1

If you still have issues you should be aware of a third bug that shows the connection is successful when it isn't.  Unfortunately I can't find the reference for the quoted bug NIM084058

Thanks for support from all