If you are using the Business Intelligence, Developer or Evaluation editions choose the Enterprise project. Depending on the edition of SQL Server, open the Standard or Enterprise folder. If the select statement successfully returns rows then the privileges needed to read data fromĢ.
Choose any table, right click on it, and click on Select Top 1000 rows.į. Expand the AdventureWorksDW2014 database object and expand the Tables folder.Į. That the database was installed and that appropriate permissions exist on the database instance.ĭ. If the database is still not available check Note: If the database is not visible try refreshing the database node. Locate the AdventureWorksDW2014 database. Open SQL Server Management Studio and connect to the Database Engine instance where the AdventureWorksDW2014 is located.Ĭ. Verify read access to the relational data source AdventureWorksDW2014.Ī. Note the location where the file was saved.ġ. Download the "adventure-works-2014-multidimensional-model-project" from. Read access to a copy of the AdventureWorksDW2014 databaseĪnalysis Services Multidimensional capabilities.ġ. SQL Server Data Tools, a feature installed when installing SQL Server, used to create Analysis Services projectsģ. For more information on requirements see Hardware and Software Requirements for Installing SQL Server 2014.Ģ. SQL Server 2014 Analysis Services, deployed in multidimensional mode.
#Microsoft adventureworks database download 2014 install
Requirements to install and deploy the Adventure Works DW 2014 Multidimensional sample database and project:ġ. If you are using the Business Intelligence edition of SQL Server, use the enterprise project. One for the enterprise edition and one for the standard edition of SQL Server 2014 or later. This sample contains projects used to deploy an Analysis Services multidimensional databaseīased on Adventure Works sample data. Install AdventureWorksDW2014 multidimensional database from a project