I have a database in sql server 2005. I have a schema called A. (Create schema A). THen I have several tables and procedures in that schema. Yet, when I update my reports to use the new tables with the schema name (select blah from A.table), I receive an error on the site that says "invalid object name 'A.table'"
How do I get RS to understand my schema? I'm using a sql server account as credentials for my data source.
Thanks,
-LoriUser error. I was tired. My datasource was not being deployed, and the tables did not exist in the old datasource. Once I updated the report/datasource and re-deployed, I could see the tables.
No comments:
Post a Comment