Per Powershell eine Verbindung zum SQL Server und AD Benutzer anlegen

Import-Module ActiveDirectory

######## Edit Here ########

# Path to create users in
$path="OU=_Benutzer-Import,DC=xx,DC=xx"  
$user="pinneberg"  
$PWD="12345"  
$database="Pinneberg"  
$dataSource="S070"  

# Connection string to SQL Server database
#$connectionString = "Server=s070;Initial Catalog=AdventureWorks2012;Integrated Security=SSPI;"  
$connectionString = “Server=$dataSource;uid=$user; pwd=$pwd;Database=$database;Integrated Security=False;”

# Select statement to return new user accounts
# Needs to return "sAMAccountName" & "Password" columns  
# Note: Other columns names should match AD attribute name
$sql="SELECT LEFT (REPLACE(Vorname + '.' + Nachname,' ',''),20)  as sAMAccountName,  
		Vorname + '.' + Nachname + '@kit.pi' as userPrincipalName,  
		Vorname as givenName,
		Nachname as sn,
		Berufsbezeichnung as title,
		Telefon as telePhoneNumber,
		Strasse + ISNULL(CHAR(13) + CHAR(10) + Hausnummer,'') as streetAddress,  
		Stadt as l,
		Bundesland as st,
		Postleitzahl as postalCode,
		Emailadresse as mail,
		Firma as company,
		Abteilung as department,
	    Land as co,
		Webseite as wWWHomePage,
		Kennwort as Password
FROM [Pinneberg].[dbo].[vEmployee]"  

###########################

$cn = new-object system.data.sqlclient.sqlconnection
$cn.ConnectionString = $connectionString
$cn.Open()
$cmd = New-Object System.Data.SqlClient.SqlCommand
$cmd.CommandText = $sql
$cmd.connection = $cn
$dr = $cmd.ExecuteReader()

$colCount = $dr.FieldCount
$sAMAccountNameOrdinal = $dr.GetOrdinal("sAMAccountName")  
$PasswordOrdinal = $dr.GetOrdinal("Password")  

while ($dr.Read()) {
	# Get value of sAMAccountName column
	$sAMAccountName = $dr.GetValue($sAMAccountNameOrdinal)
	# Get value password column (converted to secure string for New-ADUser Cmdlet)
	$password = ConvertTo-SecureString -AsPlainText $dr.GetValue($PasswordOrdinal) -Force
		
	write-host "Creating user account..." $sAMAccountName  

	$otherAttributes = New-Object System.Collections.HashTable

	# Create a hash table of attribute names and attribute values
	# Used to populate other attributes. 
	for($i=0;$i -le $colCount-1;$i++)
	{
		$attribute = $dr.GetName($i)

		switch ($attribute)
		{
			"Password"{} 		#Ignore  
			"SAMAccountName" {} 	#Ignore  
			default{
				$otherAttributes.Add($attribute,$dr.GetValue($i))
			}
		}
	}
	# Create Active Directory User Account
	New-ADUser -sAMAccountName $sAMAccountName -Name $sAMAccountName -Path $path -otherAttributes $otherAttributes -Enable $true -AccountPassword $password 

}

$dr.Close()
$cn.Close()