On a fresh MSSQL Server container, with image: mcr.microsoft.com/mssql/server:2022-latest i login as “sa” and create a database, two schemas and a login/user.

-- USE master
-- <create database, schema data, liquibase>
CREATE LOGIN kpadmin WITH PASSWORD = '<password>'

USE <database>
GO
CREATE USER kpadmin FOR LOGIN kpadmin WITH DEFAULT_SCHEMA = dipsdata
GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA ::data TO kpadmin;
GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA ::liquibase TO kpadmin;
GRANT CREATE TABLE TO kpadmin;
GRANT CONNECT TO kpadmin;

Afterwards when i log into the user kpadmin in SSMS and run the query

SELECT USER, USER_NAME(), SYSTEM_USER, SUSER_SNAME(), CURRENT_USER

the output is:

guest   guest   kpadmin kpadmin guest

Why us USER and USER_NAME() guest here? should it not be kpadmin. How can i fix this, what did i overlook? This inevitably messes up running liquibase with this user.