Azure

ByHariharan Rajendran

Azure data Sync Update

Microsoft Azure recently released clear road map of Azure Data sync. It replaces the SQL data sync service in classic portal.

If any of the customers are using SQL Data Sync then they need to migrate those sync groups to new portal.

Following the announcement, Azure classic portal not allowing us to create sync and even the SQL databases also. Microsoft Azure team trying to migrate all the services to new portal and in one point of time, Microsoft will remove the classic portal.

As like the previous service, this migrated service also still in preview.

ByHariharan Rajendran

Azure SQL Data Sync in Azure New Portal

Azure Data Sync is the feature to synchronise the data between Azure SQL databases or Azure SQL Database to On-premises databases.

Microsoft Azure team released Azure Data Sync option in new portal.

Check the below road map of Azure Data Sync update from Microsoft.

  • Migrate existing sync groups to new portal – Starting from June 1, 2017
  • Data Sync in Azure new portal – June 15, 2017
  • SQL Data Sync retired from classic portal – July 1, 2017
  • SQL Data Sync retired – September 1, 2017

While writing this post, we got data sync option available in the new portal.

Follow the below steps to check the new option in new portal.

  1. Go to new portal, portal.azure.com
  2. Go to your Azure SQL Database
  3. Check for the option “Sync to other databases”

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