Monday, 22 November 2010

Trusted Connection Setup - SQL Server 2008

To setup a trusted connection

1. Open SQL Server Management Studio
1.1 Login to the correct SQL Server Instance as SA
2. Right click on Security
2.1 Create new user (make sure to select windows authentication
3. Apply the correct security to the user
4. Give user access to the correct DB's

Trusted conenction is needed for users to access the database especially via Excel Data Sources.

Monday, 15 November 2010

Sophos Enterprise Console - Updating License Details

To update the License details for Sophos



1. Open EM Library
2. Click on EM Library (Servername\Sophos\)
3. Click on Select Parent
4. Click on Select Access
5. Set the username/password
Click on OK

Error Messages occurred.....

Wednesday, 10 November 2010

Ubuntu Netbook Remix 10.10 & Calibre Ebook Manager

Sudo apt-get install xdg-utils
sudo python -c "import urllib2; exec urllib2.urlopen('http://status.calibre-ebook.com/linux_installer').read(); main()"

You will find the App in Applications -> Office -> Calibre

Thursday, 4 November 2010

Printer Migrator

Download & Run Printer Migrator on the machine that you want to copy printers & their drivers from.

BACKUP from the machine you want to copy from
RESTORE on the new machine

if you get an error message that prevent you from installing - disable the kernel mode drivers

Kernel Mode Drivers (version 2) are blocked on the target machine

Symptom: When trying to restore printers using Printer Migrator on a windows 2003 server, you may receive this message: “WARNING: Kernel Mode Drivers (version 2) are blocked on the target machine. Disable Kernel Mode driver blocking and re-run Printer Migrator…”

Solution: To disable Kernel Mode driver blocking, following these steps:

1. Run Local Group Policy. Open Run and type gpedit.msc

2. Explorer Computer Configuration,

3. Select Administrative Templates,

4. click Printer.

5. On the Right pane, right-click on "Disallow installation of printers using kernel mode drivers"

6. Select Properties and check Disabled.

7. Click OK to close the Local Group Policy.

Tuesday, 2 November 2010

Microsoft Dynamics GP - Add-on Software

Installing ABR - Advanced Bank Reconsiliation

- Run the installer but point it to install into the GP Instance that you want it to be installed to ie:

Hong Kong Company

D:\Microsoft Dynamics\GP2010$BHHKG\

Monday, 1 November 2010

Blackberry Torch - Enterprise Activation



Blackberry Torch Activation:

Click on the Home Screen --> click on “Setup”
Click on “Email Accounts”
Enter full email address and password --> activate.

OR

Try Options > Device > Advanced System Settings > Enterprise Activation.

HP Proliant - Post Error: 1792 Drive Array Reports Valid Data found in Arary Accelerator

POST Error: 1792-Drive Array Reports Valid Data Found in Array Accelerator... ...Data will automatically be written to drive array.

Possible Cause: Power was interrupted while data was in the array accelerator memory. Power was then restored within several days, and the data in the array accelerator was flushed to the drive array.

Action: No action is required. No data has been lost. Perform orderly system shutdowns to avoid leaving data in the array accelerator.

1792 Error Message Error Message: 1792-Drive Array Reports Valid Data Found in Array Accelerator...

...Data will automatically be written to drive array.
Audible Beeps: None
Possible Cause: Audible Beeps: None Possible Cause:

Power was interrupted while data was in the array accelerator memory. Power was then restored within several days, and the data in the array accelerator was flushed to the drive array.
Action: No action is required. No data has been lost. Perform orderly system shutdowns to avoid leaving data in the array accelerator.

HP Proliant Server Troubleshooting Guide

http://h20000.www2.hp.com/bc/docs/support/SupportManual/c00300504/c00300504.pdf