Archive

Archive for October, 2010

Connect to WSUS Database Using SQL Server Management Studio Express

October 28, 2010 3 comments

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).
Categories: Computers Tags: ,

Clear the Server Name Dropdown in SQL Server Management Studio Express

October 28, 2010 Leave a comment
  • 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.
Categories: Computers Tags:

Pre-Word 2007 not converting DOCX

October 21, 2010 Leave a comment

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.

Categories: Computers Tags: , ,

Event ID 7026

October 19, 2010 Leave a comment

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

October 7, 2010 Leave a comment

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

Categories: Computers Tags:
%d bloggers like this: