AnsweredAssumed Answered

Cannot create new Desktop geodatabase on SQL EXPRESS 2014

Question asked by valraa on Dec 20, 2018
Latest reply on Jan 7, 2019 by valraa


I downloaded from myesri and installed SQL SERVER EXPRESS 2014 and enabled it spatially (all through the "Database Server Desktop" installer).

I have added some windows logins to my instance and granted them sysadmin privileges (via ArcCatalog).

From one of my sysadmin users I try to create a new Desktop gdb (via right click on the SQL EXPRESS instance in the catalog -> New Geodatabase). ArcMap is 10.4.1.

I named it "test" and then created it leaving all other parameters as defaults.

This is what I see:

However, it can't go on...

I am forced to shutdown ArcMap. I can then reopen ArcMap, see the gdb, but it is corrupted and I cannot use it.

In the server machine where I installed SQL EXPRESS I can go in the logs (C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Log), and here are some rows I see in ERRORLOG. The full log is attached.


2018-12-20 10:42:56.01 spid51      Starting up database 'test'.
2018-12-20 10:42:56.76 spid51      Setting database option RECOVERY to SIMPLE for database 'test'.
2018-12-20 10:43:25.63 spid54      Setting database option READ_COMMITTED_SNAPSHOT to ON for database 'test'.
2018-12-20 10:43:25.69 spid54      Starting up database 'test'.
2018-12-20 10:43:25.91 spid54      Setting database option ALLOW_SNAPSHOT_ISOLATION to ON for database 'test'.
2018-12-20 10:43:44.89 spid54      AppDomain 29 (master.sys[runtime].28) created.
2018-12-20 10:43:47.01 spid33s     AppDomain 29 (master.sys[runtime].28) is marked for unload due to memory pressure.
2018-12-20 10:43:47.01 spid33s     AppDomain 29 (master.sys[runtime].28) unloaded.
2018-12-20 10:44:15.20 spid54      AppDomain 30 (master.sys[runtime].29) created.


Specs of the server machine are:

Any idea how to make it work?