topic Re: How to configure existing SQL Server Express database for use with ArcGIS for Server Enterprise in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/how-to-configure-existing-sql-server-express/m-p/738743#M268 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; 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.</P></BODY></HTML> Mon, 24 Nov 2014 19:42:05 GMT JoshuaBixby 2014-11-24T19:42:05Z How to configure existing SQL Server Express database for use with ArcGIS for Server Enterprise https://community.esri.com/t5/geodatabase-questions/how-to-configure-existing-sql-server-express/m-p/738741#M266 <HTML><HEAD></HEAD><BODY><P> (reposting specifically in geodatabase)</P><P></P><P>Hi&nbsp; - 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.</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Thanks -</P><P>Nancy</P></BODY></HTML> Mon, 24 Nov 2014 17:33:11 GMT https://community.esri.com/t5/geodatabase-questions/how-to-configure-existing-sql-server-express/m-p/738741#M266 NancyMilholland 2014-11-24T17:33:11Z Re: How to configure existing SQL Server Express database for use with ArcGIS for Server Enterprise https://community.esri.com/t5/geodatabase-questions/how-to-configure-existing-sql-server-express/m-p/738742#M267 <HTML><HEAD></HEAD><BODY><P>You just need to re-authorize that existing sde geodatabase with the new sde enterprise license.</P><P></P><P><A href="http://blogs.esri.com/esri/supportcenter/2013/06/04/updating-the-license-for-enterprise-geodatabases-at-10-1/" title="http://blogs.esri.com/esri/supportcenter/2013/06/04/updating-the-license-for-enterprise-geodatabases-at-10-1/">http://blogs.esri.com/esri/supportcenter/2013/06/04/updating-the-license-for-enterprise-geodatabases-at-10-1/</A><A href="http://blogs.esri.com/esri/supportcenter/2013/06/04/updating-the-license-for-enterprise-geodatabases-at-10-1/" title="http://blogs.esri.com/esri/supportcenter/2013/06/04/updating-the-license-for-enterprise-geodatabases-at-10-1/">Updating the license for ArcSDE enterprise geodatabases at 10.1 | Support Services Blog</A> </P><P></P><P><A href="http://blogs.esri.com/esri/supportcenter/2012/08/09/how-to-get-an-authorization-file-or-keycodes-file-for-the-new-create-enterprise-geodatabase-tool-at-10-1/" title="http://blogs.esri.com/esri/supportcenter/2012/08/09/how-to-get-an-authorization-file-or-keycodes-file-for-the-new-create-enterprise-geodatabase-tool-at-10-1/">Get Authorization or Keycode File for Create New Geodatabase | Support Services Blog</A> </P></BODY></HTML> Mon, 24 Nov 2014 17:48:07 GMT https://community.esri.com/t5/geodatabase-questions/how-to-configure-existing-sql-server-express/m-p/738742#M267 AsrujitSengupta 2014-11-24T17:48:07Z Re: How to configure existing SQL Server Express database for use with ArcGIS for Server Enterprise https://community.esri.com/t5/geodatabase-questions/how-to-configure-existing-sql-server-express/m-p/738743#M268 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; 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.</P></BODY></HTML> Mon, 24 Nov 2014 19:42:05 GMT https://community.esri.com/t5/geodatabase-questions/how-to-configure-existing-sql-server-express/m-p/738743#M268 JoshuaBixby 2014-11-24T19:42:05Z Re: How to configure existing SQL Server Express database for use with ArcGIS for Server Enterprise https://community.esri.com/t5/geodatabase-questions/how-to-configure-existing-sql-server-express/m-p/738744#M269 <HTML><HEAD></HEAD><BODY><P>Thanks - that did the trick. </P></BODY></HTML> Mon, 24 Nov 2014 21:06:27 GMT https://community.esri.com/t5/geodatabase-questions/how-to-configure-existing-sql-server-express/m-p/738744#M269 NancyMilholland 2014-11-24T21:06:27Z Re: How to configure existing SQL Server Express database for use with ArcGIS for Server Enterprise https://community.esri.com/t5/geodatabase-questions/how-to-configure-existing-sql-server-express/m-p/738745#M270 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>Cheers!</P></BODY></HTML> Fri, 19 Dec 2014 15:32:06 GMT https://community.esri.com/t5/geodatabase-questions/how-to-configure-existing-sql-server-express/m-p/738745#M270 LorneDmitruk 2014-12-19T15:32:06Z