Some thoughts of your typical data shepherd / data plumber / data dance teacher sort of person.
Ok long story, short. I downloaded and installed SQL server 2016 CTP3 on Windows 10 Pro X64 Virtual machine which was set up for testing purposes. Yes l know that was a silly idea, what the heck living dangerously is fun sometimes! The OS was a standard install and it's standalone as in not connected to a domain or clever stuff. When propmted to enter a user account, l used a personal Microsoft account l have. Next l installed SQL Server 2016 CTP nothing fancy and choose the native SSRS install
(If you just interested in list of steps l followed they are at the bottom of this posting)
Next logged in as the user account that was used during set up, this is Microsoft account. Now l wanted to play with SSRS, so open the default browser (Microsoft Edge) and entered the url “localhost/reportserver” and waited. Next got a dialog box asking me to enter my user credentials
So l entered my Microsoft account details, and eventually ended up with the error message below.
Yes l know that I should have remembered, an admin account requires to grant permission on Report Manager to the account you are connecting with “Doh!”. Next step was to see if l could run Microsoft Edge (the default browser) as Administrator, no that was not possible. As can be seen from the screen shot below it was possible to run command prompt as Administrator, which did not make sense, but not Microsoft Edge.
Again Google the rescue and found this page - http://www.virtualizationhowto.com/2015/07/windows-10-edge-opened-builtin-administrator-account/. Followed instructions open Microsoft Edge, restarted Windows was able to run Microsoft Edge as Administrator, "Yippee!!!" Typed in the url “localhost/reportserver”, then eventually got the following error message.
During earlier search found this page http://www.windowscentral.com/how-find-internet-explorer-windows-10-if-you-really-need-it. I had tried this before making the change in this page http://www.ghacks.net/2014/11/12/how-to-enable-the-hidden-windows-10-administrator-account/. So entered ‘Internet ‘ into the search box and selected to run Internet Explorer as Administrator.
Success !!!!!! (see screenshot below) As the saying goes “ a long way for a short cut”, however it works!
So l set about making the relevant changes in report manager, setting up the Microsoft user account l normally log in with as content mgr etc. That all seemed to go as expected. Next switched accounts back to the Microsoft account and thought l will just open Microsoft Edge. Since the account has been set up and l do not need to run it as Administrator. This did not work l got the error message below. So l typed into the search box 'Internet' and Internet Explorer was one of the applications l was able choose to run, the result can be seen below. It worked as expected.
Is there an easier way? Then please let me know, this was not the most fun learning journey, and I’m always open to learn.
So what steps did l follow?
Used instructions to enable the administrator account and set the password for the Administrator account.
Switched accounts from Microsoft account to Administrator account
Used these instructions to make relevant change to the security policy
Used these instructions to find Internet Explorer and open using "Run as Administrator" option
4) Open SSRS report manager (running as local administrator), set the relevant permissions for the Microsoft account
5) Switched accounts from Administrator account, to Microsoft account. Searched for Internet Explorer then browsed to "localhost/reports" and was able to see SSRS report manager.
Continuing Professional Development
Having worked with a number architects (they that design building) companies l have been made aware of the concept of Continuing Professional Development. In that any qualified architect is expected to learn and refine their skills for as long as they are a practising architect.
Another big part of the conference is the sponsors, they have stands set up in the main part of the conference. Yes they are their to sell their products, on the other hand they are very generous and have many have prizes to give away. Entering the competitions to win prizes can be as simple as giving your email address, others you might have to work for. Such playing a racing car or sail boat simulator, these are geeks what do you expect ! Some of the sponsors have technical evangelists who are there to speak all of whom in my opinion are worth going to just for their sessions alone. Next how often do you get to meet with representatives from Microsoft and ask them questions face to face.?
Fun and Games
There's even more fun to be had. So far l have only attended two SQL Bit conferences. The evening parties are well something to be experienced, the best way to put it is that these are dreamed up by geeks and attended by geeks. Both of these groups of people know how to have a good time. Also if you visit the sponsors you might just come away with tokens, for free drink, at the parties. Need l say more?
The last question that occurs to me is why do l go? Personally and ultimately l want to be the best possible person doing my job. To provide my customers with the best possible service l can offer. To achieve that will take time, energy, and sacrifices. Part of that will be paying my way these conferences till l can convince my manager to pay for at least part of them. Until then l will go to learn and develop, then one day return and speak myself to starting paying back my technical debt.