29 October 2013

Database is Read-Only

Problem: After attaching a database to MS SQL Server, the database is displayed as 'Read-Only'.

Description: I created a folder on volume E:\, and put the database I downloaded from SysAid in the folder. After I attached the database to MS SQL Server, the database was displayed as 'Read-Only'.

Solution: Grant 'Everyone' 'Full Control' access to the folder, then attach it.

24 October 2013

Can NOT send emails to a person from Office Outlook, but can from Outlook Web App

Exchange server email accounts

Can NOT send emails to a person from Office Outlook, but can from Outlook Web App

Cause: Outlook saves a cache (offline) address book. It seems to take one or two days to update the cache. After the update, we can send emails to the person from Outlook.

Solution: We can not wait one or two days before sending emails to the person. Click Tools | Account Settings | Change. Clear the check mark in front of 'Use Cached Exchange Mode'. Re-start Outlook.

21 October 2013

Woodside Copier Driver Installation

Woodside copier driver installation
* Download the driver from Sharp website - MXM260_Win32_SPLC_En_1305a.exe
Note: MXM260_Win32_PCLPS_En_1305a.exe would not work.
* Run it.
* Select 'Connected via network'.
* Select 'LPT1'.
* Add port - 192.168.6.196
* Select 'Custom'. In 'Settings', change 'Raw' into 'LPR' (as long as it is a copier, then change 'Raw' into 'LPR', otherwise you will often meet 'Offline' problem.
* LPR settings - type in 'lp' in Queue Name.
* Done.

14 October 2013

Reset Forgotten MySql root Password Under Windows

http://www.jovicailic.org/2012/04/reset-forgotten-mysql-root-password-under-windows/

If you forgot root password for your MySQL database server running under Microsoft Windows, there is still a way to access your database and even reset your password using the command prompt.
Follow next steps:

1. Stop your MySQL server completely. This can be done from Wamp(if you use it), or start “services.msc” using Run window, and stop the service there.
2. Open your MS-DOS command prompt using “cmd” inside the Run window. Then go to your MySQL bin folder, such as C:\MySQL\bin. Path is different if you use Wamp.
3. Execute the following command in the command prompt:
  mysqld.exe -u root --skip-grant-tables
4. Leave the current MS-DOS command prompt as it is, and open a new MS-DOS command prompt window.
5. Go to your MySQL bin folder again.
6. Enter “mysql” and press enter.
7. You should now have the MySQL command prompt working. Type “use mysql;” so that we switch to the “mysql” database.
8. Execute the following command to update the password:
(UPDATE user SET Password = PASSWORD('your_new_passowrd') 
WHERE User = 'root';)
UPDATE user SET authentication_string = PASSWORD('your_new_passowrd') 
WHERE User = 'root';
However, you can now run almost any SQL command that you wish.
After you are finished close the first command prompt, and type “exit;” in the second command prompt.

You can now start the MySQL service. That’s it.