#set account username and password
function Set-Password($computerName, $serviceName, $serviceAccount, $password)
{
invoke-command -computerName $computerName -ScriptBlock `
{ param($computerName, $serviceName, $serviceAccount, $password); `
write-host "on computer " $env:ComputerName "working on " $serviceName; `
$filter = "Name='" + $serviceName + "' "; `
$sqlservice=Get-WMIObject win32_service -filter $filter;`
$result = $sqlservice.change($null,$null,$null,$null,$null,$null, $serviceaccount,$password,$null,$null,$null);`
if ($result.ReturnValue -eq 0) { write-host $computerName " done!"; } else { write-host $computerName " failed!"; } `
} `
-ArgumentList $computerName,$serviceName,$serviceAccount,$password `
}
# move cluster
function Move-Cluster($computerName)
{
invoke-command -computerName $computerName -ScriptBlock `
{ `
import-module failoverclusters;`
$result = Move-ClusterGroup sqlgroup;`
write-host "owner node = " $result.OwnerNode; `
$result = Move-ClusterGroup sqlgroup;`
write-host "owner node = " $result.OwnerNode; `
}
}
#test connection
function Test-Connection($servername)
{
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection;
$SqlConnection.ConnectionString = "Server=$servername;Database=master;Integrated Security=True";
try
{
$SqlConnection.Open();
write-host "$servername connection OK."
}
catch
{
write-host "$servername connection failed"
write-host $error[0]
}
finally
{
$SqlConnection.Close();
}
}
Saturday, March 2, 2013
SelfNote: PowerShell scripts
the following three functions are use PowerShell to set password, move cluster, and test connection to a database server.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment