Suljettu

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.

Taidot: Microsoft SQL Server, Windows Server, Powershell

Näytä lisää: dedicated server ssl installation, windows server 2003 installation configuration, hcl server raid installation, complete server 2003 installation configuration, virtual private server privacy installation, ubuntu server post installation, ububtu server tomcat installation directory, price windows server 2003 installation config pakistan, oracle application server 10g installation freelancer uae, pptpd centos server linux installation, red server web installation, window server 2003 installation configurations, amazon ec2 sql server self installation, ray media server linux installation, asterisk server client installation working, avs server linux installation, sql free trial installation issues, sql server 2008 installation

Tietoa työnantajasta:
( 1 arvostelu ) Osasco, Brazil

Projektin tunnus: #27558540

1 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_23% %project_currencyDetails_sign_sub_24% tähän työhön

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 7 päivässä
(0 arvostelua)
0.0