If SQL isn't prepared correctly, SharePoint simply won't work. Learn how to prepare, configure, and install SQL.
- [Instructor] Now that we have domain accounts prepared…for SharePoint, it's time to make certain…that the SQL server is also prepared.…SharePoint relies heavily on SQL to function,…so having the correct settings and permissions…to access it is important.…Now in this case, I am assuming…that you have the right to administer SQL.…If, in your organization, you do not have the right…to do so and have to reply on your database administrator,…this information could be useful to tell them…what you need, in terms of preparing SQL for SharePoint.…SQL can store and manage databases in separate instances,…called named instances.…
Because the only reason I'm using SQL is…to store my SharePoint databases, and for the sake…of simplicity, I'm going to use the default instance.…Depending on your organization's requirements,…it can be a good idea to implement a named instance…for your SharePoint databases,…rather than just using the default instance.…This can slightly complicate things,…in terms of specifying firewall rules and curve roles.…
CA Callahan takes you through each stage of the process, covering everything from software installation prerequisites, to common topologies and MinRoles, to how to slipstream updates into an installation. Callahan introduces best practices, as well as steps involved in configuring outgoing email, web applications, site collections, managed accounts, and farm accounts. Plus, discover how to use some common tools that experienced administrators use on a day-to-day basis to make the most of their installation efforts.
- SharePoint installation considerations
- Configuring SQL for SharePoint
- Software installation prerequisites
- Using the Installation Wizard
- Installing SharePoint 2016 on additional servers
- Configuring outgoing email
- Configuring a web application and site collection