Kapalı

SQL Server 2019 installation with DSC -- 2

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

You should also deliver a textfile describing the instructions to execute to run the DSC script and how to specify the user-given parameters.

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.

The budget is around USD 30 (plus USD 5 for the fee).

Please place your bids.

Thanks.

Beceriler: Windows Sunucu, Microsoft SQL Server, Powershell

Daha fazlasını gör: read pdf docs sql server, configure sql server connection primavera installation, sql server installation brevard, infopath good front end sql server, odbc sql server asi frontdesk problem installation, amazon ec2 sql server self installation, fedora sql server installation, good sql server back end asp net, mediawiki installation sql server database, sap installation trusted sql server connection administrator, opentaps installation sql server, sql server installation wikipedia, installation setup sql server, sql server 2008 installation, opengts installation sql server, sql server installation, windows server installation and configuration of sql server 2008 with public ip, sql server compact 3.5 service pack 2

İşveren Hakkında:
( 1 değerlendirme ) Osasco, Brazil

Proje NO: #27558633

Bu iş için 6 freelancer ortalamada $139 teklif veriyor

freelancepraful

I can write SQL queries efficiently and have 12+ experience with SQL server and powershell scripts, please contact me asap. you can check my profile.

$35 USD in 3 gün içinde
(1 Yorum)
4.2
OmkarS2020

Hello, I have 8+ years of experience in Database Administration. I can provide support remotely to all type of DBA activities. I have production server working experience on all below listed tasks: SQL Server DBA an Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
3.0
shopshoppy

yeah i can setup yeah i can setupyeah i can setupyeah i can setupyeah i can setupyeah i can setupyeah i can setupyeah i can setup

$140 USD in 7 gün içinde
(1 Yorum)
1.4
(0 Değerlendirme)
0.0
drastigosai19

I have 3+ years of experience as a SQL DBA and my main role is to maintain, setup, Configurations SQL server 2019.

$167 USD in 7 gün içinde
(0 Değerlendirme)
0.0
wzohair

10 USD is fine for the job at hand I like core DSC more too as well, kindly do not hesitate to contact me back for more help / support.

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0