SQL Server Identity Provider with Encrypted Passwords

4634
11
09-18-2013 01:08 AM
MatejVrtich1
New Contributor III
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
Occasional 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
New Contributor II

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

Now I know I have to find another approach.

0 Kudos