Contoso Dataset

[mibu]

Hey Team,

I downloaded:

Contoso BI Demo Dataset for Retail Industry from Microsoft Download Center here

The download contains two files as follows:

Contoso_Retail.abf

ContosoRetailDW.bak

After extracting the two files from the download...  the instructions say the following:

To restore and process the Contoso BI Demo dataset:
1. Open SQL Server Management Studio, and select Database Engine.  DID THIS
2. Enter the Server name and click Restore Database….  WHAT IS THE SERVER NAME??
3. Restore ContosoRetailDW.bak file to ContosoRetailDW database.
5. Connect to Analysis Services in SQL Server Management Studio and restore ContosoRetail.abf backup file to Contoso_Retail OLAP database.
6. Verify Data Sources of Contoso_Retail is connecting to ContosoRetailDW,
7. Click Process.

My question is:  What is the Server name from Step 2 above?

Thank you!!

mibu

[amitchandak]

@mibu , As far as I understand, you need to have your own database.

say Azure SQL, then that will be url

or local SQL server then you will url like localhost or localhost \sqlexpress

You can create new database

In case you want to install express edition

SQL - https://www.youtube.com/watch?v=ThCZYuYAbnY&list=PLPaNVDMhUXGblXMYDB1P46cBhwPXRVgiD

[mibu]

Hi Amit!

Thanks for the guidance and your awesome part 1 SQL video on YouTube here

From what I learned, I was able to successfully restore ContosoRetailDW.bak

So, awesome...  halfway there.

Then...  I try and perform Step 5 from above:  Connect to Analysis Services in SQL Server Management Studio and restore ContosoRetail.abf backup file to Contoso_Retail OLAP database as follows:

But then I get the following error message:

TITLE: Connect to Server
------------------------------

Cannot connect to localhost\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

I confirmed 'SQL Server Browser' service is running...

In fact, all SQL Services are running...  except for SQL Server Agent (SQLEXPRESS)...

I start it...  but then it automatically stops...  I can't get it to stay Running.

Going Start...  typing run...  typing  services.msc   and checking all SQL

------------------------------

No connection could be made because the target machine actively refused it #.#.#.#:# (System)  (Numbers masked for security purposes.)

------------------------------
BUTTONS:

OK
------------------------------

@amitchandak  Thoughts on how to work though this Analysis Services issue and complete Step 5,6,7?

Thanks!

Best,

mibu