Select to view content in your preferred language

Using a 10.0 .NET SQL Server security store in 10.1

2826
9
Jump to solution
08-10-2012 11:05 AM
SimonRoss_User
Deactivated 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...

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
0 Kudos
1 Solution

Accepted Solutions
SimonRoss_User
Deactivated 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

View solution in original post

0 Kudos
9 Replies
BubbaHey
Deactivated User
Other people have been having same problem. I think there is an error in the documentation.
0 Kudos
SimonRoss_User
Deactivated User
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
0 Kudos
PeterMcDaid
Esri Contributor
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.
0 Kudos
MarkWells
Deactivated User
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.
0 Kudos
SimonRoss_User
Deactivated 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
0 Kudos
danbecker
Frequent Contributor
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?
0 Kudos
SimonRoss_User
Deactivated User
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
0 Kudos
danbecker
Frequent Contributor
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!
0 Kudos
SimonRoss_User
Deactivated User
Bug number for user page hanging is NIM081225
0 Kudos