Roku - Error Code 014 - Cannot connect to LAN

When trying to connect to the wireless network I was getting Error Code 014 & a red cross on local network connection.

First make sure your wireless channel is not set to auto, change to number 1, 6 or 11 for example.
Then I also went into a hidden setting on the Roku box to disable pingback.

Press the following on your Roku remote

Press the Home button 5 times
Press the Fast Forward button 1 time
Press the Play button 1 time
Press the Rewind button 1 time
Press the Play button 1 time
Press the Fast Forward button 1 time

This will get you to a hidden settings screen from where you can disable pingback.

Once this is done my Roku box connected fine.

Dell Laptops with McAfee - Exclamation mark on network icon

Exclamation mark on Dell Laptops after uninstalling McAfee, use the above to fix.

Office 2013 crashing on HP Laptop

When launching any of the Office 2013 applications, the splash screen will be displayed, but the application will immediately crash.

This problem has been seen to be caused by certain versions of the third-party DisplayLink User Mode Driver (dlumd32.dll), specifically versions of the dlumd32.dll file lower than 8.7.x.

The HP Docking Station runs on the DisplayLink software.

Update DisplayLink software
http://www.displaylink.com/support/downloads.php

Office 2010 activation fails

If activation wizards fails open an elevated CMD prompt & run ospp.vbs script.

in C:\Program Files\Microsoft Office\Office14

cscript ospp.vbs /act 

or C:\Program Files (x86)\Microsoft Office\Office14 if you have a 64 bit system with 32bit office

(HP) Laptop Plugged in not Charging Battery (Windows 7)

Disconnect AC
Shutdown
Remove battery

Connect AC
Startup
Open Device Manager
Expand the batteries section, uninstall all "Microsoft ACPI Compliant Control Method Battery"
Expand system devices section
uninstall the “ACPI Fixed Features Button"

Shutdown
Disconnect AC
Insert battery
Connect AC
Startup

Windows 7 - How to recover lost or missing system tray icons?

1. Back up the Registry by creating a restore point.
2. Go to Start > Run (or Windows-key + R), type in regedit and hit OK.
3. Navigate to the key HKEY_CURRENT_USER\Software\Classes\Local Settings\Software\Microsoft\Windows\CurrentVersion\TrayNotify.
4. Delete the values IconStreams and PastIconsStream.
5. Open up the Task Manager (Ctrl + Shift + Esc), go to the Processes tab, select explorer.exe and click End Process.
6. Open the Applications tab and click New Task at the bottom-right of the window.
7. In the message box that pops up type in explorer.exe and hit OK.
8. Explorer.exe will reload, and the missing icons should now be back in the system-tray where they belong.

Create Test Company in Sage Manufacturing

Copy your company accdata folder to another location say C:\Test\.
Browse to C:\Programdata\Sage\Accounts\v2012

Then edit the company file with notepad & add the C:\Test to the list of folders.

The test data will now appear when you next run Sage Manufacturing

Reduce Shareweddb_log file size

Use SQL Management Studio & connect to ##SSEE database

Choose the ShareWebDB

New query & run below to reduce log file size

USE ShareWebDb
 GO
 DBCC SHRINKFILE(ShareWebDb_log, 1)
 BACKUP LOG ShareWebDb WITH TRUNCATE_ONLY
 DBCC SHRINKFILE(ShareWebDb_log, 1)
 GO

Connecting to the Windows Internal Database (MICROSOFT##SSEE)

Using SQL Management Studio

The server name to connect to is 
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Remove disconnected mailboxes in Exchange 2007

Get all disconnected mailboxes

Get-MailboxStatistics | where-object { $_.DisconnectDate -ne $null } | Select DisplayName,MailboxGuid

Remove a single disconnected mailbox

Remove-Mailbox -Database -StoreMailboxIdentity -confirm:$false

Remove all disconnected mailboxes

$users = Get-MailboxStatistics | where-object { $_.DisconnectDate -ne $null } | Select DisplayName,MailboxGuid,Database

Then all disconnected mailboxes are in a variable and you run following cmdlet to remove mailboxes

$users | ForEach { Remove-Mailbox -Database $_.Database -StoreMailboxIdentity $_.MailboxGuid -confirm:$false }