topic Re: ArcMap 10.3 and SQL 2014 in Data Management Questions

ArcMap 10.3 and SQL 2014

RichardJack-james — Tue, 28 Feb 2017 15:39:28 GMT

I posted a question few weeks back about ArcMap 10.3 crashing when I try to add data from an SQL database.

I was able to update my SQL to management Studio 2014. Recreated my databases from scratch, since I am doing a test bed databases.

I am still encountering the same issue when I drag the data into ArcMap I get a pop-up saying calculating extent, then it crashes. I don't have it connected on a network.

I am currently running ArcMap 10.3 on a VM, using Windows Server 2008 R2

I would appreciate any assistance.

Re: ArcMap 10.3 and SQL 2014

JakeSkinner — Tue, 28 Feb 2017 16:10:49 GMT

Hi RJ,

Sounds like the data you are adding is coming from a database and not a geodatabase. Do you know if this database has been enabled as an enterprise geodatabase?

Re: ArcMap 10.3 and SQL 2014

RichardJack-james — Tue, 28 Feb 2017 16:35:32 GMT

I'm not sure. How do you do that if I may ask?

Re: ArcMap 10.3 and SQL 2014

JakeSkinner — Tue, 28 Feb 2017 18:25:16 GMT

Right-click on the database connection > Properties. If your General tab looks like below, it is a database:

If it looks like the image below, it is a geodatabase:

Re: ArcMap 10.3 and SQL 2014

ManviLather1 — Tue, 28 Feb 2017 19:49:46 GMT

Hello,

There is one more way to check whether you are connected to simple database or enterprise geodatabase.

In Arc catalog -> right click on the database connection -> Check if you can see the "Enable geodatabase" option. If yes then its a "simple database".

Thanks

Re: ArcMap 10.3 and SQL 2014

ManviLather1 — Tue, 28 Feb 2017 20:43:12 GMT

Hello,

Could please confirm the following:

>> What if you try to add the data from file geodatabase? ArcMap crashes?

>> You are working with which user: database authenticated or windows authenticated? Try using some other user and check the behavior.

>>Is this issue is database/geodatabase specific?

>>What if you try to try to create the connection to the database/geodatabase from a different machine?

>>Have you checked the crash dump file.Crash dump can be found at following location:

C:\Users\<username>\AppData\Local\ESRI\ErrorReports

FAQ: Where are the ArcGIS crash dump files saved when an error report is generated?

We have to confirm whether the issue is machine specific, data specific, user specific or database specific.

>>Is SQL server and ArcGIS desktop are present on the same VM or different?

Also, have a look at the below link:

ArcGIS 10.3.x for Desktop system requirements—Help | ArcGIS Desktop

Thanks

Re: ArcMap 10.3 and SQL 2014

RichardJack-james — Tue, 28 Feb 2017 22:06:24 GMT

Yes I do have the enable geodatabase for it to work?

Re: ArcMap 10.3 and SQL 2014

RichardJack-james — Tue, 28 Feb 2017 22:07:11 GMT

It's the first image just a database? How do you make it a geodatabase?

Re: ArcMap 10.3 and SQL 2014

ManviLather1 — Tue, 28 Feb 2017 22:48:59 GMT

Do you want to work with enterprise geodatabase?

If yes, you can refer to the following link:

Enable Enterprise Geodatabase—Help | ArcGIS for Desktop

Privileges for geodatabases in SQL Server—Help | ArcGIS Desktop

But that might not resolve your ArcMap crash issue. Did you get the chance to confirm the things that I suggested in my above post?

Re: ArcMap 10.3 and SQL 2014

RichardJack-james — Tue, 28 Feb 2017 23:04:21 GMT

This solved the issue. My Arcmap does crash.

Thanks everyone one for the help.