Attaching Wourkgroup Geodatabase

2241
2
09-30-2015 10:55 PM
Highlighted
Occasional Contributor II

I’ve created a database using Ms. SQL Server Express 2014 (its name is “b”), When I try to attach it in ArcMap environment, I get an error (in the screenshot below). However, when I create it directly (by right clicking the Geodatabase Server, and selecting new Geodatabase) everything goes well, and it is created properly.

What might be the issue here; Why I get this error when attaching the database from ArcMap?

Any help is appreciated,

Best Regards,

1- Creation of the Database in SQL Server

Clip_4.jpg

2- Attaching The database in ArcMap

Clip_3.jpg

3- The error Appears! It say that it has accessibility problems

Clip_5.jpg

4- There is no restrictions on access to the "D" drive

Clip_6.jpg

0 Kudos
2 Replies
Highlighted
Esri Frequent Contributor

Hi Hani,

Does the SQL Server Express service account have access to that folder?

I would recommend placing the MDF/Log file in the database location that is specified in the SQL instance.

Move a desktop or workgroup geodatabase—Help | ArcGIS for Desktop

Let us know if that works....

-George

--- George T.
0 Kudos
Highlighted
Occasional Contributor II

Many thanks George for the suggestion, I tried it, but it did not work. Shown below!

Clip_1103.jpg

0 Kudos