nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Database user name and current user schema do not match

Chang-HengYang

Hi all,

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?

Thanks,

Hank

Errorfeatureclass1.jpg

Errorfeatureclass.jpg

RyanBohan_0-1645135300313.png

IfSurveyHasAttachmentsConditional_20210107.PNG

Trouver plus de publications taguées avec

Accepted answers

JakeSkinner

Try setting the default schema to NMBGMR\hyang for the GISData database. Then execute the Feature Class to Feature Class tool. Do you receive the error?

All comments

JakeSkinner

HI Chang,

How are you connecting to the enterprise geodatabase? Are you using Database Authentication, or Operating System Authentication?

Chang-HengYang

Hi Jake,

I am using the Operating System Authentication (Windows).

Thanks,

Changheng

JakeSkinner

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.

User Schema

domain\user domain\user

Chang-HengYang

Hi Jake,

The image shows the info you asked. I was trying to execute the tool "Feature class to feature class" in database GISDate.

Thanks,

Hank

JakeSkinner

Try setting the default schema to NMBGMR\hyang for the GISData database. Then execute the Feature Class to Feature Class tool. Do you receive the error?

Chang-HengYang

Wow Jake,

Thank you so much for the solution. It is working!! However, why do you think the issue from SQL server not the windows server?

Thanks,

Hank

JakeSkinner

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.

Chang-HengYang

Why do not you think the issue was from the windows server problems since I posted two files in the first post?

Thanks,

Hank

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.