Cannot See my Tables

[Squarehoop1]

I built a connection to my SQL Server database. The Test Connection comes back successful. However, when I click on Tables under my connection it comes back and says No Data Found.

Any thoughts on how to get the Dynamic AI to see my tables?

[Carsten Sørensen]

Hi,

I assume that you are using the direct connection (not using ODBC) from Dynamic AI? Can you try with a user that has got more rights (like the sa). Try without an OWNER/SCHEMA if you specified that.

Your MS SQL Server should allow database authentication (setting at DB level).

best regards,
Carsten

[Squarehoop1]

I took out the entry I had for Owner/Catalog and it worked. I had been using an adminstrator login as you had suggested. But, removing the owner seems to have done the trick.

Thanks for the help.