Our EDN licenses expired on Oct 30th and while I knew this was coming, I did not get to installing our new 2008 licenses until they had timed out on our ArcSDE server(s).
While you can use the ArcSDE Post Install tool to authorize ArcSDE using your new keys, if you have more than a few databases, it’s much faster and easier to apply the license manually. (I have >10) The license information (at least for SQL Server) is stored in the SDE_Server_Config table. Just copy arcsdeserver line of your ECP file (looks something like this: arcsdeserver,92,ecp123457890,30-oct-2008,S0M3H45HTH1NG) into the CHAR_PROP_VALUE column for the AUTH_KEY row. Alternatively you can use this sql: UPDATE SDE_server_configSET char_prop_value = ‘arcsdeserver,92,ecp123457890,30-oct-2008,S0M3H45HTH1NG’
WHERE (prop_name = ‘Auth_Key’) If you have 100′s of databases, get crafty with some T-SQL to iterate over all the databases and run the query…
