topic Re: Registering DB on SQL Express issue in ArcGIS Enterprise Questions

Registering DB on SQL Express issue

BrianBorg1 — Fri, 24 Apr 2015 09:04:05 GMT

On trying to register a geo DB residing on SQL Express 64bit I am getting this error.

The connection property set was missing a required property or the property value was unrecognized. The connection property set was missing a required property or the property value was unrecognized.

I am using SQL express as I need to publish some Feature services on my local machine. Any other alternatives to publish features without using SQL 2008 r2 or any other enterprise level db will be appreciated

Re: Registering DB on SQL Express issue

JakeSkinner — Fri, 24 Apr 2015 12:15:33 GMT

Hi Brian,

Does the ArcGIS Server machine have the SQL Server 64-bit Native Client installed? Also, if the ArcGIS Server site contains a cluster, you will want to make sure each server has the 64-bit Native Client installed.

Re: Registering DB on SQL Express issue

BrianBorg1 — Fri, 24 Apr 2015 14:34:35 GMT

HI Jake,

Thanks for your feedback. We installed the Native client you've suggested but unfortunately to no avail. We are just trying to publish this feature service on a local pc where both sql server and arcgis server are on the this same machine.

Thanks

Re: Registering DB on SQL Express issue

JakeSkinner — Fri, 24 Apr 2015 14:55:30 GMT

Are you connecting to the geodatabase as a Windows Authenticated user? You can change SQL Server to mixed mode authentication if it's not already. Then, try registering the geodatabase by connecting as a database user.