Sha256: 128cb360b190aa7f23a293021e5274b9b6e3578ec066f0918713c10b1658776c

Contents?: true

Size: 1016 Bytes

Versions: 64

Compression:

Stored size: 1016 Bytes

Contents

Write-Output "Setting up..."
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlWmiManagement") | Out-Null

Write-Output "Setting variables..."
$serverName = $env:COMPUTERNAME
$instances = @('SQL2008R2SP2', 'SQL2012SP1', 'SQL2014')
$smo = 'Microsoft.SqlServer.Management.Smo.'
$wmi = new-object ($smo + 'Wmi.ManagedComputer')

Write-Output "Configure Instances..."
foreach ($instance in $instances) {
  Write-Output "Instance $instance ..."
  Write-Output "Enable TCP/IP and port 1433..."
  $uri = "ManagedComputer[@Name='$serverName']/ServerInstance[@Name='$instance']/ServerProtocol[@Name='Tcp']"
  $tcp = $wmi.GetSmoObject($uri)
  $tcp.IsEnabled = $true
  foreach ($ipAddress in $Tcp.IPAddresses) {
    $ipAddress.IPAddressProperties["TcpDynamicPorts"].Value = ""
    $ipAddress.IPAddressProperties["TcpPort"].Value = "1433"
  }
  $tcp.Alter()
}

Set-Service SQLBrowser -StartupType Manual
Start-Service SQLBrowser

Version data entries

64 entries across 64 versions & 2 rubygems

Version Path
tiny_tds_vagas-1.0.5 test/appveyor/dbsetup.ps1
tiny_tds-1.0.4-x86-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-1.0.4-x64-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-1.0.4 test/appveyor/dbsetup.ps1
tiny_tds-1.0.3-x86-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-1.0.3-x64-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-1.0.3 test/appveyor/dbsetup.ps1
tiny_tds-1.0.2-x86-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-1.0.2-x64-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-1.0.2 test/appveyor/dbsetup.ps1
tiny_tds-1.0.1-x86-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-1.0.1-x64-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-1.0.1 test/appveyor/dbsetup.ps1
tiny_tds-1.0.0-x64-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-1.0.0-x86-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-1.0.0 test/appveyor/dbsetup.ps1
tiny_tds-0.9.5.rc.3-x86-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-0.9.5.rc.3-x64-mingw32 test/appveyor/dbsetup.ps1
tiny_tds-0.9.5.rc.3 test/appveyor/dbsetup.ps1
tiny_tds-0.9.5.rc.2-x86-mingw32 test/appveyor/dbsetup.ps1