Wednesday, December 8, 2010

Closing Single Excel File Closes All Excel-Solved!!

Hi All,
Solved!!You might have facing this problem, like when you opened a Excel file and along with it you have open other Excel files, so when you Close any of the Excel files it closes all the Excel file,You can overcome this the Solution mention below.
1.Open the Windows Explorer-Go the Tools-Folder Options
2.Select Files Types.
3.Now Scroll Down to XLS and Click on Advanced4.Select Open , then Edit5.Here untick "Use DDE"
6.Change "Application Used to Perform this action" to
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" "%1"7.If you are using Office 2003 you need to select "C:\Program Files\Microsoft Office\Office11\EXCEL.EXE" "%1"Click on OK

Now check by opening Multiple Excel file, you can see it normally, when you close a single Excel file it will close only single Excel.

Regards
Raju Gunnal

Tuesday, December 7, 2010

You may not power on a virtual machine in a virtual machine


HI All,
"You may not power on a virtual machine in a virtual machine" this kind of error comes when you run vmware vm , in Esx installed in VMware Workstation.
To rectify this error, you need to edit the .vmx file, follow the below given steps
1.Suppose you are running VMware Workstation in your physical box.
2.And you have installed ESX under the VMware workstation.
3.After Installing ESX you now tried to connect that ESX through Vsphere Client, and you got connected Successfully.
4.After the Vsphere Client connected Successfully, now here you will try to create a VM and after creating that VM, when you try to power on that VM you will get this error.
"YOU MAY NOT POWER ON A VIRTUAL MACHINE IN A VIRTUAL MACHINE"
5.To Rectify it, just go to the VM files , of the ESX,which you may have stored in your local HardDisk(The VM which you have created under VMware WorkStation).
6.Go to that ESX files location and locate .VMX file and open it with Notepad.
7.After opening the VMX file edit it with the following line.
monitor_control.restrict_backdoor="true"
8.Save that notepad file and exit.
9.Now start that ESX and connect through Vsphere Client and Start the VM which you have created.
It will start Normally,
Any issues just put a comments here.
All The Best

Regards
Raju Gunnal

Monday, December 6, 2010

Enable Remote Desktop Remotely

Hi All,
You can enable Remote system in a network, without going to the physical machine,just you are few steps have a look.
1.Go to Run-Regedit click on OK
2.Registry Editor will now open, now click on File then select Connect Network Registry.
3.A new window will appear, here enter the IP address or system name of the computer to which you want to enable remote Click OK
4.If you have logged in with local admin rights than , the other system registry will open directly, or else it will ask for user id and Password.
5.Now you can find the registry of that machine.
6.Now in registry browse to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server , here in the right panel side select fdenyTSConnection(REG_DWORD).
7.Change the value data from 1 (Remote Desktop Disabled) to 0 (Remote Desktop Enabled)
8.Now exit the registry.
That's it now you have completely enabled the remote connection to that machine, without restarting that machine you can now access it remotely.

Regards
Raju Gunnal

Friday, December 3, 2010

An authentication error has occurred (Code: 0x507) SOLVED

Hi,
"An authentication error has occurred (Code:0x507)" this kind of error you might have faced, usually you will get this error when you are accessing Windows Server 2008 OS remotely from Windows XP SP2 or SP3 ,Windows 7,Windows Server 2003, this error wont allow us to connect remotely, this happens because of NLA,and some Registry disturbance in local desktop, The solotion for it is:
1. Try to login with different user in that system where you used to code 0x507 error.
2.After login with other user name try to access remote of windows server 2008.
3.Now you can access Windows Server 2008.

Use the following steps if the above wont works for you.

1.Just rename the existing profile in that system.
2.Login with your id now and take Windows Server 2008 remote it will work fine.

Post comments if you got any issues

All The Best!!

Wednesday, December 1, 2010

Run VMware Vsphere 4.0 in VMware WorkStation 7

Hi All,
You can run VMware Vsphere 4.0 in VMware Workstation, i am providing the steps how to do that below.

1.Before Starting VMware Vsphere 4.0 in VMware Workstation 7 your Desktop or Laptop must meet the hardware requirement.
2.Your Desktop or Laptop should be 64 bit and VT must be enabled in the BIOS and should have good amount of memory.
3.Go the the BIOS of your system and enable VT or Virtualization.
4.Ok, now You can download a trial version of VMware Workstation 7 and VMware Vsphere 4.0 from VMware site.
5.Now, Run the VMware Workstation 7 in your system, its default installation go with next, next , next.. finish.
6.Once the VMware Workstation Installed,open it from Start Menu or from Desktop icon.
7.There you can create a new VM, in OS option select VMware Kernel 64 bit, and give the required HardDisk Space and importantly assign Memory minimum of 2 GB.
8.Now, Go to the settings of just created VM in CD place show the path ISO file which you have downloaded from VMware Site and above to that select CD connected when VM power on.
9.Click OK, Now go to the file where you have created that ESX VM, and select the .VMX file right click on it and open it with notepad.
10.Once you have Opened .VMX file with notepad go to the bottom of that file and add these line.

"monitor_control.backdoor_restrict=true"add above given line without any inverted comma's
10.Now, start the VM,once you start the VM you will find VM will start booting up and soon you will find the VMware Vsphere 4.0 Installation menu.
11.As you are installing it for test environment, you can go ahead with default installation, but for production installation you must follow with the VMware Vsphere 4.0 installation guide.12.In the installation process give the time zone,and root password whereever it ask and give one Static IP, ip should be in such a way that it should communicate with your physical BOX.
13.After installation finises, VM will reboot.
14.Now, you can find the VM Vsphere started completed onthe main screen you can find the url or ip which you have given it for installation.
15.Go to the browser of your physical system enter the ip which you have given in vm vsphere 4.0 installation and click on enter.
16.For first time when you open that ip you will get with SSL certificate message, add that SSL certificate.
17.Now , you will get the screen with the VMware Vsphere login page, there you will also get link to download Vsphere Client Download, just click on it and download it.
18.After Downloading Vsphere Client, install it on your physical machine.
19.Now open that client and give the IP of the vmware vsphere 4.0 which you have given and in username place give root and password of that.
20.Once you click on login you will again get the ssl message, select ignore and install.
21.Now the next screen will appear with your Vsphere 4.0 infrastructure.
22.Now in that you can create the VM also.

That'st it this way you can install VMware Vsphere 4.0 in your VMware Workstation 7.if you need any help or got any error while installating it you can post comments to me.

All The Best!!!!!!!!!!!