I have now got this working using the ODBC Driver 17 for SQL Server. I think there should be some updated guidance on how to set this up, from start to finish, as the current manual is a bit vague.