Problem running WSUS maintenance script
ok, wsus running on windows server 2008 r2 without problems. server has sql server 2008 r2 running well. windows 10 coming soon, it's time prepare wsus deal it. windows 10 categories checked in wsus console. seems wsus refer windows 10 windows vista. , don't want that, tried fix according page http://titlerequired.com/2015/07/22/windows-10-on-wsus-shows-as-windows-vista/
i composed sql script, won't run. command run script looks this: sqlcmd -i -i wsusdbmaintenance.sql -s \\.\pipe\mssql$microsoft##ssee\sql\query
wsusdbmaintenance.sql being script responsible for, among maintenance, renaming windows 10 to, well, windows 10.
thing is, there's no database engine called microsoft##ssee on box. if check sql server management studio, there's database engine called <servername> holding susdb. specifying <servername> instead of microsoft##ssee results in same error message "named pipes provider: not open connection sql server". tried fiddling name removing the mssql$ part, specifying susdb etc. won't budge.
it's probably something overlook, how can script running?
you're not using internal wsus db, have full sql database sound of it
by default, named pipes disabled in sql installations security reasons. can either enable named pipes wouldn't recommend. can open susdb in sql management studio , run .sql script right there within gui. or if insist of running via command line, need change syntax:
sqlcmd -i -i wsusdbmaintenance.sql -s <servername>\susdb
Windows Server > WSUS
Comments
Post a Comment