Forum Discussion

mibu's avatar
mibu
Microsoft Employee
2 years ago

Contoso Dataset

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   ...
Need Help
  • mibu's avatar
    mibu
    Microsoft Employee
    2 years ago

    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