Tag Archives: InstallationConfiguration

failed to create configuration database

Posted on by
Reply
There is an error “failed to create configuration database” while installing sharepoint 2016 with an addition message “sql server instance does not have the required “max degree of parallelism” setting of 1″.

failed to create configuration database

What is Max Degree of Parallelism ?
When an instance of SQL Server runs on a computer that has more than one microprocessor or CPU, it detects the best degree of parallelism, that is, the number of processors employed to run a single statement, for each parallel plan execution. You can use the max degree of parallelism option to limit the number of processors to use in parallel plan execution. SQL Server considers parallel execution plans for queries, index data definition language (DDL) operations, and static and keyset-driven cursor population.

Read this for more details

http://technet.microsoft.com/en-us/library/ms189094.aspx

How to fix it ?

  1. Open Microsoft SQL Server Management Studio
  2. Login with sysadmin user
  3. Right Click on instance name and select properties >> Advanced
  4. Change Max Degree of Parallelism to 1
  5. Restart the SQL Service

 

Add domain to office 365 and office 365 dns records

Posted on by
Reply

Add domain to office 365 and office 365 dns records

This post describes about how to Add domain to office 365 and office 365 DNS records. You can follow the below steps in office 365 admin center.

  • Log in to Office 365 portal by following the link “https://portal.office.com“.
  • Navigate to “Admin->Setup->Domains” and click on “Add domain“.
Add domain to office 365 1917x511
  • A dialogue box will open. Enter domain name ex: spmcse.com in the field “Add a domain” and click on “Next“.
Add a domain 1919x685
Add a domain
  • You will proceed to “Verify domain” dialogue box where you will find options “verify by” as “TXT record” or “MX record”. Click on “TXT record”. There will be 3 records like “TXT name”, “TXT Value (ex : MS=ms*)”, “TTL”. Copy the “TXT value”.
verify domain 1345x745
  • Navigate to “domain hosting provider” site to update DNS records. Since my domain is from google, i navigate to google domain and click on “DNS” to “Configure DNS”.
Configure DNS 1040x393
  • Scroll down and identify “custom resource records“. you need to paste the “TXT value” here. Enter the details related to “TXT record” as per below screenshot and click on “Add“.
TXT record 846x310
TXT record1 846x328
  • Navigate to the Office 365 admin center again and click on “Verify” under “Verify domain” dialogue box. Verification process will start and will be completed successfully.
Verify domain 1342x772

Close the dialogue box. identify the different records related to “Exchange Online“, “Skype for business“, “Mobile device management for office 365” under the domain setup option which you will get on selecting the domain again as per below screenshot.

dns records 1917x977
  • Navigate to “domain hosting provider” site to update DNS records again. follow the same process for rest of the dns records as we did for “TXT value” of type TXT described above. Enter all dns records as per the screenshot below.
  • For Exchange Online
@ MX MS=ms**** 1h
@ TXT v=spf1 include:spf.protection.outlook.com -all 1h
autodiscover CNAME autodiscover.outlook.com. 1h
  • Skype for Business
sip CNAME sipdir.online.lync.com. 1h
lyncdiscover CNAME webdir.online.lync.com. 1h
_sip _tls SRV 100 1 443 sipdir.online.lync.com. 1h
_sipfederationtls _tcp SRV 100 1 5061 sipfed.online.lync.com. 1h
  • Mobile Device Management for Office 365
enterpriseregistration CNAME enterpriseregistration.windows.net. 1h
enterpriseenrollment CNAME enterpriseenrollment.manage.microsoft.com.  1h
dns records 1011x805
  • Once DNS records updated, navigate to office 365 Admin center and click on the domain to setup domain for next step. Select “I will manage my own DNS records” and click “DNS“. set up will be verified and will be completed finally.
Manage my own domain 917x669
domain setup complete 1315x514

Windows Server Appfabric: Installation error SharePoint 2016

Posted on by
Reply

If you are installing SharePoint 2016 Prerequisites manually downloading the files and after that run the “Install Software Prerequisites” from SharePoint 2016 installation file to verify everything installed manually is correct, you may face error like this “Windows Server Appfabric: Installation error“. sp2016

This is a generic MSI error message and does not give any indication about how to get the issue fixed. Uninstall or reinstalling only makes it worse.

Resolution :

The reason being the prerequisites installs the file and configure it automatically. If we install manually, then we are trying to bypass the configuration, so that error will be received. The issue can be caused due to the following: *  The path to the PowerShell executable that is needed for the AppFabric installation is incorrect. *  In some scenarios, repeated uninstallation and re-installation does not fix the issue. This is because the installer does not remove the PSModulePath entry in Environment *  Variables during uninstallation and the installation fails because the entry already exists. If you are trying to install all the prerequisites manually as the server does not have a connection to internet. Note: Appfabric installation and configuration has to be done by the prerequisite installer ONLY and not in a stand-alone manner.You should follow the manual process of installation  if there is error in automatic process by following Install Prerequisite (prerequisiteinstaller.exe) . You can implement any one of the two solutions listed below Solution 1 Append the following path to PSModulePath entry in the environment variables – %SYSTEMROOT%\System32\WindowsPowerShell\v1.0

  • Go to My Computer, right-click Properties
  • On the System page click Advanced System Settings on the left-side pane.
  • If you receive a UAC prompt, click on Yes to launch the System Properties dialog box
  • From the Advanced tab, click Environment Variables
  • Within the System Variables section in the lower half, select PSModulePath and click on Edit (or double-click PSModulePath‘)
  • Append the following path to PSModulePath entry in the environment variables %SYSTEMROOT%\System32\WindowsPowerShell\v1.0\
  • Ensure that the PSModulePath entry looks like this: C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;c:\Program Files\AppFabric 1.1 for Windows Server\PowershellModules

Solution 2

  • There are chances that other applications might be referencing the same variable and may fail if it is deleted. This is what we can do if solution 1 does not help.
  • Remove the PSModulePath entry from the ‘Environment Variables’ and re-run the installer. Once it completes successfully, ensure that the PSModulePath entry looks the same as mentioned in solution 1.

Reference : https://msdn.microsoft.com/en-us/library/dd878326(v=vs.85).aspx