Azure

ByHariharan Rajendran

Power BI Report Server

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.

ByHariharan Rajendran

Azure Cloud Shell

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.

https://docs.microsoft.com/en-us/cli/azure/

ByHariharan Rajendran

Multi-factor Authentication for Power BI – O365

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,

  1. Go to office 365 Admin Portal
  2. Expand users -> Active users
  3. Select the user and click multifactor authentication in more settings
  4. Select the user and click enable
  5. Go to service settings and choose the appropriate options.
  6. Connect app.powerbi.com, sign-out and sign-in again. We can choose the method of authentication, either by phone call or sms.

ByHariharan Rajendran

Connect Azure Virtual Machines on a Same Domain

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.

Requirement:

  1. Azure Virtual machine with Domain controller
  2. Virtual Network
  3. Another VMs

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.

ByHariharan Rajendran

Host Your SAP Machine in Azure

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.

Prerequisites:

  1. Azure Account Subscription with Credit
  2. Account on SAP Cloud Appliance Library

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.

https://manage.windowsazure.com/

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.

ByHariharan Rajendran

Enable Azure Advisor

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,

Azure

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

If you are not able to identify then enable the favorite,

Azure1

Azure2

ByHariharan Rajendran

Query Editor (preview) in Azure Portal

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.

QE1

Authorization Type

At present, it supports 2 authorization types.

  1. SQL Server authentication
  2. Active Directory password authentication

QE2

Steps to run a query

  1. Go to SQL Database in Azure
  2. Click Tools and choose “Query Editor (preview)”.
  3. Authenticate yourself by clicking “Login”. Pass the password of the SQL Server and click “Ok”.
  4. Once you are authenticated successfully, Type the script or import using “Open Query”.
  5. Click “Run”.

QE3

QE4

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.

QE5

ByHariharan Rajendran

Access Azure Virtual Machine Applications Outside of Network

AzureVM

This article explains that how you can access virtual machine applications outside of network with the help of DNS.

For example,

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.

  • DNS Configuration in Azure Portal
  • Enable the TCP port with 1433 in Azure portal
  • Enable the TCP 1433 in virtual Machine
  • Create a SQL Server login and enable the mixed mode authentication

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.

https://social.technet.microsoft.com/wiki/contents/articles/36674.access-azure-vm-sql-server-outside-of-network.aspx