topic Re: Can't Create Geodatabase on SQL Server Express in Data Management Questions

Can't Create Geodatabase on SQL Server Express

SerkanOrnek — Tue, 05 Aug 2014 09:03:42 GMT

Hello,

We are using ArcGIS for Desktop 10.1 and we want to create a geodatabase on a SQL Server Express. We used the setup supplied with the ArcGIS 10.1 DVD. We created a SQL Server (2008 R2 Express edition) and enabled it to store geodatabases, and added this server to Database Servers in ArcCatalog. But when we want to create a new geodatabase on this server it gives an error and says "Error creating this geodatabase Operation Failed". I found the log file in the temp folder (sde_setup.log), and there is an error in creating STATE_LINEAGES table and an error code of -38. Every table before this created succesfully. I couldn't find any information about this error on the internet. Log file and screen capture of error attached to this post. Waiting for your response.

Thanks.

Re: Can't Create Geodatabase on SQL Server Express

nicogis — Tue, 05 Aug 2014 10:17:49 GMT

Can you check this one:

Start ArcMap, open the Catalog window, then expand the Database Servers folder in the Catalog tree.

Right-click the database server and click Properties.
Product name should say Microsoft SQL Server Express Edition with Advanced Services. If instead it says Microsoft SQL Server Express Edition, you must install a SQL Server Express instance that includes Advanced Services

Re: Can't Create Geodatabase on SQL Server Express

SerkanOrnek — Tue, 05 Aug 2014 10:23:23 GMT

It says Microsoft SQL Server Express Edition with Advanced Services (64 Bit)

Re: Can't Create Geodatabase on SQL Server Express

nicogis — Tue, 05 Aug 2014 11:17:02 GMT

Have you installed in sql express Full-Text Search?

Re: Can't Create Geodatabase on SQL Server Express

SerkanOrnek — Tue, 05 Aug 2014 11:19:47 GMT

Yes i did

Re: Can't Create Geodatabase on SQL Server Express

nicogis — Tue, 05 Aug 2014 11:26:19 GMT

have you follow these step: SQL Server Express for Desktop 10.2.1 or Engine 10.2.1 Installation Guide - Enabling SQL Server Express to store desktop…‌ ?

-can you upgrade 10.1 sp1 and sql express 2008 r2 sp2?

Re: Can't Create Geodatabase on SQL Server Express

SerkanOrnek — Tue, 05 Aug 2014 12:14:49 GMT

I tried with ArcGIS 10.1, SP1 and 10.2.2, but I didn't try with sql express sp2. I'll download it and let you know if it works or not

Re: Can't Create Geodatabase on SQL Server Express

AsrujitSengupta — Tue, 05 Aug 2014 17:12:49 GMT

By any chance, is your Sql Server instance set to a collation of either Azeri_Latin_100_CI_AS or Azeri_Cyrillic_100_CI_AS?

Beginning with ArcSDE 9.2, case sensitive collation is not supported at SQL Server instance and database level, which means the database collation must be case insensitive.

What is the name you are using for creating the geodatabase?

Re: Can't Create Geodatabase on SQL Server Express

SerkanOrnek — Wed, 06 Aug 2014 05:20:42 GMT

same error with sp2

Re: Can't Create Geodatabase on SQL Server Express

SerkanOrnek — Wed, 06 Aug 2014 05:23:28 GMT

Collation set to TURKISH_CI_AS, I tried with TURKISH_CI_AI also but none of them solved the problem. Server name is TEOSSQLSERVER and for geodatabase name I put GDB or TEOSGDB.

Re: Can't Create Geodatabase on SQL Server Express

HalilKahraman — Mon, 06 Nov 2017 13:09:18 GMT

Database Collation must be Latin1_General_CI_AS.

If not, please follow these steps:

1. By using SQL Server Management Studio, in Object Explorer, connect to an instance of the SQL Server Database Engine, expand that instance, and then expand Databases.
2. Right-click Databases,select New Database, write the Database Name (for example, "GDB"), click the Options page, and select "Latin1_General_CI_AS" collation from the Collation drop-down list.
3. After you are finished, click OK.

4. Go to ArcMap/ArcCatalog application. From toolbox, select Geodatabase Administration/Create Enterprise Geodatabase tool, write the database name that you created before (in our example, "GDB") to the Database (Optional) box in Create Enterprise Geodatabase pane.

5. Do not check Sde Owned Schema checkbox. (Sde Owned Schema parameter is only active for SQL Server. If you use SQL Server Express database, you have to uncheck Sde Owned Schema checkbox.) For more information; Link1, Link2

5. Fill the other boxes with the appropriate data, click OK.

You will see the successfull geodatabase creation.

Re: Can't Create Geodatabase on SQL Server Express

VyacheslavShymanovskyi — Wed, 07 Mar 2018 22:32:38 GMT

thanks for guidelines, should it be no need to install ArcSDE to create geodabase on SQL Express server, correct?

Re: Can't Create Geodatabase on SQL Server Express

TinaMorgan1 — Wed, 07 Mar 2018 23:50:40 GMT

There is no installation for ArcSDE starting at 10.1.

Re: Can't Create Geodatabase on SQL Server Express

Asrujit_SenGupta — Thu, 08 Mar 2018 06:32:32 GMT

You will need the SDE setup, only if you are working with ArcSDE Personal geodatabase (Desktop Geodatabase) or ArcSDE Workgroup geodatabases. You will need to enable the SQL Server Express instance, using these setups before creating the Geodatabase.

However, if you want to create an Enterprise Geodatabase on a SQL Server Express instance, there is no setup for ArcSDE in that case, and this can be done from the Client interface (ArcGIS Desktop\ArcGIS Pro).

Re: Can't Create Geodatabase on SQL Server Express

VyacheslavShymanovskyi — Thu, 08 Mar 2018 22:43:11 GMT

yes, no ArcSDE and that is why I slightly confused. I can't check now SQL Express configuration follow and advise above as it was installed by other.
I have only ArcGIS Desktop license and pre-installed SQL Express 13 but get error when creating Enterprise Geodatabase on a SQL Server Express, hope no other software I need to make it, even Database Server (Desktop) available in MyEsri account.