ArcMap 10.3 and SQL 2014

780
9
Jump to solution
02-28-2017 07:39 AM
Highlighted
New Contributor II

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

Tags (1)
Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Esri Esteemed Contributor

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?

View solution in original post

Reply
0 Kudos
9 Replies
Highlighted
Esri Esteemed Contributor

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?

View solution in original post

Reply
0 Kudos
Highlighted
New Contributor II

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

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

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:

Highlighted
New Contributor II

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

Reply
0 Kudos
Highlighted
Occasional Contributor

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?

Highlighted
New Contributor II

This solved the issue. My Arcmap does crash. 

Thanks everyone one for the help. 

Highlighted
Occasional Contributor

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

Highlighted
New Contributor II

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

Reply
0 Kudos
Highlighted
Occasional Contributor

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

Reply
0 Kudos