CODEWITHSUNDEEP
postgresqlchocolateybeakerserverspecwindows-server-2022
MajdAlo
MajdAlo

Reputation: 53

WORKGROUP\user: No Mapping between account names and Security Id was done,

I installed PostgreSQL using Chocolaty and Beaker tests in Windows Server, but I got this error

WORKGROUP\user: No Mapping between account names and Security Id was done.

Then:

Initdb: Error: could not access directory ¯d: /postgres/data®: Permission denied

I though the problem because of WORKGROUP, I have tried most of solutions mentioned in Google search but unfortunately with no success.

Upvotes: 1

Views: 878

Answers (1)

Sébastien Wieckowski
Sébastien Wieckowski

Reputation: 844

Your Windows 11 username must have characters that the PostgreSQL installer doesn't like, as it did for me with my French accent on Sébastien. So there's no need to create a new Windows account or do crazy manipulations in the Windows registry, just change your username in the netplwiz, which you'll start from a command line/terminal in Administrator mode, choose the 'problematic user' in the User Accounts window and go to 'Properties'. All you have to do is give a more English name and restart the PC. The PostgreSQL installation now works.

Upvotes: 0

Related Questions