Sage 300 2019 very slow connection to SQL database

SOLVED

Hi,

Upgraded a client to sage 6.6 and sql 2017. When users log in to Sage, the screen hangs on connecting to database and takes a while to establish connection. Once connected, processing is ok however report printing is again very slow. Ping test does not timeout, ODBC connection to server tests successfully. 

Sage 2019 PU 2

SQL 2017