Connect to WSUS Database Using SQL Server Management Studio Express

You can use SQL Server Management Studio Express (SQL SMSE) to connect to the internal WSUS database. Do the following.

• If not already done, Install SQL SMSE 2005.
• Launch SQL SMSE.
• In the Server name drop-down type \\.\pipe\mssql$microsoft##ssee\sql\query
• In the Authentication drop-down select Windows Authentication.
• You can now use SQL SMSE to run queries against the WSUS database (SUSBD).

Clear the Server Name Dropdown in SQL Server Management Studio Express

• Browse to C:\Documents and Settings\username\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM.
• Rename mru.dat to mru.bak
• Now open SQL Server Management Studio Express & the Server name dropdown will be empty.

Pre-Word 2007 not converting DOCX

Description – When double clicking a DOCX file you get the “Convert File” dialog box instead of Word just converting the file.

Solution – Cancel the dialog box. Click New to open a blank Word doc. Click Tools>Options. Select the General tab. Uncheck “Confirm conversion at open” & click OK. Close Word the double click the DOCX file again. Word should then convert the file & open it.

Event ID 7026

After installing SP2 for Windows Server 2008 you may receive an eventID 7026 that says, “The following boot-start or system-start driver(s) failed to load: storflt”. If the server is not running Hyper-V then the service is not needed. The error can safely be ignored but if you want to supress the error do the following:

1. Open Regedit.
2. Browse to HKLM\System\CurrentControlSet\Services\storflt.
3. Change the value of Start from 1 to 4.
4. Restart the server & you will  no longer get the error.

Event ID 7023

I had a Windows XP client that was getting the following error:

Event Source: Service Control Manager
Event ID: 7023
Description: The IPSEC Services service terminated with the following error: The system cannot find the file specified.

Solution

• Delete the local policy registry subkey. To do this, follow these steps:
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. In Registry Editor, locate and then click the following subkey:
     HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\ Windows\IPSec\Policy\Local
  3. On the Edit menu, click Delete.
  4. Click Yes to confirm that you want to delete the subkey.
  5. Quit Registry Editor
• Rebuild a new local policy store. To do this, Click Start, click Run, type regsvr32 polstore.dll in the Open box, and then click OK.
• Verify that the IPSEC Services component is set to automatic, and then restart the computer.

Ref - http://support.microsoft.com/kb/912023