Archive for November, 2012

Computer doesn’t find updates on WSUS or can’t install them

Command to search for updates:
wuauclt.exe /detectnow

Following steps solve most of the problems:
1. net stop wuauserv
2. delete everything in: 
    %windir%\SoftwareDistribution\
3. delete logfile:
    %windir%\WindowsUpdate.log
4. net start wuauserv
5. wuauclt.exe /detectnow /resetauthorization
6. Check %windir%\WindowsUpdate.log for errors

No Comments »

admin on November 29th 2012 in IT, Windows

How to connect to the WSUS SQL Database

1. Install SQL Management Studio on the Server
2. Run it and use following string as your server:
    \\.\pipe\mssql$microsoft##ssee\sql\query

No Comments »

admin on November 29th 2012 in IT, MSSQL

WSUS Error 364–BITS HTTP 1.1 Range Requests

Error Message:
Content file download failed. Reason: The server does not support the necessary HTTP protocol. Background Intelligent Transfer Service (BITS) requires that the server support the Range protocol header.

You need to configure your firewall that it supports HTTP 1.1 ranges requests. Unfortunately I couldn’t reach our Firewall Administrator and I had to search for a temporary solution on my own.
You just need to change the settings, so that the BITS is working in foreground mode.

Temporary Solution Steps:
1. Install SQL Management Studio and run it
2. Connect to the DB:
\\.\pipe\mssql$microsoft##ssee\sql\query
3. Run following command on SUSDB:
UPDATE tbConfigurationC SET BitsDownloadPriorityForeground=1
4. Restart Windows Update Service

Notice:
The solution above worked for me on Windows 2008 R2 Server. But actually you could probably also do it with the solution below.  The advantage of it would be that you don’t need to install SQL Management Studio on the Server.

Solution for Windows 2012:
1. Download and install following packages from Microsoft SQL Server 2012 SP1 Feature Pack
DEU\x64\sqlncli.msi
DEU\x64\SqlCmdLnUtils.msi
2.  Create a SQL query file “C:\Temp\WSUS_SetBitsDownloadForeground.sql” with following content:
USE SUSDB;
UPDATE tbConfigurationC SET BitsDownloadPriorityForeground=1;
3. Run the query on the Windows Internal Database (WID):
C:\Program Files\Microsoft SQL Server\110\Tools\Binn>SQLCMD.EXE -S \\.\pipe\Microsoft##WID\tsql\query -i C:\Temp\WSUS_SetBitsDownloadForeground.sql
4. net stop wuauserv
5. net start wuauserv

No Comments »

admin on November 29th 2012 in IT, MSSQL, Windows Server

How can I determine SQL Server INstance Name?

Check in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names

No Comments »

admin on November 28th 2012 in IT, MSSQL

Recursive Search Powershell

Short example:
dir –R –I *.exe

Long one:
Get-ChildItem -recurse –include *.exe

Search inclusive text:Get-ChildItem -recurse *.exe | Select-String searchtext

No Comments »

admin on November 27th 2012 in IT, PowerShell

Make all files visible in Mac OSX Finder

Run following command in terminal:
defaults write com.apple.finder AppleShowAllFiles True
killall Finder

To disable it again run:
defaults write com.apple.finder AppleShowAllFiles False
killall Finder

No Comments »

admin on November 19th 2012 in IT, MAC

Make Backup Domain Controller work after Veeam Restore

Today I restored my Exchange Server and virtual Domain Controller but couldn’t get it working because our main Domain Controller wasn’t arround.
To make the second Domain Controller work just set the following setting in the registry and restart the Domain Controller. You might also need to restart all other servers.

image

No Comments »

admin on November 17th 2012 in IT, Windows Server




Check out new movies online website. Download and buy movies now.
1