Skip to content

Instantly share code, notes, and snippets.

@matt40k
Created May 29, 2015 19:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matt40k/7f4cb670e6fba0982723 to your computer and use it in GitHub Desktop.
Save matt40k/7f4cb670e6fba0982723 to your computer and use it in GitHub Desktop.
On my dev machine I only start the SQL Server services just before I start developing, no point wasting resources ;) - this script just makes it easier to start them all up
###
# Start MS-SQL Services
#
# By default I've stopped the MS-SQL servers for performance reasons, if you're
# not going to use it, don't run it. If you do. Run the script first :)
#
###
# Needs to run as administrator
# code from: http://blogs.msdn.com/b/virtual_pc_guy/archive/2010/09/23/a-self-elevating-powershell-script.aspx
#
# Get the ID and security principal of the current user account
$myWindowsID=[System.Security.Principal.WindowsIdentity]::GetCurrent()
$myWindowsPrincipal=new-object System.Security.Principal.WindowsPrincipal($myWindowsID)
# Get the security principal for the Administrator role
$adminRole=[System.Security.Principal.WindowsBuiltInRole]::Administrator
# Check to see if we are currently running "as Administrator"
if ($myWindowsPrincipal.IsInRole($adminRole))
{
# We are running "as Administrator" - so change the title and background color to indicate this
$Host.UI.RawUI.WindowTitle = $myInvocation.MyCommand.Definition + "(Elevated)"
$Host.UI.RawUI.BackgroundColor = "DarkBlue"
clear-host
}
else
{
# We are not running "as Administrator" - so relaunch as administrator
# Create a new process object that starts PowerShell
$newProcess = new-object System.Diagnostics.ProcessStartInfo "PowerShell";
# Specify the current script path and name as a parameter
$newProcess.Arguments = $myInvocation.MyCommand.Definition;
# Indicate that the process should be elevated
$newProcess.Verb = "runas";
# Start the new process
[System.Diagnostics.Process]::Start($newProcess);
# Exit from the current, unelevated, process
exit
}
# Database engine
Start-Service MSSQLSERVER
Start-Service SQLWriter
Start-Service SQLSERVERAGENT
Start-Service MSSQLFDLauncher
# Analysis engine
Start-Service MSSQLServerOLAPService
# Integration engine
Start-Service MsDtsServer110
# Reporting engine
Start-Service ReportServer
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment