Step--by-Step Guide :Installing SQL server using PowerShell
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