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

Popular posts from this blog

Edit Group Policy

Hyper-V VM not reaching OS 'Logon' screen

DNS question...