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).
- 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.
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.
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:
- Open Regedit.
- Browse to HKLM\System\CurrentControlSet\Services\storflt.
- Change the value of Start from 1 to 4.
- Restart the server & you will no longer get the error.
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.
- Delete the local policy registry subkey. To do this, follow these steps:
- Click Start, click Run, type regedit in the Open box, and then click OK.
- In Registry Editor, locate and then click the following subkey:
- On the Edit menu, click Delete.
- Click Yes to confirm that you want to delete the subkey.
- 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.