DISCLAIMER: I am not a SQL administrator and I have not done this migration.  I have installed Rightfax on servers that had multiple SQL services on it, so this should work.  I am going to perform this procedure in the upcoming weeks so if it blows up, I’ll update the post. 

1. Install SQL 2005

2. Use SQL manager (not sure of exact name. Your DB people should know) to backup rightfax database. Stop the Rightfax services before backing up the database.

3. Use SQL manager to restore rightfax database to SQL 2005

4. Reconfigure the ODBC connection to point to the new location.

1. Go to Enterprise Fax manager.

2. Double Click Rightfax Database Module

3. Click on the three dots under SQL Connection

4. Click the three dots in ODBC Data Source

5. Go to the System DSN tab

6. Configure Rightfax (or whatever naming convention was used)

7. Under SQL server you want to connect to, select the SQL 2005 server\Rightfax. You can find the path by using the SQL manager. It will prompt which server service to connect to.

8. Start the services.

I have a user that did shift delete from outlook.  A co-worker of mine pointed me in the right direction on how to resolve this.

1. Open the registry.
2. Navigate to HKEY_LOCAL_MACHINESOFTWARE\Microsoft\Exchange\Client\Options.
3. Add a DWORD value named DumpsterAlwaysOn and set it to 1.
4. Restart Microsoft Outlook to make the change take effect.

Then from the inbox, you can go to recover deleted items from the Tools tab.

Its as simple as that.  No need for expensive gimmick softwares!

I tip my hat for Antivirus 2009. It is going to become the next wave in spyware. Every version becomes more and more crazy it is not even funny! I read these support sites about people paying for this garbage. Well, let me tell you how to get rid of this sucker! There are a lot of bogus sites out there looking to have you download their shit in order to remove it. Well, I have found a program that does this and you do not have to pay for it. It is a demo version, but that just means that you cannot schedule scans. It still works and it works well!

http://www.download.com/Malwarebytes-Anti-Malware/3000-8022_4-10804572.htm

Run this program and do a full scan. It will find Antivirus 2009 and remove it. For good measure, I also manually remved it. You need to kill the task (usually it has something with 2009 in it running.) and then go to Program Files and delete the directory Antivirus 2009.

The end, your done! Good luck!

I have a mac user that is attempting to use citrix and he keeps getting the following error.

“The archives required to make an SSL connection are not available. Please contact your Citrix Administrator”

The bizzare thing is that he has citrix client installed and everything should work. Well, I did a little bit of searching on the web, and I found the following resolved the issue.

For Web Interface 4.x:

In the Access Suite Console, go to Web Interface > Manage Client Deployment and select the SSL/TLS check box on the Client for Java page.

I also had to enable the Java client as well. This was done in Select Launch Clients area of the install.

See full article here…

So, I do a SHOW PROCESSLIST command in phpMyAdmin, and it shows a ton of SELECT statements that have EXPLAIN in front of every one of them!  Now, I never even heard of the EXPLAIN keyword, so I certainly didn’t do it.

It took me a couple hours to figure out, but PHP was putting it there.  I had turned mysql.trace_mode = On because the comments said it would give me warnings to table/index scans.  It did give me a couple warnings where I didn’t call mysql_free_result(), so I was happy with it.  But apparently it also added EXPLAIN to all SELECT statements in order to get some data out of that.  Well, I don’t want to slow down the database, so I turned that off.  Good to know it’s there I guess, and exactly what it does.

Well, I don’t know about you, but I absolutely, HATE the following error message:

The messaging interface has returned an unknown error. If the problem persists, restart Outlook

I get this when I try to access user’s shared calendars. I have this error occurring on my outlook 2003 and outlook 2007 machines, Since I am the main helpdesk person, clients like to call technical support and complain when the techs are late. The first thing I am supposed to do is check their calendar, and what do you know, I CAN’T!

Well, ranting aside, I did a little bit of research one tip is to turn off standby mode and hibernation mode. Since other apps were failing due to standby as well, I figured I would give that a go first. Granted, just closing outlook and reopening it resolves the issue, but outlook is a beast and I don’t have the energy to wait for it to open while people are yelling at me saying tech 1 is not at the location yet.

If it works, I’ll be sure to update!

The short answer is yes! I had to do this for a user and it was a real pain. Luckily there was only about 30 contacts involved, but it involved a lot of data manipulation to do it. I would of wanted to do this with a couple hundred contacts!

Step 1. Get the al alias.txt from the user directory of the said user. My alias.txt was located at c:\imail\virt_51\users\problemuser
Step 2. Put this file on problem user’s computer
Step 3. Manipulate the data. I used comma delimination to separate the name from the email address and so on.
Step 4. Import the file. In outlook click file, import/export. Follow the directions.
Step 5. Select the comma deliminiated file and search for *.*. You can get around this by actually saving the file the ext of a comma deliminated file, but I didn’t do this.
Step 5. Map the names, email, and whatever else to the proper directory. Click finish and you are done! I had some issues where the email address displayed as the name field but for the most part, I am deeming this project a success!

A client had called me up this morning and stated that his Antivirus is out of date. Of course, he has Symantec and always has issues in this regard. I proceeded to block out a couple of hours since I figured it was a virus that caused the issue. When I tried to run live update, the following error message occurred.

Error: “LU1814: LiveUpdate could not retrieve the update list”

After reading this, I figured, hey, maybe it is not a virus after all! WOOHOOOO! I proceeded to google the message which brought me to the following symantec kb article regarding this.

After skimming through that article, I determined that all those steps were retarded, so decided to go for the last one which is reinstall live update. If nothing else, web 2.0 has brought on a new meaning of reinstalling software. All you need to do is go to that website and everything got updated automatically. The first time I ran through the install, it said I had live update running in the background and needed to terminate. I killed the service and ran it again. This time it prompted me to modify, repair, or uninstall. I chose repair and ran through the install successfully.

One the install was finished, I tried to update symantec. The first time live update opened, it said it had updates for live update (I thought I just installed the most recent version…oh symantec, you slay me!) I went through those updates and finished. I went to update symantec again and this time it worked! Excellent! I kicked off a virus scan (hey, you never know) and told the client to let that run but he should be set. We will see in the upcoming days if there was a virus causing this or just some corrupt file that liveupdate did.

Below is an email provided to me about what occurs after installing SP3 for windows XP. In short, it blows up the ability to run future updates. Well, I would personally hold off on updating XP to SP3 but if you do, keep this little write up in mind….

Hi, Guys, just wanted to warn you all about a problem that I’ve now experienced on three new HP Windows XP computers:

After manually installing SP3 (or after it installs itself via automatic updates?), further updates fail to install, as well as the required automatic update list at windowsupdate.microsoft.com may not be accurate, listing updates you already have.

I’ve resolved this by some combination of these things:

1) Rename the softwaredistribution folder after issuing net stop wuauserv command, then issuing net start wuauserv command
2) Download windows update agent 3.0 and installing it with the /wuforce switch to forcefully overwrite the existing client
3) Re-registering the relevant windows update files, these can be found by googling “updates fail register dll”, i put them in a batch file and ran it:

Net Stop wuauserv
regsvr32 wuapi.dll /s
regsvr32 wups.dll /s
regsvr32 wuaueng.dll /s
regsvr32 wucltui.dll /s
regsvr32 wuweb.dll /s
regsvr32 msxml.dll /s
regsvr32 msxml2.dll /s
regsvr32 msxml3.dll /s
regsvr32 urlmon.dll /s
net start wuauserv
regsvr32 softpub.dll /s
regsvr32 initpki.dll /s
regsvr32 mssip32.dll /s
regsvr32 wintrust.dll /s
regsvr32 dssenh.dll /s
regsvr32 rsaenh.dll /s
regsvr32 gpkcsp.dll /s
regsvr32 sccbase.dll /s
regsvr32 slbcsp.dll /s
regsvr32 cryptdlg.dll /s
regsvr32 jscript.dll /s

According to Symantec, yes you can!  Look at page 100 in the manual for version 11.5.  For those lazy readers, here is the cut out text.

Configuring remote printing
If the host user has configured your printer information in pcAnywhere, you can
print a file that is located on the host computer to a printer at your location
during a remote control session. As you run programs on the host computer, you
can select your printer from the list of installed printers. If the host user has not
configured remote printing, you can print files to the default printer for the host
computer.
When adding a printer, the host user must have the correct drivers for the
remote computer. Symantec pcAnywhere prompts you for the location of the
printer, what port to use, and other configuration information.
To configure remote printing
1 In the pcAnywhere Manager window, on the Edit menu, click Preferences.
2 In the pcAnywhere Options window, on the Remote Printing tab, click Add
Printer.
To find this tab, click the left and right arrows in the pcAnywhere Options
window to scroll through the tabs.
3 Follow the on-screen instructions to set up the information for the printer
on the remote computer.
If the printer that the remote computer uses is not listed, you must install
the drivers first, and then repeat this procedure.
4 Click OK.