English

Error: Making a connection to a restored SQL Server Enterprise Geodatabase - ERROR in obtaining connection id. Error: -37

Error Message

Making a direct connect to a recently restored geodatabase results in the following error within the client direct connect log files.

Instance initialized . . .[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME] SDE DBMS Error: 208 Microsoft SQL Server Native Client 10.0: Invalid object name 'OPTGIS.dbo.SDE_object_ids'.

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME] ERROR in ontaining connection id.

Error: -37

DBMS error code: 208

Microsoft SQL Server Native Client 10.0: Invalid object name 'DATABASE.OWNER.SDE_object_ids'.



[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME] Couldn't initialize shared memory, error = -37.

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME] Cannot Attach to Shared Memory -1

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME] In DB_close_instance...

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME] SDE DBMS Error: 208 Microsoft SQL Server Native Client 10.0: Invalid object name 'DATABASE.OWNER.SDE_process_information'.

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME]

Describe Cache...

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME]

Cache Size............................. 200

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME]

Number of Table Objects Cached (0)

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME]

Number of Selects Cached (0)

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME]

Number of Joins Cached (DBMS-described) (0)

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME]

Cached Cached

Hits Statements

---------------------

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME]

[Tue Dec 18 11:34:22 2012] [0] [SERVER_NAME] SELECT's DBMS Described: [0][0]

Cause

Databases cannot be restored using a different name than the original database name when the ArcSDE geodatabases and its system repository tables were created.

Unfortunately, it is not possible to rename an ArcSDE geodatabase once it has been created. The name of the original database is hard-coded in database objects. When the name of a database has been changed using a stored procedure or a database is restored to a name different than the original, the database cannot be be accessed via ArcSDE or ArcGIS clients.

Solution or Workaround

  • Rename the restored database with the correct original geodatabase name in SQL Server Management Studio.
  • Ensure that the geodatabase is restored with the original name in SQL Server Management Studio.
 

    Related Information