rlshuhart

And thanks for the hard work of putting this together!

I'm seeing this as well. Adding port to server as suggest works.

Just stumble across this problem again and found I've already been here. I'll add that if I use sql server authentication, the non-standard port is used, however, if I use...

Digging more this appears to start from here: https://github.com/dbt-msft/dbt-sqlserver/blob/909f61cda860ddb6ba5ec4ca88fb5cf16c613afd/dbt/adapters/sqlserver/sqlserver_connections.py#L81-L82 This ends up using open from fabric_connection_manager as @cody-scott referred to. Unfortunately, fabric does not consider the port attribute and excludes...

Per https://github.com/microsoft/dbt-fabric/issues/247 use of non-default ports is out of scope in dbt-fabric since, "customers have no control over the port in Fabric DW." Therefore, in my opinion, it is fitting...