Error: Failed to create feature class. DBMS table not found [database.user.fcname]

Error Message

When creating data in an ArcSDE geodatabase stored within SQL server 2005 the following error message is displayed:

Failed to create feature class. DBMS table not found [database.user.fcname]
ArcSDE software, including the application server, command tools, and SDK with C and Java APIs, was deprecated at ArcGIS 10.2.2 and is no longer distributed. ArcGIS software features were deprecated, rather than immediately removed, to provide customers with backward compatibility and give as much advance notice as possible to adopt newer technology.


The schema set in the database is not the same as the username.
ArcSDE is hard-coded to look for a schema that matches the user name within the database specified. This particular problem only occurs with ArcSDE 9.1 sp1 and SQL server 2005, and is a result of the new concept of user schemas with SQL server 2005.
If users are going to be owning/creating data or making large selection sets that require user logfiles to be created, they must ensure that the user and schema name match exactly.
For more information, refer to ESRI Technical Paper: Setup SQL Server 2005 for ArcSDE 9.1 SP1.

Solution or Workaround

Ensure that all new users have the same default schema name as their username within each database.
The following example is a screenshot of the log-in properties under the User mapping page in SQL Server Management Studio. This illustrates how the default schema name can be set when adding a login as a user within a particular database. Default schemas must be set for all users within each database.

[O-image] schemas


Related Information

Last Published: 11/24/2020

Article ID: 000008527