1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
|
##################################################################################################
# @author : Mikedavem
# @Description :
# -->Désactiver des Canaux nommés [ Name pipe (np)]
# -->Désactiver mémoire partagées [ Shared memory (sm)]
# -->Désactiver protocole via [via]
# -->Activation du protocole TCPIP
# -->Activation du protocole TCPIP
# @Modify by : Etienne ZINZINDOHOUE
# @OS : WXP
# @SQL SERVER : SQL SERVER 2008
# @ Date : 2010-06-03
# @Comments :
# --> Pour SQL SERVER 2005 il faut remplacer
# -namespace "root\Microsoft\SqlServer\ComputerManagement10"
# par
# -namespace "root\Microsoft\SqlServer\ComputerManagement"
#
# --> Pour une instance nommée remplacé
# InstanceName='MSSQLSERVER'
# par
# InstanceName='NomInstance'
# ET
# ServiceName='MSSQL'
# par
# ServiceName='MSSQL`$NomInstance'
# --> Pour avoir la liste des services sous SQL SERVER 2008 faire :
# Get-WmiObject `
# -namespace root\Microsoft\SqlServer\ComputerManagement10 `
# -class SqlService | Select-Object ServiceName, DisplayName, SQLServiceType, State
##################################################################################################
Write-Host -NoNewLine "########################################################"
Write-Host -NoNewLine " Désactiver des Canaux nommés [ Name pipe (np)] "
Write-Host -NoNewLine "########################################################"
$protocol = Get-WmiObject -namespace "root\Microsoft\SqlServer\ComputerManagement10" -class ServerNetworkProtocol -filter "ProtocolName='np' and InstanceName='SQL2K8INSTANCE2'" -ErrorAction "silentlycontinue";
$protocol.SetDisable();
Write-Host -NoNewLine "########################################################"
Write-Host -NoNewLine " Désactiver mémoire partagées [ Shared memory (sm)] "
Write-Host -NoNewLine "########################################################"
$protocol = Get-WmiObject -namespace "root\Microsoft\SqlServer\ComputerManagement10" -class ServerNetworkProtocol -filter "ProtocolName='sm' and InstanceName='SQL2K8INSTANCE2'" -ErrorAction "silentlycontinue";
$protocol.SetDisable();
Write-Host -NoNewLine "########################################################"
Write-Host -NoNewLine " Désactiver VIA (via) "
Write-Host -NoNewLine "########################################################"
$protocol = Get-WmiObject -namespace "root\Microsoft\SqlServer\ComputerManagement10" -class ServerNetworkProtocol -filter "ProtocolName='via' and InstanceName='SQL2K8INSTANCE2'" -ErrorAction "silentlycontinue";
$protocol.SetDisable();
Write-Host -NoNewLine "########################################################"
Write-Host -NoNewLine " Activer TCP "
Write-Host -NoNewLine "########################################################"
$protocol = Get-WmiObject -namespace "root\Microsoft\SqlServer\ComputerManagement10" -class ServerNetworkProtocol -filter "ProtocolName='tcp' and InstanceName='SQL2K8INSTANCE2'";
$protocol.SetEnable();
Write-Host -NoNewLine "########################################################"
Write-Host -NoNewLine " Redémarrer service SQL "
Write-Host -NoNewLine "########################################################"
$sqlservice = Get-WmiObject -namespace "root\Microsoft\SqlServer\ComputerManagement10" -class SqlService -filter "ServiceName='MSSQL`$SQL2K8INSTANCE2'" -ErrorAction "silentlycontinue";
$sqlservice.StopService();
$sqlservice.StartService(); |
Partager