Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Implementing Microsoft SharePoint 2019

You're reading from   Implementing Microsoft SharePoint 2019 An expert guide to SharePoint Server for architects, administrators, and project managers

Arrow left icon
Product type Paperback
Published in Dec 2020
Publisher Packt
ISBN-13 9781789615371
Length 636 pages
Edition 1st Edition
Arrow right icon
Authors (2):
Arrow left icon
Angel Wood Angel Wood
Author Profile Icon Angel Wood
Angel Wood
Lewin Wanzer Lewin Wanzer
Author Profile Icon Lewin Wanzer
Lewin Wanzer
Arrow right icon
View More author details
Toc

Table of Contents (14) Chapters Close

Preface 1. Chapter 1: Understanding Your Current State 2. Chapter 2: Planning and Architecture FREE CHAPTER 3. Chapter 3: Creating and Managing Virtual Machines 4. Chapter 4: Installation Concepts 5. Chapter 5: Farm and Services Configuration 6. Chapter 6: Finalizing the Farm – Going Live 7. Chapter 7: Finalizing the Farm to Go Live – Part II 8. Chapter 8: Post-Implementation Operations and Maintenance 9. Chapter 9: Managing Performance and Troubleshooting 10. Chapter 10: SharePoint Advanced Reporting and Features 11. Chapter 11: Enterprise Social Networking and Collaboration 12. Chapter 12: SharePoint Framework 13. Other Books You May Enjoy

Configuring SQL Server 2017

The foundation of SharePoint is SQL Server. The database server holds all the data related to your SharePoint installation. SQL Server 2019 is also available for us to test during this proof of concept installation. There are big differences in the two versions of SQL due to updates in the 2019 version that support big data.

Let's talk about the differences for a minute to get you up to speed on SQL Server 2016, 2017, and 2019. SQL Server is supported if installed on the same server as SharePoint 2019. SQL Express is not supported as an automatic installation to support your single server installation. In production environments, we like to see SQL on a separate server for performance reasons. 

Installation of SQL Server 2017 can be done on a new platform, which is exciting to see. Linux is now a platform that will support SQL Server 2016, 2017, and 2019, which you can now run on the Linux operating system. What does this mean to me? This...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at AU $24.99/month. Cancel anytime