Microsoft SQL Server Reporting Services is the product which provides solutions to all the business enterprises. While it was in peak, Microsoft released another new BI tool which is nothing but Power BI.
Now Power BI is leading the Business Intelligence Industry. As it is a cloud-based service, business users were not able to use that tool for their business solutions because of security concerns. They were waiting for on-premises based Power BI server.
Now the wait is over. Microsoft released Power BI Report server which can be installed and configured for on-premises business solutions.
Power BI Report server is available for preview, you can download, install and experience the on-premises based Power BI Report.
As it is very new, it supports only analysis services as a source but in future, we can expect the same source connectors as like in Power BI cloud services.
This blog post explains to you that how you can experience the Power BI Report server using the Azure VM template.
Follow the below steps to spindle up Azure VM with Power BI Report Server on it.
Step 1: Login Azure portal and add a new Virtual machine
Step 2: Search for Power BI and it will show the below template
Step 3: Click create
Step 4: Add the VM name and credentials and choose which AS server you want to use from the drop down.
Step 5: By default, it using the below settings. In case, if you get an error message then change the name of the storage.
Step 6: At last, you need to click the purchase button. It will create and deploy the Power BI machine.Once the machine is deployed successfully, connect the machine and you can see the Power BI.
Once the machine is deployed successfully, connect the machine and you can see the Power BI Report Server.It also adds an option to create Power BI Report from the portal itself.
This post just to shows that how to configure the Azure Cloud Shell and its options.
Microsoft Azure recently announced this new feature, it helps us to run the Azure CLI commands directly on the portal itself.
It is required to configure the storage for one time.
Once the above configuration is completed successfully, you can see below the window.
In future, it is going to support power shell as well.
Check the Azure CLI commands in Microsoft documentation.
It is easy to enable the multi-factor authentication for a user. To enable, administrator permission is required. Once we enable the multi-factor authentication to the user then the user should pass through the authentication wherever that user wants to access.
For example, if you are Office 365 admin and you are enabling multi-factor authentication for a user. That user should go through the second authentication to login to email, power bi or whatever services that are connected with O365.
Follow the below steps to enable Multi-factor Authentication,
Connecting multiple machines on the same domain would be one of the requirement to all the network administrator to set up the environment for any scenario.
This post explains this scenario how administrators can they do this setup easily.
I pretend that you have a machine with a domain controller on it.
While creating another machine, you need to choose the first machine’s virtual network instead of creating a new one as like below.
Next, you can identify the IP address by typing ipconfig in command line tool.
Also, you can ping the machines each other. In case, if you are not able to ping then turn off your firewall.
Then, try to add the domain and it will throw an error message as like below.
To rectify the above issue, you need to add the domain control IP address on DNS Server. Go to Azure Portal and Network Interface.
In DNS Server add the domain controller IP address in custom and restart the machine.
Again log into the machine and now try to add the domain and this time you can add successfully. Share your comments, if any issues.
This article explains to you that how can you host your SAP Machine in Azure. Let us host SAP BW Machine in Azure here. Same steps should be followed for other SAP machine templates.
Follow the below steps to host your SAP BW in Azure,
Step 1: Connect to https://cal.sap.com/catalog#/solutions and filter “SAP BW”
Step 2: Choose the instance and click “Create Instance”
Step 3: Log into SAP CAL
Step 4: Choose “Create a new account” in Account section.
Step 5: Choose the “Microsoft Azure” and get subscription id. Visit portal.azure.com and log in with your azure credentials.
Step 6: Fill the details as like below,
Step 7: Click the “Download New Certificate”. The certificate will be downloaded.
Step 8: Visit the below URL to upload the certificate to Azure management portal.
Step 9: Upload the certificate.
Step 10: Go to cal.sap.com URL again and click “Test Connection”. It will open the other details.
Step 11: Fill the Instance details and click “Create”
Step 12: Download the “Private key”. A message window will pop up.
Step 13: Check the system status and wait until to complete the activation.
Step 14: Once Status changed to “Active” then click “Connect”.
Step 15: Click “Connect” RDP. Enter the instance password which you defined.
Step 16: Inside RDP, check the guide and start to use BW.
That’s it. It is simple to host any template from cal.sap in Azure as like this.
Share your comments below.
Microsoft Azure Team released one of the expected feature in azure.
It is like a personal assistant that helps us to follow best practices, efficient resource usage and optimize the deployments.
Check below to get the Azure Advisor,
Mostly it will be available in left side of the menu,
If you are not able to identify then enable the favorite,
Microsoft Azure added a new feature called “Query Editor (Preview)” for SQL database. It is a portal based query editor.
Now user can execute the SQL query directly in the portal itself instead of using SQL Server Management Studio (SSMS) to access the data.
Find a Query Editor in SQL Database
Query Editor (preview) is available under Tools in SQL Database.
At present, it supports 2 authorization types.
Steps to run a query
Open & Save Query
If you have SQL script file on your machine and want to run those scripts in portal Query Editor then you can use “Open query” option to import the .sql file.
In another case, if you want to store the written query in the editor then click “Save query”. SQL script file will be downloaded.
This article explains that how you can access virtual machine applications outside of network with the help of DNS.
Consider you have installed SQL Server on Azure Virtual machine and created few databases on the server. If you want to access those databases on your local machine, then you need to follow the below steps.
Once you have configured all the above steps, you can access your databases on another machine in SQL Server Management Studio.
Refer the below link to know in detail about the above steps.