Guest User

Untitled

a guest
Feb 7th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. function password
  2. {
  3. $chars1 = [Char[]]"ABCEFGHJKLMNPQRSTUVWXYZ"
  4. $chars2 = [Char[]]"abcdefghijkmnopqrstuvwxyz"
  5. $chars3 = [Char[]]"@#$%&"
  6. $chars4 = [Char[]]"1234567890"
  7.  
  8. $passwd1 = ($chars3+$chars4 | Get-Random -Count 2) -join ""
  9. $passwd2 = ($chars4 | Get-Random -Count 1) -join ""
  10. $passwd3 = ($chars1+$chars2+$chars3+$chars4 | Get-Random -Count 11) -join ""
  11. $password = $passwd1+$passwd2+$passwd3
  12. return $password
  13. }
  14. password # Calling password function
  15. $loginid = "$databasename.db"
  16. Write-host "DB login password is "+ $password # password used for DB login ID
  17. try
  18. {
  19. $parameters_dbcreation=@{server=$sqlserver;database=$databasename;sqlusername=$sqlusername;sqlpassword=$sqlpassword;loginid=$loginid;loginpassword=$password;IntegratedSecurity=$IntegratedSecurity}
  20. &".\dbcreation.ps1" @parameters_dbcreation
  21. }
  22. catch
  23. {
  24. write-host "Caught an exception !!" -ForegroundColor Red
  25. write-host "Exception Type: $($_.Exception.GetType().FullName)" -ForegroundColor Red
  26. write-host "Exception Message: $($_.Exception.Message)" -ForegroundColor Red
  27. }
Add Comment
Please, Sign In to add comment