You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/database-engine/install-windows/install-sql-server-with-powershell-desired-state-configuration.md
+4-4Lines changed: 4 additions & 4 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -23,9 +23,9 @@ Have you ever gone through the SQL Server installation interface just by selecti
23
23
24
24
What's worse is now the confidence of the entire installation is shaken. "What else did I forget?" you might ask yourself.
25
25
26
-
Read about [PowerShell Desired State Configuration (DSC)](https://docs.microsoft.com/powershell/dsc/overview). By using DSC, you can build one configuration template that can be reused over hundreds and thousands of servers. Depending on the build, you might have to tweak a few of the setup parameters. But that's not a big issue because you can still keep all of the standard settings in place. It eliminates the possibility that you'll forget to enter an important parameter.
26
+
Read about [PowerShell Desired State Configuration (DSC)](https://docs.microsoft.com/powershell/dsc/overview). By using DSC, you build one configuration template that you can reuse over hundreds and thousands of servers. Depending on the build, you might have to tweak a few of the setup parameters. But that's not a significant issue because you can keep all of the standard settings in place. It eliminates the possibility that you'll forget to enter an important parameter.
27
27
28
-
In this article, we explore the initial setup of a standalone instance of SQL Server 2017 on Windows Server 2016 by using the **SqlServerDsc** DSC resource. Some prior knowledge of DSC is helpful as we won't explore how DSC works.
28
+
This article explores the initial setup of a standalone instance of SQL Server 2017 on Windows Server 2016 by using the **SqlServerDsc** DSC resource. Some prior knowledge of DSC is helpful as we won't explore how DSC works.
29
29
30
30
The following items are required for this walkthrough:
SQL Server relies on the .NET Framework. So we need to ensure it's installed before we install SQL Server. The **WindowsFeature** resource is used to install the **Net-Framework-45-Core** Windows feature:
88
+
SQL Server relies on the .NET Framework. So we need to make sure it's installed before we install SQL Server. The **WindowsFeature** resource is used to install the **Net-Framework-45-Core** Windows feature:
89
89
90
90
```PowerShell
91
91
WindowsFeature 'NetFramework45'
@@ -107,7 +107,7 @@ The **SqlSetup** resource is used to tell DSC how to install SQL Server. The par
107
107
> [!NOTE]
108
108
> We don't recommend this configuration in a high-security environment.
109
109
110
-
A full list and description of the parameters available on **SqlSetup** are available on the [SqlServerDsc GitHub respository](https://github.com/PowerShell/SqlServerDsc/tree/master#sqlsetup).
110
+
A full list and description of the parameters available on **SqlSetup** are available on the [SqlServerDsc GitHub repository](https://github.com/PowerShell/SqlServerDsc/tree/master#sqlsetup).
111
111
112
112
The **SqlSetup** resource installs only SQL and **doesn't** maintain the settings that are applied. An example is if the **SQLSysAdminAccounts** are specified at installation time, and an admin adds or removes sign-ins to or from the **sysadmin** role. That addition or removal doesn't affect the **SqlSetup** resource. If you want DSC to enforce the membership of the **sysadmin** role, use the [SqlServerRole](https://github.com/PowerShell/SqlServerDsc/tree/master#sqlserverrole) resource.
0 commit comments