MonthMarch 2019

Finding The License Key For SQL Server Reporting Services

A very common question I seem to get from customers, colleagues & friends in the Azure community is “Where do I find the product key for SQL Server Reporting Services, if I’m using PAYG licensing from Azure?”.

And if I’m honest this is a very good question, as you never get shown the product key in the Azure portal when deploying and there is no command you can run via PowerShell or AZ CLI to get the key.

However finding the key is actually very easy and isn’t just applicable to Azure, so you can use option 1 below on any SQL server to find the product key.

I’ll assume you know how to download and install the latest version of SSRS. But here is a handy link to the download page if not. Download SSRS 2017.

So lets get into the 2 methods you can use to find the product key on an Azure IaaS SQL VM deployed using a marketplace image on the PAYG licensing model.

Option 1 – Using The SQL Server Setup Wizard

  1. Connect to and login to your newly deployed SQL IaaS VM via RDP
  2. Open Windows Explorer and navigate to the following path: ‘C:\SQLServerFull\’
  3. Locate ‘Setup.exe’ and double click on it to launch the setup wizard
  4. Select the ‘Maintenance’ pane from the left hand side menu and then click on ‘Edition Upgrade’
  5. The ‘Edition Upgrade’ wizard will launch after a few moments and will display a product key

This is the product key that you require and has been used to install/license the SQL Database Engine that is running on this VM. Copy this key to a notepad file and then cancel all of the wizards and close the setup launcher.

Then launch your SSRS installation wizard and use the key you have copied to a notepad file.

Option 2 – Extract Key From DeafultSetup.ini

  1. Connect to and login to your newly deployed SQL IaaS VM via RDP
  2. Open Windows Explorer and navigate to the following path: ‘C:\SQLServerFull\x64’
  3. Locate a file called ‘DefaultSetup.ini’ it may just be shown as ‘DefaultSetup’ if you don’t have file extensions shown. Double click on this file and open it with Notepad.
  4. Notepad will then display the contents of the .ini file and within this the product key is shown next to “PID=”

Again this is the product key that you require and has been used to install/license the SQL Database Engine that is running on this VM. Copy this key to a notepad file and then close the ‘DefaultSetup.ini’ file without making any changes to it and saving them.

Then launch your SSRS installation wizard and use the key you have copied to a new notepad file.

Summary

Hopefully this article will help you all out at some point in the future. It’s a curve ball that’s come my way a few times and took me a bit of research to find the above methods.

Until next time!

Passing The Azure AZ-302 Exam

Firstly apologies for the radio silence on my blog, it’s been a hectic couple of months for me as I’m getting married in April; time free at the weekends is very sparse at the moment. But fear not I have a list of items to blog about and a new method to attack writing them faster, so watch this space.

Anyway on with the topic for today’s blog!

So nearly a month ago now I passed the Azure AZ-302 exam to complete the requirement for the Azure Certified Solutions Architect Expert badge.

Now it was my 2nd attempt that I passed on, but failing exams is not something to be ashamed of at all. Putting yourself up against a test is a sign of courage and confidence in my eyes. We can only learn from failure; so that’s a massive positive in my eyes! It took me a while to realise this in my career after failing a CCNP exam by 3 points years ago!

Before I continue I feel it is important to reiterate a couple of points that I made in my post about passing the 70-535.

You can only take the AZ-302 if you have passed the 70-535 exam. Also the transition exam, AZ-302, is only available to take until the 30th June 2019 before it is retired!

Preparation – What To Study

As I have said in my previous post, you must first understand what the exam is going to be testing you on before you can decide your plan of attack for studying the exam objectives.

As always Microsoft has published the exam objectives and breakdown on the AZ-302 web page.

However please note that a change document was posted on the web page that changes some of the exam objectives and section percentages; it’s located just above the exam objectives as a note.

One thing I feel is important to say about the stated exam objectives for the AZ-302 is that they look at first glance to be quite a wide range of topics and it can feel overwhelming.

From taking the exam twice I honestly feel that the exam objectives aren’t very accurate at all. So much so that I actually filled out parts of the feedback at the end of my 2nd exam.

So my advice would be to review the objectives on the web page and in the change document and make notes of things you need to revise more heavily than others. But then take the following tips from my experiences:

  • You don’t need to know how to be a full on developer for this exam. An understanding of programming languages and being able to read them at a high level will suffice.
    • It’s more important to understand what service is best for each use case for different development functions (i.e. Azure Functions/Azure Web Jobs etc…)
  • Know your SLAs for different services and features (Availability Sets 99.95% vs Availability Zones 99.99% etc…)
  • Invest more time on Azure Site Recovery & the different Azure Backup products/features
  • Be prepared to be quizzed on some preview features, so don’t disregard those sections of the Azure Docs

Preparation – Revision Tools & Resources

I find videos are easier to watch on the train when travelling into London and back home as I can’t always get my laptop out to make notes; getting a seat is generally a challenge!

So with that in mind I started off with the Scott Duffy AZ-302 course on Udemy.

This course is very high level and doesn’t have a lot of walkthroughs/labs/demos so it’s certainly not going to be enough for you to pass the exam. But it’s quite good for the theory side of things around determining requirements and when to use a pilot instead of a POC.

Then I normally like to read a book to reinforce the videos but as this exam is only a transition exam there isn’t one available and I can’t really see anyone thinking about making one as it’s such a niche gap in the market.

So instead I headed to the Azure Docs! Especially from my last experience with the 70-535, these really are awesome for all aspects of learning Azure. From how to’s to overviews, they cover it all and are super up-to-date thanks to them being open the community to recommend updates via the github repo where the content is hosted.

I also make sure I check the Azure Blog daily at least twice. Once when I get up and again before I call it a day. This helps to keep on top of new feature releases etc…

I cannot stress enough of also using the Azure portal itself daily and just getting comfortable with it and it’s behaviour. Also any hands on time with AZ CLI would be a very handy.

Finally I checked all of the following great blogs from some people in the community to make sure I had covered all the correct objectives and pick up any tips they have given in their posts:

Preparation – Method

My method to revise for this exam was very similar to how I approached the 70-535 apart from I spent much more time actually deploying and configuring things in the Azure portal and with AZ CLI.

A high level overview of my approach per objective/topic is below:

  • Watch any videos available for the objective/topic
  • Deploy it and configure it if possible and understand how it really works in Azure
  • Read at least the overview page on the Azure Docs website for the objective/topic but also try to follow some of the how to’s through
  • Make notes along the way of key facts like SLAs, tiers & pricing etc…

The Exam

The exam itself was a new one on me for Microsoft exams with the introduction of hands-on labs!

Yes that’s right, actual labs where you have to perform tasks in the Azure portal and using AZ CLI/PowerShell. I had 2 labs that contained about 10 tasks each! And being perfectly honest, I really enjoyed them as i use the portal daily testing features & services out so it didn’t phase me.

I can only assume that these are marked by Microsoft reviewing the JSON of the subscription you are given access to to perform the tasks on and they look for the specific values you have been asked to configure/change. Very cool!

There was also the normal multiple choice questions along with a couple of case studies with 5 questions or so each in them.

A top tip of mine would be to make sure you don’t waste all your time in the labs as my case study questions appeared after I completed the labs; just when I was starting to put my feet up!

Summary

All in all I really enjoyed the exam; enough to take it twice in fact!

The introduction of labs was odd for an architecture exam but I’m a big believer of being able to actually configure/deploy something before suggesting it in a HLD as how can you know it really the works they way it says it does!

Hopefully the above gives you an insight to my experiences for this exam and helps you pass it before the retirement date in June.

Until next time… Like, Comment & Share!

© 2019 Jack Tracey

Theme by Anders NorénUp ↑