Thank you for your time in advanced. I have a issue with the tool "Feature class to feature class" in ArcCatalog. Our Database server is SQL Server 2012. The message shows that "Database user name and current user schema do not match " and "DBMS table not found". In addition, the Sever Manager (Windows Server 2012 R2). The attached files show the messages provided by the Windows server.
By the way, I used to execute the tool "Feature class to feature class" smoothly until the accident shutdown . the IT staff has restarted this windows server. However, the issue still exists.
Could everyone show me some opinions for this issue?
Solved! Go to Solution.
If you go to SQL Server Management Studio > Security folder > right-click on the username > Properties. Click on 'User Mapping' at the top left. Does the schema match that of the user name? i.e.
When working with ArcGIS, the username must match that of the schema. Unless the user has db_owner or sysadmin privileges, in which case the schema will default to DBO.