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?

  • Do you have permission on the server to do this? you will need create, view & modify permissions for the credentials you're using. – Michael Stimson May 20 '14 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. – LindsayBradford May 20 '14 at 6:03
  • 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? – Michael Stimson May 20 '14 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. – LindsayBradford May 20 '14 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. – LindsayBradford May 23 '14 at 1:24

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, privacy policy and cookie policy

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