sql - Intermittent error "a specified logon does not exist" -
new powershell , scripting. have following script intermittently returns system error 1312 a specified logon not exist. may have been terminated.
get-content d:\logbooks.txt | foreach-object {invoke-command -computername $_ -filepath "d:\folder\script.ps1" if (-not$?){write-warning "$_ - sql script failed"} else {write-host "$_ - sql script successful"-foregroundcolor "green"}}
i wrote script execute one.
net use \computername\d$ password /user:username
sqlcmd -s .\sqlexpress -o c:\test.txt -d database -i "\computername\d$\folder\sql script.sql"
i using these execute sql script on remote machines running sql express. computers running windows 7. created second admin account on computer running scripts , using login after net use command. works fine other times error couple of remote computers.
it network issue. continually running script test every little change. attempting reconnect remote computers our small slow network.
Comments
Post a Comment