Attaching sql express database

1874
3
Jump to solution
02-25-2016 10:18 PM
Highlighted
Occasional Contributor II

Hello,

I am using ArcGIS 10.4. I am trying to attach sql express .mdf file in sql express database server. When I right click on sql database server in ArcCatalog I am not getting attach option. Earlier I used to attach in ArcMap 10.2.2.

Kindly see the attachment;

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Regular Contributor III

Most likely a Permission issue. As you don't seem to get even the "Create Geodatabase" option..

Grant your Windows Login 'sysadmin' server role from SQL Server end and then try..

View solution in original post

3 Replies
Highlighted
Occasional Contributor II

I tried using both sql server 2008 and 2012, but got the same result.

Reply
0 Kudos
Highlighted
Honored Contributor

Hi Ajit,

SQL Server 2012 SP1 is the minimum requirement for ArcGIS 10.4. Check the link for more details.

https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-sqlserver.htm

Highlighted
Regular Contributor III

Most likely a Permission issue. As you don't seem to get even the "Create Geodatabase" option..

Grant your Windows Login 'sysadmin' server role from SQL Server end and then try..

View solution in original post