AnsweredAssumed Answered

Using a 10.0 .NET SQL Server security store in 10.1

Question asked by simon.ross on Aug 10, 2012
Latest reply on Aug 28, 2012 by simon.ross
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

Outcomes