AnsweredAssumed Answered

How to configure existing SQL Server Express database for use with ArcGIS for Server Enterprise

Question asked by thurible on Nov 24, 2014
Latest reply on Dec 19, 2014 by ldmitruk

(reposting specifically in geodatabase)


Hi  - we have an existing SQL Server Express (2012) database and instances that were configured as personal with the 3 connection limitation. We now have ArcGIS for Server Enterprise and want to get rid of this limitation.


A look at the registry shows that the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQL$SQLEXPRESS ArcSDE_License key indicates Personal. The dbo..SDE_server_config table AUTH_KEY is consistent.


What steps can be used to upgrade the existing SQL Server Express db/instance personal geodatabase to take advantage of ArcGis Server Enterprise Advanced number of connections. We aren't looking to upgrade to regular SQL Express right now.


Thanks -