[GIS] Error accessing spatial database connection with ArcGIS 10

arcgis-10.0enterprise-geodatabase

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

Best Answer

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

Related Question