Trying to establish new data connection to SQL database but it keeps failing.

I have numerous legacy files that pull data directly from our ERP's SQL server. I work from home and I am able to refresh the data as long as I am connected to the company VPN. I am trying to put together one of these files myself and the connection fails every time. I have tested my SQL code by swapping it into the existing Command Text box in the connection definition window. My SQL code works.

However, for the file I am trying to build I want to pull the data into Power Query first before loading it as a table in the workbook.

For the new connection settings I am using the exact same server, database, username, and password values that exist in the Connection String in the legacy files but there are other values that I am not given the option of entering when creating a new connection (prefetch, connectioncache, driver, etc.).

I am always left with the same error message: "Details: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)"

Is there an advanced "New Connection" option somewhere that lets me add these additional settings? Is there something else I am missing?

Capture2.PNG