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

1072
4
Jump to solution
11-24-2014 09:33 AM
Highlighted
New Contributor III

(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 -

Nancy

Reply
0 Kudos
1 Solution
4 Replies
Highlighted
New Contributor III

Thanks - that did the trick.

Reply
0 Kudos
Highlighted
MVP Esteemed Contributor

SQL Server Express is good for what it is, a free and limited DBMS, but I don't think it will take much to start hitting resource limits in SQL Server Express once you take the 3-connection limitation away.  Depending on your usage, you might want to consider upgrading to SQL Server Standard or Enterprise or even PostgreSQL if cost is an issue for upgrading SQL Server.

Reply
0 Kudos
Highlighted
New Contributor III

You need to keep in mind SQL Express is limited to 10 GB of storage, will only utilize a couple of CPU core and a couple GB of ram. Therefore as you add users and more data you hit the ceiling of what the database is capable of very quickly.

Cheers!

Reply
0 Kudos