Windows

Windows XP – Windows 2003 2008 Server R2 – SQL 2008 Server
MS Office Tips – Applications – Registry Secrets – Browsers

The very first Tech Forum here is Windows

Office 2010 Encountered an Error During Setup – Many Sulutions

2013/03/07
By
Modified: 2013/02/17
Office-2010-Error

You are an expert.  You are almost a god. You can manipulate complex installs and difficult projects.  This time you just want to test Office 2010, and be done with it. [...This article is quickly growing.  There are surprisingly many nuances behind behind this simple facade  ------>] You quickly create a fresh Windows instance, by copying 3 or 4 directories from some backup storage, and you boot into it. Now, you are trying to install a fresh Office 2010 on a fresh install of Windows (any version including XP, Win7 and W2K8 R2). Everything great and dandy, but you are interrupted with this very informative error message: Microsoft Office Professional 2010…

Read more »


Horizontal Line in Excel Header and Footer

2013/03/05
By
Modified: 2013/02/17
Horizontal-Line-in-Excel

  We would like to add a horizontal line to the header of an Excel file to be repeated on every page. To add a horizontal-line we first need to create an image of a horizontal line in your favorite imaging software. Create a PNG image 660 by 3 pixels and color it in some shade of gray.  Save the image with an appropriate meaningful name.  You will be using this file each time you need to add a line to Excel header of footer. Now, insert this image into Excel header: Note that &[Picture] code should be bellow any other code that you have in the header. Now we have…

Read more »

How to Run Malicious Software Removal Tool?

2013/03/03
By
Modified: 2013/02/17
Malicious Software Removal Tool

MRT Just 3 letters you need to know – MRT That is right, just type MRT.exe in you Start – Run box.  Why they hide it so deep?  Why there is no easy answer anywhere on the Internet? The program is located in %WinDir%\System32\MRT.exe Once again, to run Malicious Software Removal Tool type MRT in your  Start – Run box. In this article I am going to: - Accumulate information about annoying files that push themselves in the registry; - Show how to write a small CMD script that will continuously clean your registry Run locations; - Describe how to secure your Internet Explorer to lower possibility of malware infection; -…

Read more »

Count Number of Cell with Errors in Excel

2013/03/01
By
Modified: 2013/02/17

This problem occurs, when you have a column with a formula that sometimes returns an error.  That is very typical for all kind of look-up situations .  Let’s say, you have a column E with formula that returns good values and errors.  You need to count, how many errors are in that column. Enter formula =SUM(IF(ISERROR(E2:E10),1)) and press Ctrl+Shift+Enter while still in editing mode. You should see two things.  First, your formula turns into {=SUM(IF(ISERROR(E2:E10),1))} with square brackets around it, and second, you got you a correct cells with errors count.  This is it. If you need to count cell without errors, you can use this formula: =SUM(IF( NOT( ISERROR(E2:E10)),1 ))…

Read more »

Automate Database Backup with SQL Express

2013/02/21
By
Modified: 2013/02/17
Automate Database Backup with SQL Express

This article describes, how to automate database backup in SQL Express with mixed Windows and SQL Authentication running on Windows 2008 Server.   This material was tested with Microsoft SQL Server 2008 R2 Express. SQL Server 2008 Enterprise comes with Maintenance Plan feature.  That feature allows amazing flexibility and auditing.  SQL Express edition lacks this feature.  But you still need a backup. Backup automation with SQL Express consist of 3 steps: (1) Write the script to backup all your databases. (2) Test the script by initiating it from a command prompt. (3) Schedule the script using Task Scheduler. Here is each step in detail. ` (1) Write the Script This script overwrites…

Read more »

Block PC Outbound Connections on Router Level (All but RDP)

2013/02/19
By
Modified: 2013/02/14
Router-Open-Ports-for-RDP-3389

This article applies to a scenario, when you already can establish RDP to a machine on your internal network from a remote network.  Now you’ve decided to tighten security screws and close all external access to and from that machine except for RDP on the router level. Inbound connections to a server you can block easily using firewall on the machine itself.  This article deals with a situation, when you need to block access for any process or application running on your server to the external resources.  Other machines on your network still would be able to make external connections through the router. Note: It is good a practice to change…

Read more »

Windows 7 Enterprise x64 Evaluation – What was Fixed?

2013/02/17
By
Modified: 2013/01/20

First – the headlines: - – -         Not available through retail channels              – - -         Specifically tailored for business users                      – - - - – -         Designed to the liking of IT professionals       – - -        More Ultimate, than Windows 7 Ultimate itself       – - -   Clean Install So far installation is very similar to regular Windows 7.   Product key is not required for evaluation copy.  Get your RAID x64 drivers available either on hard disk on a USB drive. After first reboot. First order of business…

Read more »

How to Install WordPress 3.2.1 on Windows 7 and IIS 7.5

2013/02/09
By
Modified: 2013/01/20
Pick-IIS-FastCGI-Option

This article is written for those who need to test/evaluate features of new WordPress release on a local machine before rolling it out to all the serves. This article describes running PHP on IIS 7.5 through FastCGI. For best results, reader is required to be able to start and stop services, understand registry manipulations, be comfortable with copy and paste inside a command prompt (Alt+Space, E, P). To achieve better portability, try to match your test machine directory structure as close as possible with your server. Other IIS Features to Pick If you are planning to test old ASP sites on the same machine, you also need to pick: - ASP…

Read more »

IE opens blank new tabs instead of your home page

2013/02/01
By
Modified: 2013/01/20
IE - Blank page on new tab

You have  masterfully designed custom home page for your Internet Explorer (IE).  All of a sudden, only first tab displays your home page.  All other new tabs in IE open as a blank page.  What happened?  Something is changing IE settings  back to “A blank page” ? This particular fix for this article was tested on Win7 x64 with IE9. In a few words, you need to delete this registry entry vprot.exe from location HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Run   A little bit more radical solution is to run a 3 line script on Startup to delete all intruding entries from all 3 possible Startup locations in Registry. This solution is absolutely great, because it…

Read more »

Cisco VPN Client Error 51 – Open Your Firewall

2013/01/30
By
Modified: 2013/01/20
Cisco Error 51

Annoying!  How Annoying! This very simple, very typical error message, but it is so hard to find a quick solution. Symptoms: You are starting a Cisco VPN Client and immediately you are getting this error message: Error 51: Unable to communicate with the VPN subsystem. Please make sure that you have at least one network interface that is currently active and has an IP address and start this application again.     Most of Internet discussions on this error message revolve around MAC OS.  But this error I was able to fix on Windows XP. Quickly – What to Do? Quickly – Open your firewall.  Each firewall solution is different, but…

Read more »

How to Reset Win XP Admin Password

2013/01/28
By
Modified: 2013/01/20

There are two ways to reset forgotten Administrator password. Method one – Reset During Repair Reinstall: Use Win XP installation disk Run Recovery (not Recovery Console) Press Shift+F10 during GIU portion of repair / install Run LUSRMGR.MSC to reset any user password to whatever you want During my tests, this method always ended up in freeze  during a late install stage on “Deleting Temp Files” Method Two – Use LUNIX bootable CD: Download free boot CD software from http://pogostick.net/~pnh/ntpasswd/ It might be called Offline Registry Editor, but this utility main purpose is to reset Administrator passwords to blank. Burn a bootable disk (only 4MB) Boot from this CD. Blank Administrator password…

Read more »