Interestingly connecting by IP doesn't work at all, even in SSMS where the server name works. TCP/IP is enabled with the correct IP in there.

And yes I modified both my...

Just tried enabling RPC and RPC out, but still no good.

Credentials are working in SSMS, so definitely correct.