Adding additional tables to BISM RRS feed

  • Question

  • Hi,

    I have created a tabular project (Sql Server Denali) in VS2010 and I have tables with relationships. How can I add additional tables to the model? I do not see an option on the menu.


    Also, when I modify the query for a table and hit OK, I always get a error message saying


     'OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible.

    Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.' 

    (I think the connection is ok as when I go to Edit Connection, Test Connection, it connects fine)

    Tuesday, December 6, 2011 12:07 AM