ArcMap 10.3 and SQL 2014

[RichardJack-james]

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.

RJ

[JakeSkinner · Accepted solution]

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?

[RichardJack-james]

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

[JakeSkinner]

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:

[RichardJack-james]

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

[ManviLather1]

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?

[RichardJack-james]

This solved the issue. My Arcmap does crash. 

Thanks everyone one for the help. 

[ManviLather1]

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

[RichardJack-james]

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

[ManviLather1]

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