SQL Server 2019 installation with DSC

종료 등록 시간: 3년 전 착불
종료 착불

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.

마이크로소프트 SQL 서버 윈도우 서버 파워쉘 (Powershell)

프로젝트 ID: #27558540

프로젝트 소개

1건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 3년 전

이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 1명, 평균 입찰가: $22

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일 이내)
(0 리뷰)
0.0