An error is received when trying to access a SQL Server database that has been restored with a new name

Last Published: October 20, 2023

Error Message

If an existing SQL Server database that contains a geodatabase is restored to a new or existing server, and the original name of the database is not retained from when the geodatabase was created, issues can be encountered when trying to connect to the geodatabase through ArcGIS.

The following error could occur when connecting to the geodatabase from ArcGIS if the geodatabase is at version or earlier and the original name of the database is not used:

Failed to connect to the specified DBMS instance.
A database connection exception has occurred.
FDO error: -21472216072


The cause of such an error may be linked to restoring a database in SQL Server Enterprise Manager/Management Studio under a different name than the original backup or datafile.

Enterprise geodatabases in SQL Server cannot be renamed because the name of the original database is hard-coded in database system tables. When the name of a database has been changed using a stored procedure or a database is restored to a name different from the original, the database cannot be accessed via ArcGIS clients.

Solution or Workaround

Rename the database to its original name using the T-SQL command:

If this is not possible, because an existing database shares the same name, the database must be restored to another SQL Server instance for access using its original name.

Article ID:000008032

  • ArcMap 10 6
  • ArcMap 10 8
  • ArcGIS Pro 2 x
  • ArcMap 10 7
  • ArcGIS Pro 2 8 x
  • ArcGIS Pro 2 7 x
  • ArcMap 10 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic