Category Archives: InstallationConfiguration

failed to create configuration database

failed to create configuration database

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

 

Advertisements
Add domain office 365_office 365 dns records

Add domain to office 365 and office 365 dns records

Advertisements
Advertisements

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
Advertisements
Advertisements
  • 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
Advertisements
Advertisements
  • 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