Encerrado

SQL Server 2019 installation with DSC

Good morning.

I am looking for an experienced professional to perform an SQL Server 2019 installation WITH ***PowerShell Desired State Configuration***.

I will supply you 1 (Windows Server 2019 Server Core) VM to install SQL Server 2019 on.

I prefer PowerShell Core DSC over regular PowerShell DSC.

The main deliverable is 1 PowerShell DSC script which should perform all the installation and configuration tasks, from a cleanly installed Windows Server 2019 Server Core VM to a completely installed and configured SQL Server setup. This includes installing the Windows and SQL Server pre-requisites.

These are the components/settings you need to install/configure with the PowerShell DSC script:

-- SQL Server Database Engine and Full Text Search

- Collation

- Instance Name and Instance Id

- Instance Root directory

- Shared Features directory

- Shared Features directory (x86)

- SQL Server (domain) service account

- SQL Server Agent (domain) service account

- Auto-start of the SQL Server service

- Auto-start of the SQL Server Agent

- Auto-start of the SQL Server Browser

- Grant Perform Volume Maintenance Tasks privilege

- Mixed Mode authentication (with current user as administrator; and sa password)

- Data directory

- Logs directory

- TempDB directory

- Quantity and size of TempDb datafiles

- Size of TempDb logfile

- MaxDop number

- Allow remote connections

- Use Named Pipes and TCP/IP for SQL Server

Preferrably I would like these ones given by the user (console input or configuration file):

- Collation

- Instance Name and Instance Id

- SQL Server (domain) service account

- SQL Server Agent (domain) service account

- SA password

- Data directory

- Logs directory

- TempDB directory

- Quantity and size of TempDb datafiles

- Size of TempDb logfile

- MaxDop number

After your delivery, I will run the PowerShell Desired State Configuration script on my other server and expect to get one SQL Server installed, configured, and fully working, according to the abovementioned requirements.

Please place your bids.

Thanks.

Habilidades: Microsoft SQL Server , Servidor Windows, Powershell

Sobre o Cliente:
( 3 comentários ) Osasco, Brazil

ID do Projeto: #27558540

1 freelancer está oferecendo em média $22 para esse trabalho

mokcseiu

Hi, I have a 9+ years experience in sql server 2008r2 to 2019, installation, sql/PL, administration. I read carefully in your requirement so i'm very interested with discussion on your project Thanks

$22 USD in 7 dias
(0 Comentários)
0.0