topic Re: ArcGIS Pro - SQL Server Database Connection Error in ArcGIS Pro Questions

ArcGIS Pro - SQL Server Database Connection Error

CarbonCounty_Utah — Mon, 06 Jul 2015 14:57:35 GMT

I downloaded ArcGIS Pro and imported an .mxd from ArcMap. All my layers work except for the layers pulling from a SQL Server database. I followed the instructions that show how to create a "New Database Connection" however, every time I try to connect I get the following error. I know that my Authentication is correct because I am using "Operating system authentication", so even though the error says that it could be an issue with user name and password, it isn't. I know the server name is correct because I use the same instance name and properties when connecting to the database in ArcMap.

I'm running:

ArcGIS Pro v. 1.1.0-beta 1 & Microsoft SQL Server 2008 R2

I got the same error with ArcPro version 1.0.2

I tried connecting to MS SQL Server Express Database and got the same error - but I log into these databases just fine through the same credentials using MS SQL Server Management Studio.

Any help would be greatly appreciated! Thanks!

Re: ArcGIS Pro - SQL Server Database Connection Error

AnnieJames — Mon, 06 Jul 2015 18:24:55 GMT

Hi Benjamin,
The last part of the error message '$SDEHOME/temp is full' indicates that the TEMP folder on the server is full.
Please check the 'TEMP' property in the server_config table of the Geodatabase using SQLserver management studio and locate the folder on disk. Try emptying the 'TEMP' folder and retry the connection.

Let me know how it goes.

Thanks,
Annie Sasidar

Re: ArcGIS Pro - SQL Server Database Connection Error

JoshuaBixby — Mon, 06 Jul 2015 18:35:33 GMT

Are ArcGIS Desktop and MS SQL Server Management Studio installed on the same machine as ArcGIS Pro? What operating system are you running? What SQL Server client, specifically, is installed?

Re: ArcGIS Pro - SQL Server Database Connection Error

JeffWard — Mon, 06 Jul 2015 19:45:36 GMT

Every time I get that error it is usually the SQL Server Native Client. There is a copy in the database support files disk if you get the media, or it should be in your downloads list.

Re: ArcGIS Pro - SQL Server Database Connection Error

CarbonCounty_Utah — Fri, 11 Sep 2015 17:56:37 GMT

I just reinstalled SQL Server Native Client 64-bit and then installed ArcGIS Pro 1.1. After that, I was able to connect to SQL Server.