sql server - Create new sql login by passing encrypted password -
can create sql login in sql server 2008r2 passing encrypted password? using following code.
[system.reflection.assembly]::loadwithpartialname('microsoft.sqlserver.smo') | out-null #assign variables $instance = "inhyddpc120" $loginname = "mynewlogin" $password = "ggrytyrty"#(this has encrypted password) $dbname = "test_smo_database" #get server object $server = new-object ("microsoft.sqlserver.management.smo.server") $instance #get login object if exists $login = $server.logins.item($loginname) if (!($login)) #check see if login exists { #it doesn't, instantiate new login object $login = new-object ("microsoft.sqlserver.management.smo.login") ($server, $loginname) #make sql login $login.logintype = [microsoft.sqlserver.management.smo.logintype]::sqllogin #create on server specified password # $login.policyenforcementenabled = $false # $login.passwordexpirationenabled = $false $login.defaultdatabase = $dbname $login.create($password)
.create
takes securestring. see working passwords, secure strings , credentials in windows powershell how create securestrings in powershell. need use convertto-securestring
.
Comments
Post a Comment