Looks like we'll have to use a Query to set the LocalContentCacheLocation value.
We can check the value (like below)
- Open the SQL Server Management Studio and connect to the WSUS DB server.
- Select New Query (or hit CTRL+N)
- Type the following query:
use SUSDB
select LocalContentCacheLocation from dbo.tbConfigurationB - Click Execute to run the query
But how do properly set it to the correct value/path ?
Thanks
You can use wsusutil movecontent:
http://blogs.technet.com/b/sus/archive/2008/05/19/wsus-how-to-change-the-location-where-wsus-stores-updates-locally.aspx
Or, you can use wsusutil reset
https://technet.microsoft.com/en-us/library/cc720466%28v=ws.10%29.aspx?f=255&MSPPError=-2147217396
Or, you can use SSMS, but instead of examining the table/row properties as per your screenshot, select the row and edit the value data.
e.g. right-click dbo.tbConfigurationB and choose select top 1000, then find the row you need and edit the value data to suit. you would need to restart the UpdateService after doing this.
When WSUS+WID is being used for SUP, it's usually a lot simpler and quicker to use wsusutil ;)