Hi Sue, i've set the linked server up following that exact guide.
It's more likely to be something on the MAS side of things then SQL Server - especially with queries mostly working. One thing you could try playing with is some of the linked server specific stored procedures. They just return meta data related to the linked server source. I think the tables view is actually populated from one of those:
sp_tables_ex 'YourLinkedServer'
You may also want to try sp_catalogs 'YourLinkedServer'
Limited results coming back from those is usually related to permissions on the source server or if you have a default catalog, database on the source server it can limit what is returned even if you do have permissions in other areas. You may want to check the login used for the connect with the linked server vs Crystal Reports.
Sue
Hi Sue, thanks for the help thus far.
Running those queries returns headers, but no rows. I am using the same login between CR and SSMS. When you say it has to do with permissions, do you think it is a problem with Active Directory/windows user permission, or a MAS user permission problem?
thanks!
dan
edit: i can see the tables in Excel ODBC connection/query maker.