Attaching sql express database

2035
3
Jump to solution
02-25-2016 10:18 PM
AjitkumarBabar
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;

0 Kudos
1 Solution

Accepted Solutions
AsrujitSengupta
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
AjitkumarBabar
Occasional Contributor II

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

0 Kudos
JayantaPoddar
MVP Esteemed 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



Think Location
AsrujitSengupta
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..