Ms VS2017 with SSDT has the 'User with Password' template but thinks it's wrong
As Aaron mentioned in the comments, try enabling containment in the database settings:



That's after right-clicking the database project and choosing "properties" in Visual Studio.

If you are not using contained databases, use the "User" script template instead of the "User with Password" script template.