Who's Online
7 visitors online now
1 guests, 6 bots, 0 members
Support my Sponsor

High level features of Azure Machine Learning

Hi All

 

In our previous article we “Starting with Azure Machine Learning” we created a free Microsoft Machine Learning account. If you haven’t done that, please create your own free ML account so you can practise and understand this article further. If you have an account already created and we are all good to go.

 

Azure Machine Learning Studio is a GUI-based integrated development.

 

Our next step is to understand very high level Azure ML options. Below are high level feature in Azure ML followed by understanding of each high level feature:

 

Projects: As you can see in the screenshot, Projects is a newly added feature to Microsoft Azure Machine Learning. An individual can work on multiple dataset, Notebook and experiment for different clients/projects. Unless we use a proper naming convention, it was difficult to understand which dataset is associated to which project/client. To resolve this issue, Projects was introduced so that we can consolidate all information related to single project in same location. I would say Projects was a very small change to Azure ML but it has a very big Impact.

 

Experiments: This is the brain and heart of Azure ML. Experiments is where we create new models and train our model on smaller data. We can iterate on our model design, editing the experiment and running it until it gives us the results we looking for. Experiments in Azure ML is a showcase for simple experiments that make it easier for someone who wants to start exploring machine learning, through datasets. We would be spending nearly 70 % of our time in Experiments by using different features like data format conversions, data input and output, feature selection, etc. Below is screenshot of same:

 

Web Services : When our model is ready, we can publish it as a web service so that others can send it new data and get predictions in return. This is a very important feature in Azure ML and we will discuss a lot about this feature in our upcoming articles.

 

NoteBooks : As you can see in the screenshot, Notebooks is a newly added feature to Microsoft Azure Machine Learning. As we have already seen and discussed, Azure ML is GUI based, drag and drop simple to use ML platform however we have lot of other platform which are non GUI base. Azure ML Notebooks is create to encourage those who still want to continue writing code. We can create a machine learning model in a notebook by writing the code and implementing the machine learning API.

 

Datasets: The first and the foremost thing we need in Machine Learning is data. Azure ML offers several sample datasets which are part of Machine Learning Studio. We ca use it or we have option to import data from many sources like from our local machine. Very common dataset formats are GenericCSV, Attribute-Relation File Format (ARFF), GenericTSV, DataTableDotnet, etc

 

Trained Models : We can say that trained Model is a part of web services. When our model is ready, we can publish it as a web service so that others can send it new data and get predictions in return. Similarly, I can use this trained models for my other dataset without publishing it and use it within same workspace. This is a very important feature in Azure ML and we will discuss a lot about this feature in our upcoming articles.

 

Settings: Workspace name, storage, account information, users, data gateways and Authorization tokens are options available in settings. This is just like any other settings available in applications.

 

I will explain uses of each and every High level feature and talk more in details about them in my upcoming articles.

 

Happy Learning!!

Starting with Azure Machine Learning

Hi All,

 

Today we create a Machine Learning account and will have a glance of very basics of Microsoft Machine Learning. Well machine learning in general helps to predict things based on its learning from data provided, for instance the weather, route you around traffic jams, and display personalized ads on your web pages. Throughout my upcoming articles we will learn how to use Azure machine learning in order to create, deploy, and maintain predictive solutions.

 

I will try to share my experience with Machine Learning data which issues I faced, solutions we used to resolve our issues. My aim to publish as many articles as possible to share everyday problems and solutions I go through and help you if you face same issues or similar issues with your experiment. So let’s get started with an experiment and ML.

 

To start with, we will create a free Microsoft Machine learning account. How do we create the same follow below steps:

  1. Create a new Microsoft live account from URL https://signup.live.com/
  2. Browse Site https://studio.azureml.net/
  3. Click on “Sign up Here
  4. Select “Sign In” which says “Free Workspace”.
  5. Once you Sign in with your account, you will have a Free Azure ML subscription ready to use.

 

So congratulation, you now have a Microsoft Azure Machine Learning account created with just 5 simple steps and less than 10 mins.

Advantages of this account is:

a.  Currently this is a life time free account from Microsoft

b. You get free 10 GB of storage space which can be used for data processing.

c. You get R and Python scripts support

d. You will Predictive web services support

 

Now, I would like you to go through below options like Project, experiment, Web services, etc to understand what they are. I will go through all of them one by one and explain each one of them in detail in my upcoming articles.

 

Happy Learning!!!!

 

Reference : https://social.technet.microsoft.com/wiki/contents/articles/43800.starting-with-azure-machine-learning.aspx

Search Result returns Document Title instead of Filename

This is one of the know issues for Search in SharePoint ,if you have CU October or later installed on your servers.

Follow below steps to fix the issue:-

1.Go to Central Admin —> Manager Service Application —> Search Service Application.

2.On search administration page,click on Search Schema under Queries and results.

Search Schema

3.Click on Crawled properties and Search for the properties  called Title.

Crawled Properties

4.Once you find the Title property, click on it and edit.

5.Scroll Down and go to mappings to crawled properties.Select the “MetadataExtractorTitle” and move it down to last place,Click OK.

Mapping Crawled

6.Perform an index reset.Click on Index reset and select option to deactivate search alerts, Click OK.

7.After index reset.Click on Content Sources and start full crawl (in my case it was local SharePoint site).

8.Once Full Crawl is completed, Search result will return filename instead of document heading/title.

 

Microsoft Build 2016

 

Hi All,

 

As you all know Microsoft is running a three days BUILD conference starting March 30. Microsoft’s annual Build developer conference runs from March 30 to April 1 in San Francisco. Microsoft Build is Microsoft’s biggest developer event. As per sources this year, Microsoft will talk a lot about cloud and IoT to be the big themes this year.

 

Microsoft will be streaming the Day 1 and 2 keynotes (Wednesday and Thursday from 8:30 a.m. PT to 11:30 a.m. PT) which you can see on same link below.

 

Day 1 starts off with a long keynote with various Microsoft executives, guests, and Microsoft’s CEO, Satya Nadella. This keynote focuses mostly on Windows including new features and new tools for developers. Here is where you will learn what is coming next in Windows 10 for desktop, mobile, Windows 10 on Xbox, HoloLens, and the Internet of Things (IoT).

 The Day 1 and Day 2 keynote starts at 11:30 AM EST which is 9 pm IST and is expected to be Live for around 2.5 hours

 

You might hear a lot about how Microsoft’s HoloLens could change communication via ‘Holoportation’, Microsoft Graph which is a smarter, stickier apps. Microsoft’s multi-pronged strategy for bringing speech to IoT devices, Microsoft’s private preview of Visual Studio Next, Microsoft starts rolling out Office 365 Connectors as part of Groups

 

You can check more details HERE

 

 

Hope you will enjoy it

 

14th March 2016 : Most awaited SharePoint 2016 RTM launched today

 

Hi All,

 

The most awaited SharePoint 2016 RTM launched few minutes back. It is a very important milestone for SharePoint 2016 roadmap. SharePoint 2016 is the 1st version of SharePoint which has most of Hybrid features.

 

SharePoint 16 has revealed lot of new capabilities for end users, SharePoint administrators and developers. Enhanced hybrid Service applications will bring the world closure to Office 365 and Windows Azure.

 

You can learn a lot more through SharePoint Server 2016 reviewer’s guide which has awesome use cases and lot of helpful information around SharePoint 2016. You can even download the trial version of of the SharePoint 2016 RTM.

 

One of the biggest changes in Project Server 2016 is the installation process is that Project Server 2016 runs as a service application in SharePoint Server 2016. The SharePoint Server 2016 MSI file will contain the installation files for Project Server 2016 as well, so a separate installation is no longer required as it was in previous versions of Project Server. Activating Project Server 2016 will require a PID key.

 

On May 4, 2016 there is a live online event to celebrate SharePoint 2016 share roadmap for the future of SharePoint Vnext. Jeff Teper(CVP for OneDrive and SharePoint) will share more indepth and future plans for SharePoint and OneDrive for Business for both on-premises and in the cloud with Office 365. To register your self for this event click here

 

Now few helpful resources for SharePoint Server 2016

Download the RTM Trial.
See what’s new with a demo on Microsoft Mechanics.
Download the reviewer’s guide.
Learn more about cloud hybrid search at hybrid.office.com.

 

Wish you all the best for your future with SharePoint 2016.

MySQL server Replication

Hello Everyone,

Today we are doing mysql replication, for Mysql installation you can refer my previous blogs

for this setup we need to VM installed Mysql, server which contain primary DB will be “Master” & server which has replica of the DB know as a “Slave”

lets start the replication.

=====================================================================

Configure MySQL Master

1) Need to edit “/etc/my.cnf”

[mysqld]
server-id = 1
binlog-do-db=otrs #dbname
expire-logs-days=7
relay-log = /var/lib/mysql/mysql-relay-bin
relay-log-index = /var/lib/mysql/mysql-relay-bin.index
log-error = /var/lib/mysql/mysql.err
master-info-file = /var/lib/mysql/mysql-master.info
relay-log-info-file = /var/lib/mysql/mysql-relay-log.info
log-bin = mysql-bin

2) Restart the mysql service

# service mysqld restart

3) create a Slave user and password. For instance

[root@OtrsMaster ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.1.73-log Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql>

4)

mysql> STOP SLAVE;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> GRANT REPLICATION SLAVE ON *.* TO ‘centos’@’%’ IDENTIFIED BY ‘centos’;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

5) Applied Read only lock on slave

mysql> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (0.00 sec)

5)
mysql> SHOW MASTER STATUS;
+——————+———-+————–+——————+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+——————+———-+————–+——————+
| mysql-bin.000001 | 106 | otrs | |
+——————+———-+————–+——————+
1 row in set (0.00 sec)

6) Note down the file (mysql-bin.000001) and position number (106)

7) Backup Master server database

# mysqldump –all-databases –user=root –password –master-data > masterdatabase.sql

8) After taking the backup Again login to MySQL as root user and unlock the tables

mysql> UNLOCK TABLES;
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye

9) Copy the masterdatabase.sql file to your Slave server using SCP
scp masterdatabase.sql root@192.168.0.220:/root

Configure MySQL Slave

1) Need to edit “/etc/my.cnf”
[mysqld]
server-id = 2
master-host=192.168.0.200
master-connect-retry=60
master-user=sk
master-password=centos
replicate-do-db=otrs
relay-log = /var/lib/mysql/mysql-relay-bin
relay-log-index = /var/lib/mysql/mysql-relay-bin.index
log-error = /var/lib/mysql/mysql.err
master-info-file = /var/lib/mysql/mysql-master.info
relay-log-info-file = /var/lib/mysql/mysql-relay-log.info
log-bin = mysql-bin
max_allowed_packet=20M
query_cache_size=32M
innodb_buffer_pool_size = 256M
innodb_log_file_size = 512M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

2) Import the master database:

mysql -u root -p < /root/masterdatabase.sql

3) # service mysqld restart

4) Log in to the MySQL & run the below commands

mysql> SLAVE STOP;
Query OK, 0 rows affected (0.01 sec)
mysql> CHANGE MASTER TO MASTER_HOST=’192.168.2.220′, MASTER_USER=’centos’, MASTER_PASSWORD=’centos’, MASTER_LOG_FILE=’mysql-bin.000001′, MASTER_LOG_POS=20249;
Query OK, 0 rows affected (0.03 sec)

mysql> SLAVE START;
Query OK, 0 rows affected (0.01 sec)

mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.0.220
Master_User: centos
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000001
Read_Master_Log_Pos: 20249
Relay_Log_File: mysql-relay-bin.000002
Relay_Log_Pos: 4941
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 20249
Relay_Log_Space: 5096
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)
mysql>

If your application & DB server are the same then installed the application on slave server before adding in to it Mysql Slave.

& rsync your application folders with slave server in scenario you will get Mysql replication as well as application  server

[root@OtrsMaster ~]# crontab -l
*/10 * * * * /usr/bin/rsync -avr –progress –delete //var/article/* root@192.168.0.220:/opt/var/article/ 

Fail-over Master to slave

1)flush log if server was master after booting you have to run below command
mysql> flush logs;
Query OK, 0 rows affected (0.01 sec)

2)
mysql> SLAVE STOP;
Query OK, 0 rows affected (0.01 sec)
mysql> RESET MASTER;
Query OK, 0 rows affected (0.01 sec)

3)
mysql>CHANGE MASTER TO MASTER_HOST=’192.168.0.220′;
Query OK, 0 rows affected (0.01 sec)
mysql> SHOW MASTER STATUS;
+——————+———-+————–+——————+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+——————+———-+————–+——————+
| mysql-bin.000001 | 20425 | | |
+——————+———-+————–+——————+
1 row in set (0.00 sec)
mysql>exit

After doing all these settings restart the applications services

[root@OtrsMaster ~]# /etc/init.d/httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]

To make failed server (after rebuilding) again MySQL slave please follow “Configure MySQL Slave” section.

–Sachin.

 

Configure Office Web App 2013 Farm with SharePoint 2013 Farm

 

Hi Friends,

 

Today we will discuss on how to configure Multi Server Office Web Apps farm with a SharePoint farm. Also the specialty of this OWA configuration is that it can work inside and outside of firewall. Normally OWA farms are setup HTTP inside the firewall network(Internal network) and HTTPS outside the network(External world) but using this configuration we will configure HTTPS for both inside and outside network. This will not only decrease additional overhead and configuration but also is recommended by Microsoft to use HTTPS for production environment.

 

We need to meet below pre-requisites before we proceed further:
1. SharePoint farm configured and ready to use
2. Two or more Office Web Apps servers with setup files
3. One certificate for Office Web App
4. If you are using Windows server 2012 R2 then you would need to install latest update for Office Web Apps
5. FQDN name for your Office web app farm e.g.(owa.domain.com) and its DNS entry with Round Robin(You can also configure Windows NLB or a Load Balancer entry for same)

Installation of Office Web App is very simple, You just need to download the installable and execute it on all OWA servers.

Install Office Web apps on all Office Web Apps servers. If you are using Office Web App on Windows Server 2012 R2, you should install latest update for Office Web Apps. You would need an Office Web app certificate imported to IIS
Now Let’s configure Office Web App, Open Windows PowerShell and execute below command
0299

Once the Office Web App farm is configured, open IIS and make sure SSL binding for site HTTP80 has proper certificate attached.
0302

From IIS binding select the certificate and export the .cer file.
You need to import it to central admin manage trust.

To Attach this Office web app farm to SharePoint farm, you need to create a WOPI connection. Open SharePoint PowerShell on SharePoint server and execute below command:

New-SPWOPIBinding -ServerName “officewebapp.domain.com”
0300

Set Wopi zone
0301

Now if you want to add other Office Web App Server to OWA farm, you need to execute below command on existing OWA server
new-officewebappsmachine -machinetojoin “owa2server.domain.com”
0303

Hope this will help you

Configure Workflow Manager 1.0 with SharePoint Server 2013

Hi Friends,

Today we will discuss on how to configure Multi Server Workflow farm with SharePoint farm. Just of your information, you need to access Workflow farm only from WFE and Application servers. This means just like your database server, even workflow servers are not exposed to end users.

We need to meet below pre-requisites before we proceed further:
A. SharePoint farm configured and ready to use
B. Two or more Workflow servers with setup files
C. If you are using Windows server 2012 R2 then you would need update KB2799752(Service bus hotfix) and KB2799754(Workflow manager hotfix)
D. FQDN name for your workflow farm e.g.(Workflow.domain.com) and its DNS entry with Round Robin(You can also configure Windows NLB or a Load Balancer entry for same)

  1. Let’s get started with installation of Workflow Manager 1.0 on Workflow servers. We need installable as shown below
    0261

  2. When you will try to install the workflow.exe file you will be asked to download and install WebPlatformInstaller.exe. Now all the updates and most components are installed through WebPlatforminstaller.

0262

0263

0264

 

  1. Once the WebPlatforminstaller is installed, you need to search for Workflow manager and Workflow manager client and install the same.

0265

0266

0267

0268

0269

0270

0271

  1. Once Workflow Manager and client is installed, I would suggest you to install the updates as well.

0272

0273

0274

0275

0276

0277

0278

  1. Now let’s configure Workflow Server farm. This is very important so please follow steps carefully.
  2. Lets execute the Workflow Manager Configuration Wizard
  3. Select “Configure Workflow Manager with Custom Settings”
    0279

  4. Now provide the SQL server instance name, Authentication, Certificate and SQL Workflow database names
    0280

  5. You need to provide the Workflow service account credentials which will be used to connect to SQL server and for workflow IIS Application pool.
    0281

  6. You would need to provide a Certificate Generation Key. It is just like Passphrase for your SharePoint farm
    0282

  7. Make sure you select “Allow workflow management over http on this computer”
    0283

  8. Along with Workflow Management, you need to configure Service Bus required by Workflow manager
    0284

  9. Make sure you select “use the same certificate generation key as provided for workflow manager”
    0285

0286

  1. Once the Workflow Farm is created, you need to join other Workflow server to the farm. To do so execute the same Workflow configuration wizard and select “Join an Existing Workflow Manager Farm”
    0287

  2. Provide the existing Workflow Farm SQL server instance name, Workflow database name and Service Bus farm database name
    0288

  3. Provide the workflow service account and Certificate generation key used while creating workflow farm.
    0289

  4. Select “use the same service account credentials as provided for Workflow Manager”, then select next
    0290

  5. Once farm other server is joined to workflow farm you will see below
    0291

  6. Once workflow is configured, you need to attach Workflow Farm to SharePoint farm. Make sure you have DNS entry(Workflow.domain.com) for your Workflow farm. If not DNS, you should at least have Host entry for same. Try to browse http://workflow.domain.com:12291 on WFE and Application server, you might see Authentication error.
    0292

  7. Add the URL to Local Intranet and set the Local Intranet zone to “Automatically login with current username and password”
    0293

0294

  1. Now you should be able to browse the workflow farm details, this shows you can connect to workflow farm and it is working fine.
    0295

  2. Now execute below command in SharePoint Powershell
    Register-SPWorkflowService -SPSite “http://sharepointsite” -workflowHostUri “http://workflow.domain.com:12291/” -AllowOauthHttp -ScopeName SharePoint –force
    0296

  3. Now you need to activate the workflow feature on site
    Enable-SPFeature -Identity WorkflowServiceStore –Url http://sharepointsite

  4. In Central Admin > Manage Service Application > Workflow Service Application Proxy
    0297

  5. Open site in SharePoint designer – Select workflow from left pane – select new workflow
    0298
    Note:
    A. Workflow farm can co-locate on SharePoint servers
    B. As per Microsoft articles, for high availability you need to have at least 3 Workflow Server in farm. You cannot have 2 workflow servers in a farm. It has to be 1 or 3.

About Stellar Outlook Toolkit

 

Hi All,

I am using Microsoft Outlook from last couple of years. When working with Outlook, I face number of issues which eats host of my productive time. At times I hare Outlook but I have to reply upon Outlook for my email communication.
Most of the issues are usually caused by Outlook file (PST) that contains all the information is highly sensitive and required a proper management. However, at times, even after so many precautions PST become inaccessible that results data loss.

After searching a lot I tool on Internet but they had some of other issue. Finally I found a tool named Stellar Outlook Toolkit. This tool was a boon to all most of my  Outlook issues. This is one Toolkit\Utility which I would recommend not just to individual but also organization for their Outlook management.

There are plenty of methods available that let you to keep the integrity of your PST file intact and also help to manage the stored data. Now, the question arises is which one brings the most reliable and safe solutions to provide Outlook file management task. This review is about a reliable Outlook Email Toolkit that includes all utilities to optimize and manage an MS Outlook Profile.

‘Stellar Outlook Toolkit’ has six utilities which are designed to manage and optimize the regular functions of an Outlook profile, such as repair, backup, split or compact a large PST file, etc. These tools is basically for individual, small or big enterprises that have hundreds of Outlook profiles to manage and need to perform multiple tasks to optimize and manage those profiles.

Highlights of utility in Stellar Outlook Toolkit :
Outlook PST Repair
Stellar Outlook Toolkit has a specialized feature that helps users to restore data from an inaccessible Outlook PST file. This module repairs all corrupt PSTs along with all the mailboxes and the mail items while keeping their original state intact.
Outlook Mail Backup
In order to keep Outlook data safe from further corruption this utility lets you to take  backup of all the Outlook mail items, such as messages, attachments, calendar, journals, contacts, tasks and notes. You are also allowed to take incremental and differential backup as well.
Split PST
Split PST can divide a large sized PST into multiple smaller parts to reduce PST size. You can import these parts into Outlook profile and use normally. Additionally, you can split a large PST file according to Date, Size, Mail Id and mail Folder.
Compact PST
Compaction is another way to reduce the size of a growing PST file. This tool has a compact module that lets you to compress a large PST file so that the consequences of an over-sized PST can be avoided. With this module you can compact both the PST and OST files that automatically reduces the chances of unexpected crash.

Outlook duplicate remover
This utility filters and removes duplicates and junk mails from a MS Outlook profile so that a little part from the overall size of Outlook mail account can be emptied.

Outlook Password Recovery
This tool also lets you to recover lost passwords of your Outlook account. The software provides you six set of passwords that can be used to unlock the Outlook account.

This unique suite of applications avail you all modules required to manage an Outlook profile. This single toolkit can handle all the Outlook management related tasks. Although, it is quite time consuming but the result will be satisfactory. Its easy interface lets you to perform all the tasks efficiently without any hassle.

Conclusion:
Overall Stellar Outlook Toolkit is a perfect solution in order to manage and optimize multiple Outlook profiles without hassle. It is a single solution for those professionals who regularly manage multiple Outlook profiles and are responsible for all the information stored in these profiles.

Link to check more about this toolkit:
http://www.stellaroutlooktools.com/scan/toolkit-for-outlook.php

SharePoint 2016 Farm configuration issue on Windows Azure Virtual Machine

Hi All,
I hope you all know that now we can create a SharePoint 2016 VM on Windows Azure. In case you have not tried it yet, you can follow below:

Select New on Windows Azure > Compute > Virtual Machine > From Gallery > Select SharePoint from left hand navigation > Select SharePoint Server 2016 IT preview
0240
0241
While I was working with this VM, I came across an issue where I was unable to configure a SharePoint 2016 farm using the SharePoint 2016 VM created in Windows Azure using one of their template. I found that root of issue was Active Directory. SharePoint cannot work without active directory and not everyone using Azure creates a VM with AD in Windows Azure itself. If you plan to create an AD forest in Azure and then add SharePoint 2016 VM to that domain, please follow my article:

Creating a Lab on Windows Azure
http://blogs.msdn.com/b/mvpawardprogram/archive/2015/02/09/creating-a-lab-on-windows-azure.aspx

 

If you are planning to use this VM only for learning purpose then you may want to create a SharePoint farm without Active Directory. Unlike previous versions of SharePoint, you cannot use Single Server install model to create a SharePoint farm without Active Directory or without installing SQL server.

0242

 

 

To overcome this issue you need 1st install SQL Server and then use below PowerShell command to configure your SharePoint farm. You can download SQL server from below link

https://www.microsoft.com/en-in/download/details.aspx?id=42299 

 

Once SQL server is installed and your local admin account has access to SQL server, you can use SharePoint PowerShell to create tour SharePoint 2016 Farm.
1. Open SharePoint PowerShell as Admin
2. You may want to type below command and provide actual values. When you execute the command, you will be requested for credentials of your local admin account you used while creating this Virtual Machine.
New-SPConfigurationDatabase -DatabaseName “SP2016_config” -DatabaseServer “Name of SQL Server” -Passphrase (ConvertTo-SecureString “Sharepoint@2016” -AsPlainText -force) -LocalServerRole SingleServerFarm -FarmCredentials (Get-Credential)

0243

Note: I have observed that when people try to copy paste such commands, hyphen(-) sign does not work, so remove and add these sign again in whole command.

Once above command is executed successfully without any issue, you can execute SharePoint PSconfig wizard and complete SharePoint farm configuration.

Hope this will help you.