To check Microsoft SQL/mssql version:
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY
(‘productlevel’), SERVERPROPERTY (‘edition’)

To check mysqld server:
SHOW VARIABLES LIKE “%version%”;

but why need to extend system or boot partition? As applications continue to be installed into the Windows system, one day, suddenly you will find that the system and/or boot partition do not have enough free disk space, and when every time the system starts, Windows always prompts the following information:

You are running out of disk space on SYSTEM (C:), To free space on this drive by deleting old or unnecessary files, click here…

This time i will use Gparted (http://gparted.sourceforge.net) , one of best opensource tools available, With GParted you can resize, copy, and move partitions without data loss (**Again i warn you to do a proper backup before proceed**)

-)Load in the Gparted live CD into the CdRom/DVDRom and boot up directly using CDRom/DVDRom, you might need to change your server/pc boot order

Select Gparted Live and press Enter to continue.

Use default setting and  press enter to continue.

Use default setting to use US-English and press Enter to continue.

Use default setting and press Enter to continue.

Select which partition you want to increase/expand.

Click on “Partition” from the Menu and Click on “Resize or Move”

Before Rezising. Drag Bar accross to Max Size

After Resizing.

Click Apply.

-)Done

PS. If your Windows 2003 is running on Virtualization (VMware ,VMware ESX/i, Virtualbox, KVM) , these steps can be followed:

-)Turn off Windows 2003 VM

-)Increase Disk Allocation to the VM for example from 100GB to 150GB

-)Turn on your Windows 2003 VM and boot using Gparted CD/ISO file

-)Follow the above steps before this “PS” section

[ Once Again , do this on your own risk, do backup first before proceed.]

You can try this one :

-)Start Registry Editor. To do this, click Start, click Run, type regedit in the Open box, and then click OK.

-)Locate and then click the following registry subkey:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
-)Double click on WaitToKillServiceTimeout

-)In the Value data box, type 120000, and then click OK. (in miliseconds)

-)Quit Registry Editor, and all you need to do is reboot the server

Credit to: http://support.microsoft.com/?kbid=827610

-)Make Sure your Windows server 2008 is installed properly with IIS 7 and FastCGIModule ,before you proceed to the next step

-)Download PHP itself, it can be downloaded from php.net , last time i was downloaded and installed “php-5.2.12-nts-win32-installer” MSI installer version , select “FastCGI webserver”

-)Once installed, check and make sure extension directory is points to correct extension folder , when installed the php i was customized it, so it will install php into C:\PHP instead of C:\Program Files (x86)\PHP

-)From “Internet Information Server Manager” you need to add new handler mapping from “Add Module Mapping”

Request path : *.php
Module : FastCGIModule
Executable : c:\php\php-cgi.exe (adjust this if you use another folder)
Name : php (or whatsoever you want)

-)create phpinfo script and put it right inside the root directory of your website and test it out

You will not see any error message while accessing that phpinfo page, but you will not able to see any MsSQL module on it, but if you are lucky you will see it and no use and no points to read the next part after this coma(“,”) ,

but if you accessing that phpinfo page direclty from command line, you will see the error message , saying that “msvcr71.dll is missing” and ask you to reinstall the program, bla bla bla,, msvcr71.dll is one of Microsoft C runtime library and it’s propably bundled with Dot Net Framework 1.1, tried to get that missing file by installing Microsoft C++ 2008 Redistribute , but it wasn’t helps , or i was unlucky at that time? well just download that dll file directly from this URL, and put it inside C:\Windows\SysWOW64 , that’s it, MsSQL will shows up right after that

Reference:

http://www.dll-files.com/dllindex/dll-files.shtml?msvcr71

There are some commands you can try like “net” and “subst” that can achieved the main goal

net use E: "\\computername\D$"
or
subst E: D:\

but the problem is all of the above will not retain during after server rebooted, although you can add “/PERSISTANT:YES” parameter on net command, the user might need to logon first before the drive mapping in place and this only works on that particular user only and not all users which is not what i wanted, so figured out and i use this one instead

-)open regedit
-)go to:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\DOS Devices]
-)Create new “string value”
“E:”=”\\??\\D:\\”
-)Reboot

or create new text file called “subst.reg”

——————————–
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\DOS Devices]
“E:”=”\\??\\D:\\”
———————————

And execute that reg file to add to Windows registry.