# SCRIPT MUST BE RUN AS ADMINISTRATOR
param([string]$SQLInstance)


$SQLInstance = $SQLInstance.ToUpper()

if ($SQLInstance -ilike "*\*")
    {
    $string = $SQLInstance.Split("\")
    $SQLName = $string[0]
    $Instance = $string[1]
    }
else
    {
    $SQLName = $SQLInstance
    $Instance = "MSSQLSERVER"
    }


$SQLName
$Instance

# Load SMO Wmi.ManagedComputer assembly
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlWmiManagement") | out-null

Trap {
  $err = $_.Exception
  while ( $err.InnerException )
    {
    $err = $err.InnerException
    write-output $err.Message
    };
    continue
  }

# Connect to the instance using SMO
$m = New-Object ('Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer') $SQLName


$uri = "ManagedComputer[@Name='$SQLName']/ServerInstance[@Name='$Instance']/ServerProtocol[@Name='Tcp']"
$Tcp = $m.GetSmoObject($uri)
$Enabled = $Tcp.IsEnabled

#Enable TCP/IP if not enabled
IF (!$Enabled)
    {$Tcp.IsEnabled = $true }

#Set to listen on 1433
$m.GetSmoObject($uri + "/IPAddress[@Name='IPAll']").IPAddressProperties[1].Value = "1433"

$TCP.alter()