View Single Post
Old 01-24-2008   #2 (permalink)
Robin Moffatt


 
 

Re: start-psjob - user credentials

Got around it by using
$server = New-Object 'Microsoft.sqlserver.management.smo.server'
$server_path
$server.ConnectionContext.LoginSecure = $false
$server.ConnectionContext.login = $db_user
$server.ConnectionContext.password = $db_pw

I'd still like to understand how authentication under psjobs works
though, if anyone can explain it.
My System SpecsSystem Spec