(FIXED) Windows cannot connect to the printer, 0x00000bcb, 0x0000007e, 0x0000000d, hpcpn5r1.dll loading error

Windows cannot connect to the printer. Operation could not be completed (error) then with one of the following error codes.

0x00000bcb

0x0000007e

0x0000000d

Fixes the worked for me.

1. As this was related to adding x64 drivers, just delete the entire printer queue and recreate it with the proper driver. Changing drivers and print processor settings didn't work as I kept getting error messages of hpcpn5r1.dll loading error. I had removed this from the print processor configuration under Advanced settings but it was not until I blew away the queue and recreated with the same settings that the PC clients actually saw the change.

2. IF the print queue works for XP and WIn7 x86 but you get the same error for Win7 x64, then change the Print Processor to WinPrint, RAW.

3. the 0x00000bcb error I got when there was a driver conflict. The system had the HP Universal Print driver installed. When that was removed from the client computer, it had no problem mapping the print queue I just created on my server

Howto: extract files from a .msi file using the Windows command line

Every once in a while I need to extract the content of a .msi file in order to customize a deployment for a particular network environment. Sometimes initializing the .msi installer will temporarily extract the files into C:\Documents and Settings\\Local Settings\Temp, but those files are removed once the installer exits.

To extract files from a .msi file at the command line, type:

msiexec /a PathToMSIFile /qb TARGETDIR=DirectoryToExtractTo

For example, to extract files from f:\zenworks\zfdagent.msi into c:\zfd701 you would type:

msiexec /a f:\zenworks\zfdagent.msi /qb TARGETDIR=c:\zfd701

The destination directory does not need to exist prior to running this command

Delete duplicate rows from a list in Excel

Delete duplicate rows from a list in Excel

A duplicate row (also called a record) in a list is one where all values in the row are an exact match of all the values in another row. To delete duplicate rows, you filter a list for unique rows, delete the original list, and then replace it with the filtered list. The original list must have column headers.

Because you are permanently deleting data, it's a good idea to copy the original list to another worksheet or workbook before using the following procedure.

1. Select all the rows, including the column headers, in the list you want to filter.

Tip

Click the top left cell of the range, and then drag to the bottom right cell.

2. On the Data menu, point to Filter, and then click Advanced Filter.
3. In the Advanced Filter dialog box, click Filter the list, in place.
4. Select the Unique records only check box, and then click OK.

The filtered list is displayed and the duplicate rows are hidden.

5. On the Edit menu, click Office Clipboard.

The Clipboard task pane is displayed.

6. Make sure the filtered list is still selected, and then click Copy .

The filtered list is highlighted with bounding outlines and the selection appears as an item at the top of the Clipboard.

7. On the Data menu, point to Filter, and then click Show All.

The original list is re-displayed.

8. Press the DELETE key.

The original list is deleted.

9. In the Clipboard, click on the filtered list item.

The filtered list appears in the same location as the original list.

Windows 7 explorer does not refresh file contents

Windows 7 explorer does not refresh file contents

After copying or deleting files the content is not displayed, sure its a windows issue but for my sanity to get around this just hit F5 to do a real refresh. Apparently the refresh button in the browser does nothing to help this.

ADUC installer for Window7

ADUC installer for Window7, worked great on my 32bit VM.

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=7d2f6ad7-656b-4313-a005-4e344e43997d

Write up to replace 4.5 View Client installers.

The latest windows updates broke some 4.5 clients, here is a great write up on how to replace the download files on your View Connection server.

http://www.christowles.com/2011/02/vmware-view-45-client-353760.html

MS KB Article on how to use EFS Recovery Key

MS KB Article on how to use EFS Recovery Key to retrieve encrypted files from a user who has lost their EFS key for whatever reason.

http://support.microsoft.com/kb/241201

Outlook 2010 errors on auto creating user profile

I got this error because my mailbox is located on an Exchange 2003 mailbox server.

• Install the August 31, 2010 hotfix package for Outlook 2010

You can download this hotfix package from the following article in the Microsoft Knowledge Base:

2281463 Description of the Outlook 2010 hotfix package (outlook-x-none.msp): August 31, 2010
http://support.microsoft.com/default.aspx?scid=kb;en-US;2281463

http://support.microsoft.com/kb/2028193

Blacklisted Email Domain

Apparently our work gets blacklisted every now and then due to compromised accounts.

Useful websites to check if you are currently BlackListed (you'll need to know you gateway email IP address):

http://www.mxtoolbox.com/blacklists.aspx

Comcast's Online request form to be removed.

http://www.comcastsupport.com/rbl

We haven't had the same luck with Microsoft's MSN / Hotmail domains on getting removed easily.

How to create a Windows 7 Default Profile

I need to create a Windows 7 Default Profile, apparently I heard the old fashioned way from XP doesn't work anymore. I cam across this document online and I'm going to give it a shot. Hopefully it works as advertised!

http://www.answersthatwork.com/Download_Area/ATW_Library/Windows_7/Win7__4-How_to_create_a_default_user_profile_in_Windows_7.PDF

You cannot make more than one client connection over a NAT device

You cannot make more than one client connection over a NAT device

http://support.microsoft.com/kb/301673

When two client computers try to use the server message block (SMB) protocol to connect to the same server across a network address translation (NAT) device, the more recent client connection may reset the earlier client connection. If a client and a server that use the SMB protocol over a NAT device are copying files, that session may be reset when another client uses the SMB protocol over the same NAT device to the same server.

How to install and use Dell OMSA

http://www.thegeekstuff.com/2008/11/how-to-manage-dell-servers-using-omsa-openmanage-server-administrator-on-linux/

1. Download DELL OMSA

Go to DELL support website -> click on “Drivers & Downloads” -> choose your server model (in my case, I selected PowerEdge 2850) -> choose the operating system -> scroll-down and expand ‘Systems Management’ -> Click on ‘OpenManage Server Administrator Managed Node’ -> Click on OM_5.5.0_ManNode_A00.tar.gz to download it. You can directly download it to your Linux server as shown below.

# mkdir -p /usr/local/omsa # cd /usr/local/omsa # wget http://ftp.us.dell.com/sysman/OM_5.5.0_ManNode_A00.tar.gz

2. Install DELL OMSA

Perform an express OMSA installation as shown below. After the installation, check /var/log/srvadmin.log for any installation errors.

# gzip -d OM_5.5.0_ManNode_A00.tar.gz # tar xvf OM_5.5.0_ManNode_A00.tar # sh linux/supportscripts/srvadmin-install.sh --express Installing the selected packages.  Preparing...                ###################################### [100%]    1:srvadmin-omilcore      ###################################### [  8%]      To start all installed services without a reboot,      enter the following command:  srvadmin-services.sh  start    2:srvadmin-syscheck      ###################################### [ 15%]    3:srvadmin-deng          ###################################### [ 23%]    4:srvadmin-omauth        ###################################### [ 31%]    5:srvadmin-omacore       ###################################### [ 38%]    6:srvadmin-jre           ###################################### [ 46%]    7:srvadmin-ipmi          ###################################### [ 54%]    8:srvadmin-hapi          ###################################### [ 62%]    9:srvadmin-isvc          ###################################### [ 69%]   10:srvadmin-cm            ###################################### [ 77%]   11:srvadmin-iws           ###################################### [ 85%]   12:srvadmin-omhip         ###################################### [ 92%]   13:srvadmin-storage       ###################################### [100%]

3. Start DELL OMSA Services

Invoke the srvadmin-services.sh script to start the OMSA services as shown below.

# sh linux/supportscripts/srvadmin-services.sh start Starting Systems Management Device Drivers: Starting dell_rbu:                                         [  OK  ] Starting ipmi driver:                                      [  OK  ] Starting Systems Management Data Engine: Starting dsm_sa_datamgr32d:                                [  OK  ] Starting dsm_sa_eventmgr32d:                               [  OK  ] Starting DSM SA Shared Services:                           [  OK  ] Starting DSM SA Connection Service:                        [  OK  ]

4. Access OMSA from web browser

By default, OMSA web application runs on Port 1311 . Login to OMSA from web using the URL: https://{omsa-server-ip-address}:1311 using root as shown below. Please note that you can login only using HTTPS.

Fig: DELL OMSA – Web Login Screen

5. Check overall system health of the server

To check the overall system health of various hardware components, expand system menu and click on ‘Main System Chassis’, which will display the health of Memory, CPU etc., as shown below.

Fig: DELL OMSA – Check System Health

6. Clear System Event Log on DELL PowerEdge Servers

Sometimes you will see hardware error messages on the front side of the server even after the problem is fixed. To clear this false alarm, you have to clear the hardware’s Embedded System Management (ESM) Log. To clear hardware event logs, login to DELL OMSA -> Click on Logs TAB -> click on Clear Log.

7. Create RAID (Virtual Disk) group using OMSA

To create a new raid group, click on Storage -> select “Create Virtual Disk” from the drop-down menu next to “PERC 4e/Di”, as shown below. -> Click on Execute -> and follow the on-screen instructions to create a new RAID group.

Fig: DELL OMSA – Create RAID

You can also create RAID using PERC/CERC Bios Configuration Utility as explained in Step-by-Step Guide to Configure Hardware RAID on DELL servers with Screenshots.

Once the RAID group is created, to view the RAID, click on Storage -> “PERC 4e/Di (Embedded)” -> Click on “Virtual Disks” -> Click on “Virtual Disks 0″ -> This will display the details of the physical disks of that particular RAID group as shown below.

Fig: DELL OMSA – View RAID

Telnet client missing in Windows 2008 Server?

So, how do you install Telnet in Windows 2008 Server? Either use the “Initial Configuration Tasks” screen or open Server Manager by going to Start -> Administrative Tools -> Server Manager. From there, click on Add a Feature. You want to add the Telnet Client. This will get your CLI telnet application working again.

Export Computer objects from Active Directory with OldCmp

Export Computer objects from Active Directory with OldCmp

I needed to reconcile Active Directory computer objects last login time with a complete list of my company's inventory and found this process to be pretty useful. Please visit http://www.joeware.net/freetools/tools/oldcmp/index.htm to download OldCmp, this utility will export computer objects from AD. I'm paranoid so I used a AD account with no rights to delete or modify objects but just enough rights to read AD, which is just about any account.

1. Download OldCmp.zip from http://www.joeware.net/freetools/tools/oldcmp/index.htm
2. Extract the OldCmp.exe file within the zip and place in a directory you can easily navigate to from within the cmd line interface.
3. Review the OldCmp.exe usage switches on this page: http://www.joeware.net/freetools/tools/oldcmp/usage.htm or with the OldCmp /? command
4. For the report I needed, I ran the following command:
   C:\Documents and Settings\testr>oldcmp -report -b ou=hosting,dc=subdomain,dc=domain,dc=edu -file oldcmp_export.csv -format CSV
5. This generated a file called oldcmp_export.csv of all the systems in my domain within the "hosting OU with their last system login time if available.

Note: This tool is VERY POWERFUL and could be VERY DANGEROUS! If you are not sure what you are doing, please find or ask someone who does!

Next, I needed to import this file into Excel and clean up the formatting and run a comparison with MS Access. I did the following:

1. Rename the csv file you just exported to have a .txt extension (this is done so that Excel will be prompted for delimiters when it tries to open/import its data).
2. Launch Excel and open the csv file (now renamed as a txt file), select the delimiter as semicolon and then correct formatting and clean up anything that looks strange. I can't tell you how to do this as your naming conventions may collide with the delimiters set. Use your own judgement and save-as a new excel file, you will reference this file from MS Access.
3. Launch MS Access, create a new DB.
4. See http://office.microsoft.com/en-us/access-help/compare-two-tables-and-find-only-matching-data-HA010205130.aspx for a how to on how to create the comparison in MS Access 2007.