Installing MSSQL server with standard setup

Sometimes when you are installing the MSSQL Express, you will found out that you missed out changing the collation, change the instance name and other standard settings for the programs that you are distributing.

To avoid patching the SQL server settings, it's better to use a script and all team members to follow. Here is the script that I have came out to setup the MSSQL. The most frequent updating the setting is the collation ... we forgot to change it to our standard before hitting Continue button.

$sql_setup_file = "F:\my-setupFiles\sql2012 express\SQLEXPRWT_x64_ENU.exe "
$db_dir = "F:\my_database"
$bak_dir = "F:\my_database_backup"
$sa_pwd = "1234567890"

$param = "/QUIET /IACCEPTSQLSERVERLICENSETERMS /ACTION=""install"" /FEATURES=SQL,Tools /INSTANCENAME=sqlexpress /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /ERRORREPORTING=0 /SQLBACKUPDIR=""$bak_dir"" /SQLUSERDBDIR=""$db_dir"" /TCPENABLED=1 /INDICATEPROGRESS /SECURITYMODE=SQL /SAPWD=""$sa_pwd"""

Write-Host "Installing SQL server... please wait.."

#start the installation.           
Start-Process -FilePath $sql_setup_file -ArgumentList $param -Wait

Write-Host "SQL installation completed"

Comments

Post a Comment

Popular posts from this blog

Scheduled task in Windows Task Scheduler - part 3

This is the last part of Task Scheduler - security context which is created using New-ScheduledTaskPrincipal. Usually, we are using S4U logon type for any server scheduled task + Highest Run Level. S4U details as per MS documentation: Use an existing interactive token to run a task. The user must log on using a service for user (S4U) logon. When an S4U logon is used, no password is stored by the system and there is no access to either the network or encrypted files. You can find more information in this page:     https://docs.microsoft.com/en-us/windows/win32/taskschd/principal-logontype For any user ID that you specified to run the scheduled task, it requires "Log on as a batch job" or "Log on as a service". You can find the details here:     https://docs.microsoft.com/en-us/windows/security/threat-protection/security-policy-settings/log-on-as-a-batch-job     https://docs.microsoft.com/en-us/windows/security/threat-protection/...
Read more

Create scheduled task in Windows Task Scheduler

Windows Task Scheduler is a utility that helps to execute any process periodically. For example, you want to sync your working files on daily basis, scanning virus, process some data, etc. A task has the following components: Action or multiple actions - which is the process that you want to run periodically. We use New-ScheduledTaskAction to create new action object. Trigger - which is the time to run the process and it can have multiple timing. We use New-ScheduledTaskTrigger to create new trigger. Security context - any process must run in a valid security context. We can set the context using New-ScheduledTaskPrincipal. The following script creates an on demand task which requires user to manually trigger the task. $task_folder = "\myTasks\" $task_name = "myTask2" # this can be any Powershell script. $ps_script_file = "d:\temp5\test-script.ps1" ## The first line will show err if $task_folder does not exist. ## The second line will not...
Read more

Get all website entries in IIS

It's very easy to get the list of the website entries in IIS with 3 lines of code.   Import-Module WebAdministration   cd IIS:\Sites   Get-ChildItem | select name Explanation: 1. We need to import the WebAdministration PS module. This module includes all the necessary API for Powershell to interact with IIS. 2. The second line is to change the current location to IIS Sites folder. 3. Finally, get all the items in the current location.
Read more