Step--by-Step Guide :Installing SQL server using PowerShell

Published: 30 October 2023
on channel: Mini SoftTech

1,669

In this video, you are going to be learning about how to install SQL server using PowerShell.

$installerPath = "F:\SQL 2019\Media"
$server='RYU'
$INSTALLSHAREDDIR="F:\SQL 2019\SQL19NEW"
$INSTALLSHAREDWOWDIR='F:\SQL 2019\SQL19NEW'
$INSTANCEDIR='F:\SQL 2019\SQL19NEW'
$SQLTEMPDBDIR='F:\SQL 2019\SQL19NEW'
$SQLBACKUPDIR='F:\SQL 2019\SQL19NEW'
$SQLUSERDBLOGDIR='F:\SQL 2019\SQL19NEW'
$SQLUSERDBDIR='F:\SQL 2019\SQL19NEW'
$SQLUSERDBLOGDIR='F:\SQL 2019\SQL19NEW'

$InstanceName = "SQL19NEW"
$saPassword = "admin@123"

function INSTALL_SQL {

$params="setup.exe /QUIETSIMPLE /IAcceptSQLServerLicenseTerms /Action=install /Features=`"SQL`" /InstanceName=$InstanceName /SQLSVCACCOUNT=`"NT Authority\System`" /SQLSYSADMINACCOUNTS=`"RYU\ryush`" /AGTSVCACCOUNT=`"NT Authority\system`" /SECURITYMODE=`"SQL`" /SAPWD=$saPassword /INSTANCEDIR=`"$INSTALLSHAREDDIR`" /SQLTEMPDBDIR=`"$SQLTEMPDBDIR`" /SQLUSERDBDIR=`"$SQLUSERDBDIR`" /SQLUSERDBLOGDIR=`"$SQLUSERDBLOGDIR`" /SQLBACKUPDIR=`"$SQLBACKUPDIR`" "
$params

$setup=$params|Out-File c:\temp\install.bat -Encoding ascii

#Start-Process -FilePath $installerPath -ArgumentList $params -Verb runas -Wait
cd $installerPath
c:\temp\install.bat

}

INSTALL_SQL

#SQLServer
#PowerShell
#DatabaseInstallation
#SQLServerInstallation
#MicrosoftSQL
#DatabaseManagement
#ServerAdmin
#TechTutorial
#ITAdmin
#SQLServerSetup
#DatabaseAdmin
#SQLDatabase
#InstallGuide
#StepByStep
#ServerConfiguration
#SQLScripting
#DatabaseMaintenance
#DatabaseAutomation
#DatabaseSecurity
#SQLServerExpress
#MicrosoftSqlServer
#DatabaseTutorial
#SysAdmin
#SQLServer2019
#TechHowTo
#SQLServerManagement
#ServerTools
#DatabaseServer
#SQLServerScripts

On this page of the site you can watch the video online Step--by-Step Guide :Installing SQL server using PowerShell with a duration of hours minute second in good quality, which was uploaded by the user Mini SoftTech 30 October 2023, share the link with friends and acquaintances, this video has already been watched 1,669 times on youtube and it was liked by 20 viewers. Enjoy your viewing!

808