• Yes.

    I tried the following and it worked.

    GRANT CONNECT SQL TO [Testuser]

    GRANT CONNECT ON ENDPOINT::"TSQL Default TCP" TO [TestUser]