Thursday, May 03, 2012 9:39 AM
I have created a SQL Server 2008 R2 database by running some create scripts.
I've also created two tables manually within SQL Server Management Studio.
In BIDS, I've created a Datasource view to this database with a user that is the db_owner of the database.
However, when attempt to create a Data Source View, and I select to Add/Remove Tables, I can only see the two I created manually.
Any ideas why I can't see them all??
- Edited by MrMadders Thursday, May 03, 2012 9:39 AM
Thursday, May 03, 2012 3:26 PM
What login is listed as the owner of the tables you created by executing the script?
This is more than likely a permissions issue.
Script out the tables you created manually and compare the scripts.
- Proposed As Answer by MMilligan Thursday, May 03, 2012 3:26 PM
Thursday, May 03, 2012 11:28 PM
Hello Mr. Madders,
The User account which you specified in the data source connection wont get used until the cube processing has been started. When you tried to alter the DSV from BIDS, it will take the user account, which you logged into the system.
- Edited by Kumar Pradeep M Thursday, May 03, 2012 11:28 PM