No available tables on metadata wizard when using certain data source

[Stejawh]

Hi,

I'm trying to pull tables in from a certain Publish Table but don't get any tables to select in the Metadata wizard when using a certain data source (When using a different data source i get the full list).  We need to keep the same data source name though.

Has anyone seen this?

Cheers,

Steve

[JGirl]

Assuming that both your data sources are indeed pointing to the same database, I'd check the permissions of DB logon accounts you are using within each database connection.  it sounds to me like one has less access than the other.

J

[Stejawh]

Both are pointing at our DB Server and the same Publish DB.  Thye are both using the same logon.

Thanks,

Steve