Post reply

unable to create Analysis Services Tabular Project in BIDS

  • September 2, 2011 at 11:57 am

    #243315

    I downloaded SQL Server Code Name "Denali" CTP3 from https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx. I'm getting the following error when I try to create an Analysis Services Tabular Project in BIDS. What's wrong? I can open SQL Server Code-Named "Denali" with MS SQL Server Management Studio.

    You cannot open the BIM file. Reason: The workspace database server 'Localhost' is not a SQL Server version Code-Name "Denali" or later.

  • September 8, 2011 at 6:42 pm

    #1378975

    Make sure that when you installed SQL Server Denali CTP3 (I am assuming that you installed this as a default instance on your local machine since your workspace is targeting the localhost), that you installed Analysis Services in the Tabular mode. In Denali, there are now two modes that Analysis Services can be installed in - the traditional Multidimensional mode or Tabular mode. If you wish to have both of these modes available, you will have to install separate instances of Analysis Services - one for each of the two modes. To create an Analysis Services Tabular project, you will have to target an instance that has Denali Analysis Services installed in Tabular mode.

    There is a good article on how to set this up here: http://blogs.msdn.com/b/analysisservices/archive/2011/07/13/welcome-to-tabular-projects.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply