Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
82 | |
72 |