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]"


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 need to ensure that the user and schema name match exactly.

See the link in the Related Information Section below for a white paper with more information.

Solution or Workaround

Please 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 Login 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 will have to be set for all users within each database.
[O-image] schemas

    Related Information