Select to view content in your preferred language

SQL Server Identity Provider with Encrypted Passwords

4991
11
09-18-2013 01:08 AM
MatejVrtich1
Occasional Contributor
Hi,

We are migrating AGS security from 10 to 10.2 version.
In AGS 10, we are using SQL Server database with Encrypted passwords (not Hashed) as identity provider.
After setting this SQL Server database as identity provider in AGS 10.2, we are unable to validate passwords and create new users.

This is the User Store Configuration:
{
  "type": "SQL_SERVER",
  "properties": {
    "passwordFormat": "Encrypted",
    "applicationName": "esriags",
    "connectionString": "Data Source={HOSTNAME}\\SQLEXPRESS;Initial Catalog={DBNAME};Integrated Security=SSPI"
  }
}

Creating new user throws this error message:
"You must specify a non-autogenerated machine key to store passwords in the encrypted format. Either specify a different passwordFormat, or change the machineKey configuration to use a non-autogenerated decryption key."

Is there any way how to set machineKey in AGS 10.2?

Thanks,
Matej
Tags (2)
0 Kudos
11 Replies
DanielWalton
Frequent Contributor

No, I believe in order to achieve that you will have to implement a custom provider. In our case all we needed was to be able to validate existing users with encrypted passwords.

RainerHerzog1
Emerging Contributor

ok, in this case it makes sence. Thanks a lot for your help!

Now I know I have to find another approach.

0 Kudos