I'm trying to connect to a SQL Server 2008 R2 server and profile tables in a schema other than dbo. The connection connects fine but when I expand the connection I don't see the schema I'm looking for as an option (even when connecting with SA).

I tried both the JTDS and Microsoft drivers.

I saw a few other threads about this but nothing with a good answer.

I'm tried TOS_DQ-r78327-V5.0.2 and TOS_DQ-r84309-V5.1.1.

Let me know if you need additional info. Thanks.