Posts

Showing posts from March, 2016
<# .SYNOPSIS The purpose of this script is to gather details from the DBA installer to customize their SQL Server install.  This script will produce a configuration ini file and will launch a SQL Server silent Install.  After the silent instal, a basic check is done to ensure the new instance is created.  If the new instance exists, the port number is changed from dynamic to static, firewall rules are updated with the new port information, sa account is disabled, and the polkj11 account is created. .DESCRIPTION This script will gather the following information: 1.) Named or Default instance 2.) SQL Server Service Account Name 3.) SQL Server Service Account Password 4.) SQL Agent Service Account Name 5.) SQL Agent Service Account Password 6.) Integrated SErvices Service Account Name 7.) Integrated Service Service Account Password 8.) Alternate SA account Name 9.) SA / Alternate SA Password 10.) DBA Privileged Group ...