1

I'm trying to create a new geodatabase in my local SQLExpress Database Server from ArcCatalog 10.0 (ArcInfo). I can create a database server entry just fine (image below):

enter image description here

ESRI documentation has me convinced that at this stage, I should be able to right-click on that server entry, and select the "Create Geodatabase" option. There is no such option:

enter image description here

It seems a bit like this ArcDesktop 10.0 bug, but following the workaround instructions saw no joy for me. Any ideas on where I can go from here in solving this?

7
  • Do you have permission on the server to do this? you will need create, view & modify permissions for the credentials you're using. May 20, 2014 at 6:00
  • The SQLServer instance runs on on my local machine. I am an administrator for the machine. Running ArcCatalog as administrator does not result in the missing "Create Geodatabase" popup-menu item appearing. May 20, 2014 at 6:03
  • 1
    Local admin does not mean DB admin automatically; I.T. can have admin privileges to a server but still not be able to modify the database unless they're given permissions in the database. Do you need to enter credentials to connect? and was the SQL express version installed from your ArcGis install discs or did you have it there already? May 20, 2014 at 22:33
  • The SQLExpress Server database was set up for me as part of the ArcGIS install. It's possible that this was not done as per the ArcGIS instructions, which might be where my problem is. If they didn't set me up as an administration user, I'm guessing this might be the end result. That's given me a new avenue to look into thanks Michael. May 20, 2014 at 22:44
  • I found instructions for re-starting the SQLServer Express database single-user, and injecting administration credentials, which I've now done. No joy, unfortunately. May 23, 2014 at 1:24

1 Answer 1

3

This problem was solved by:

1) Completely Uninstalling the existing local SQLServer Express Server,

2) Reinstalling SQLServer Express from the ArcDesktop 10.0 install media, following the ESRI-supplied install instructions, then

3) Running the ESRI-supplied patch utility for the known issue between ArcDesktop 10.0 and SQLServer Express around the error message "No ArcSDE Server License Found".

Huge props to Michaeel Miles-Stimson for the avenues to investigate.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.