SQL Server 2008 R2: A failure was detected for a previous installation

SQL Server 2008 R2 cumulative update was giving an error stating SQL Server setup failure.

SQL Server Setup has encountered the following error:

A failure was detected for a previous installation, patch or repair for instance “MSSQLSERVER” during the configurtion for features………. Error code 0x84B20001

Found it on Microsoft forums and other posts to look for these registry entries:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\ConfigurationState

MPT_AGENT_CORE_CNI
SQL_Engine_Core_Inst
SQL_Replication_Core_Inst

All REG_DWORD values were set to 3 and changed them to 1.

Wow, this time the setup validation succeeded and the SQL server 2008 R2 update operation was completed successfully.

Facebook Comments
Print Friendly
Filed under: Windows(2003/2008/2012)Tagged with: , , , , ,

MMC not starting

MMC is not starting and it shows an error message stating that it will not run with a version of a Internet Explorer earlier than Internet Explorer 5.5.

To work around this issue, create a string entry (REG_SZ) with the name Version and the value “6.0.0.0” under the subkey

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer

Thanks,

WintelAdmin

Facebook Comments
Print Friendly
Filed under: Windows(2003/2008/2012)Tagged with: , , , , , , , , , ,

Please wait for the Windows Modules Installer.

One of my windows 2008 didn’t come after reboot. Upon checking the console, saw a message stating “Please wait for the Windows Modules Installer.”. Had to bring up the server at the earliest. It took about an hour, tried reset but server was getting back on to same page. Application team was eagerly waiting for it to come back. Started looking for alternative methods to bring it up.

When checking server was pinging and able to shared folders. Hence, connected to the server from services.msc using the option “Connect to another computer..”

Disabled “Windows Module Installer” service and restarted the server.

Bang, server was back on its home page.

Thanks,

WintelAdmin

Facebook Comments
Print Friendly
Filed under: Windows(2003/2008/2012)Tagged with: , , , , , , ,

HP ILO Port numbers

If you are trying to access an iLO behind a firewall, there are some TCP ports that need to be opened on the firewall.

Here is a list of the default ports used by iLO.

These can be modified on iLO’s  by clicking on Administration -> Access -> Services tab.

ILO FUNCTION           SOCKET TYPE PORT NUMBER 
---------------------- ----------- -----------
Secure Shell (SSH)         TCP        22
Remote Console/Telnet      TCP        23
Web Server Non-SSL         TCP        80
Web Server SSL             TCP        443
Terminal Services          TCP        3389
Virtual Media              TCP        17988
Shared Remote Console      TCP        9300
Console Replay             TCP        17990
Raw Serial Data            TCP        3002

Thanks,

WintelAdmin

Facebook Comments
Print Friendly
Filed under: HP (Servers/products)Tagged with: , , , , , , , , ,

Send-MailMessage : Unable to connect to remote server Line

Send-MailMessage -to “reciever@domin.com” -from “sender@domain.com” -Subject “Subject Info” -Body “Content” -SmtpServer “Server Name”

Was not able to send mail from a Windows 2008 server and the error message displayed is as listed below:

Send-MailMessage : Unable to connect to the remote server
At line:1 char:17
+ Send-MailMessage <<<< -to someone@somedomain.com -from “DhimantR@someDomain.com” -subject ” Troubleshooting” -Body “Some Text or file attachement” -sntpserver “smtpserver”
+ CategoryInfo : InvalidOperation: (System.Net.Mail.SmtpClient:SmtpClient) [Send-MailMessage], SmtpException
+ FullyQualifiedErrorId : SmtpException,Microsoft.PowerShell.Commands.Send MailMessage

Found that the the block was in McAfee, when Powershell was excluded from McAfee. Send mail was success.

Steps to exclude Powershell in McAfee is listed below:

  1. Right click on McAfee icon.
  2. Click on Virus Scan Console.
  3. Double click on Access Protection on VirusScan Console.
  4. On Access Protection tab.
  5. Go to Anti-Virus Standard Protection.
  6. On right hand side, double click on Prevent mass mailing worms from sending mail.
  7. On process to exclude tab, add PowerShell.exe at the end.
  8. Click OK.
  9. Click apply on Access Protection.
  10. Click OK.

Thanks,
WintelAdmin

Facebook Comments
Print Friendly
Filed under: Windows(2003/2008/2012)Tagged with: , , , , , , , , , , , ,

Remove unused programs from control panel using registry.

Wanted to install latest version of Java. When tried to install Java, got failed because of the existence of previous version of Java. There was no uninstaller available to uninstall the previous version of Java. To make successful installation of Java there was a need to remove previous version of Java from program list.

Below listed steps were followed to clear Java from control panel.

  1. Open registry.
  2. Locate HKLM\software\classes\installer\products
  3. Search for the program name (eg; Java)
  4. Look for the folder that contains the program and delete it.

Once you refresh and try reinstalling it should be success.

Thanks,

Winteladmin

 

Facebook Comments
Print Friendly
Filed under: Windows(2003/2008/2012)Tagged with: , , , ,

PART 1: Getting started with PowerShell.

Powershell Tutorial – Part 1

To begin PowerShell you need to start using the console. Forget the command prompt and move on to PowerShell. Powershell is a combination of DOS and Unix shell with an update. It accepts both Windows and Unix commands with many new features. Powershell scripting is to do more in less time.

Powershell can be used in two ways – the Console and the integrated Scripted Environment (ISE). ISE is preferred for scripting and console for command execution.

First thing you need to know is how to start PowerShell, simplest is just by typing powershell. Other way to star powershell is double click .ps1 file.

cmdlets (commandlets) are self contained scripts that required to be called like a command. For example, get-service (which list all services and its status), get-command (it lists all comdlets that can be used). multiple cmdlets can be used to make some tasks very simple thats called command pipelining. One comand can take input from another command. and process it.

The command for getting help is get-help and it accepts varietly of arguments.
get-help

Example:
get-help services
This will search and list all command and help files relating to services.

get-help start-service -online
Using the parameter “online” you can open the browser to view the help on TechNet.

get-help start-service -examples
This will list the example for start-services.

 

Thanks,

WintelAdmin

Facebook Comments
Print Friendly
Filed under: Powershell (Tutorial)Tagged with: , , , , ,

How to move Quorum disk in a failover cluster.

In a Windows Cluster, you can move roles from one node to another. Unfortunately, you may not find an option to move quorum disk to another node.

However, there is an option to move quorum disk to another node using the command line tool.

You can view the cluster status using the command:

Cluster Group

Note: This will list the status for all available resource group.

In order to move the quorum disk, you need to move the “cluster group” group to the desination node using the below command:

Cluster group “Cluster group” /moveto:NodeName

Note: Replace the NodeName with the destination node name. This is to be executed from the node that is holding the quorum disk.

Thanks,
WintelAdmin

Facebook Comments
Print Friendly
Filed under: Windows(2003/2008/2012)Tagged with: , , , , , ,

Cannot open programs unless “Run As Administrator

One of the application was recently installed on Windows 2012 Server, when I click on the short cut its gives an error message stating ” … has stopped working. Windows can check online for a solution to the problem”.  Further, it gives options to check online for a solution and close the program or close the program.

To my surprise, it was found that the application opens by clicking on “Run as Administrator”. Later, clicking “Run as admin” every time was annoying. Hence, the application was set to run as administrator by default following the steps listed below:

Right click the program and select Properties

Under the compatibility tab, select Run this program as an administrator

Click Apply and OK

Thanks,
WintelAdmin

 

Facebook Comments
Print Friendly
Filed under: Windows(2003/2008/2012)Tagged with: , , , , , , , , , , , , , ,

PowerShell for Administrators – Coming Soon

PowerShell essentials for administrators coming soon on WintelAdmin to help with your daily operations.

Stay Tuned…..

WintelAdmin.com

Facebook Comments
Print Friendly
Filed under: Powershell (Tutorial)Tagged with: , , , , , , , , , , , , , , , , ,