View Single Post
  #1 (permalink)  
Old April 22nd, 2017, 09:50 AM
michaelphilipsz michaelphilipsz is offline
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Apr 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Adventure works database not compatible

I have the Professional Microsoft SQL Server Analysis Services 2012 with MDX and DAX. I have downloaded the express edition of sql server management studio 2012 as i can not locate the enterprise or development versions anywhere. However although I can download the adventure works DW sample database from the code for the relevant chapter 2 in the book I am unable to attach or import any of the files that come with the analysis services multidimensional tutorial. I keep on getting messages like the one below. Is it because I am using an express version of sql server 2012 ? Microsoft tell me that they no longer provide software for 2012 developer edition. I could download sql server management studio 2016 developer but I cannot find a wrox book that covers 2016. What should I do? Help!! I have spent a lot of money on a book I cannot use

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click:


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


C:\MYSQLServer\AnalysisServicesMultidimensionalTut orial.database is not a primary database file. (Microsoft SQL Server, Error: 5171)

For help, click:


Reply With Quote