nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Vind meer berichten getagd met

Accepted answers

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

All comments

BubbaHey

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

SimonRoss_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

PeterMcDaid

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.

MarkWells

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.

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.

danbecker

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?

SimonRoss_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

danbecker

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!

SimonRoss_User

Bug number for user page hanging is NIM081225

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.