Starting Point Foothold

i was able to enumerate the user and password for the mssql server, but when i try to connect to it using mssqlclient.py i get the following error:

$ python3 mssqlclient.py ARCHETYPE/sql_svc@10.10.10.27
Impacket v0.9.22.dev1 - Copyright 2020 SecureAuth Corporation

Password:
[*] Encryption required, switching to TLS
[-] ERROR(ARCHETYPE): Line 1: Login failed for user ‘sql_svc’.

I’ve also tried running it as sudo, which gives the error:
$ sudo python3 mssqlclient.py ARCHETYPE/sql_svc@10.10.10.27
Impacket v0.9.20 - Copyright 2019 SecureAuth Corporation

Password:
[*] Encryption required, switching to TLS
[-] ord() expected string of length 1, but int found

I’ve also tried getting a shell with the mssql_payload metasploit module which loads to 100% and then fails to grant me a shell.

I’m really lost at whats going wrong, so if someone could point me in the right way that would be great!