Error accessing spatial database connection with ArcGIS 10

Question

I set up a new SDE database with ArcGIS 10 and everything appeared to go correctly. The service is running and I'm able to view the database in SQL Server.

However, when I try to access the spatial database connection in ArcCatalog 10, I get the following error:

Failed to connection to the specified server. This release of the GeoDatabase is either invalid or out of date. DBMS table not found [Microsoft SQL Server Native Client 10.0: Invalid object name 'sde_mymap.dbo.GDB_Release'.] [sde_mymap.dbo.GDB_Release]

Both ArcSDE and ArcCatalog are version 10.

I checked the sde_setup.log file and I can find no record of that table being created, or any other errors.

Please advise.

Thanks, Seth

Answer 1

Here is how I got around this issue

1. Uninstall ArcSDE
2. Detach all Databases
3. Uninstall SQL Server R2
4. Install SQL Server
5. Install ArcSDE

The issue is this, SQL Server 2008 R2 is not a support DB, as the SQL Server Native Client built into ArcGIS was released prior to the release of R2. Here is a link

http://resources.arcgis.com/content/arcsde/10.0/sql-server-system-requirements

Update: Have you tried making a Direct Connection to your database. This can be done by creating a new Spatial Database Connection in ArcCatalog. Next type the following deatils

Server: leave blank Service: sde:sqlserver: Database: leave blank Please let me know if it works

Sorry for the bad news, CDB

Answer 2

I stumbled on this thread when I ran into a similar GDB_Release table not found issue with ArcSDE 10.2.2 and SQL express. I just wanted to post what worked for me. In my case, simply stopping and starting the database in ArcCatalog fixed it.