topic Re: Using a 10.0 .NET SQL Server security store in 10.1 in ArcGIS Enterprise Questions

Using a 10.0 .NET SQL Server security store in 10.1

SimonRoss_User — Fri, 10 Aug 2012 18:05:29 GMT

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

Re: Using a 10.0 .NET SQL Server security store in 10.1

BubbaHey — Tue, 21 Aug 2012 15:45:12 GMT

Other people have been having same problem. I think there is an error in the documentation.

Re: Using a 10.0 .NET SQL Server security store in 10.1

SimonRoss_User — Tue, 21 Aug 2012 19:19:19 GMT

Glad to hear I'm not the only one. I'm working through it with ESRI support at the moment and will post a resolution when we find one.
Cheers

Simon

Re: Using a 10.0 .NET SQL Server security store in 10.1

PeterMcDaid — Thu, 23 Aug 2012 15:07:09 GMT

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.

Re: Using a 10.0 .NET SQL Server security store in 10.1

MarkWells — Thu, 23 Aug 2012 15:09:08 GMT

This is a bug, which according to its status will be fixed in SP1.
http://support.esri.com/en/bugs/nimbus/TklNMDgwODM2

Until SP1 is released you can perform this workaround:

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.

Re: Using a 10.0 .NET SQL Server security store in 10.1

SimonRoss_User — Fri, 24 Aug 2012 00:09:43 GMT

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

Re: Using a 10.0 .NET SQL Server security store in 10.1

danbecker — Tue, 28 Aug 2012 18:51:54 GMT

was able to get 'connection successful' after c/p the file mentioned above, and I can view the roles in /manager, but I cannot view users? the loading bar just spins.

Is this the bug 'successful connection' when the string is actually wrong?

Re: Using a 10.0 .NET SQL Server security store in 10.1

SimonRoss_User — Tue, 28 Aug 2012 18:54:12 GMT

was able to get 'connection successful' after c/p the file mentioned above, and I can view the roles in /manager, but I cannot view users? the loading bar just spins.

Is this the bug 'successful connection' when the string is actually wrong?

No, this is this bug

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

Re: Using a 10.0 .NET SQL Server security store in 10.1

danbecker — Tue, 28 Aug 2012 19:14:55 GMT

No, this is this bug

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

can you post the bug number? for some reason I can't login to the above link, i get the revolving login screen. thanks!

Re: Using a 10.0 .NET SQL Server security store in 10.1

SimonRoss_User — Tue, 28 Aug 2012 19:37:25 GMT

Bug number for user page hanging is NIM081225