Temporary Workaround I figured out for now was using hostname,port instead of the hostname\\instance works and connects as intended, however I'd like to use a named instance instead of having to rely ...

SQL Instance to connect to. For default instances, only specify the computer name: "MyComputer". For named instances, use the format "ComputerName\InstanceName". Specifies A PSCredential for SQL ...