try
{
	$roleName = "db_owner"
    $login = New-Object Microsoft.SqlServer.Management.Smo.Login($srv,$loginid)
    $login.LoginType = [Microsoft.SqlServer.Management.Smo.LoginType]::SqlLogin
	$login.PasswordPolicyEnforced = $false
	#$login.PasswordExpirationEnabled = $false
    $login.Create($loginpassword)
    Write-Host("Login : $loginid created successfully with Password : $loginpassword ")
    $dbUser = New-Object  Microsoft.SqlServer.Management.Smo.User($db,$loginid)
    $dbUser.Login = $loginid
    $dbUser.Create()
    Write-Host("DBUser $dbUser created successfully.")

    #assign database role for a new user
    $dbrole = $db.Roles[$roleName]
    $dbrole.AddMember($loginid)
    $dbrole.Alter()
    Write-Host("User $dbUser successfully added to $roleName role.")
}
catch
{
	write-host "Caught an exception !!" -ForegroundColor Red
	write-host "Exception Type: $($_.Exception.GetType().FullName)" -ForegroundColor Red
	write-host "Exception Message: $($_.Exception.Message)" -ForegroundColor Red
	exit
}