SQL Server 2005 How to change the installation path directory

This evening, fierce (Liehuo. NET) in the overtime when there is a friend to consult about SQL Server 2005 changes to the installation path directory, told a friend, conveniently and on the Internet to find several other methods, the first method is the default, is a small series to tell friends.

Method 1.

During the installation process, install to select the components that you want to install, and then click Advanced. You'll see where to change the installation path.

Method 2. Change the default installation path for the registry:

The installation completes needs to station 500M about space

You can change the path installation, and here's how to change it:

Open the registry to find: "Heky_local_machinesoftwaremicrosoftwindowscurrentversion" in the right window to find the "ProgramFilesDir" string, double-click the value by "C: ProgramFiles "Modify to" D:programfiles "OK after you exit the registration form

Method 3.

First: Do not modify the path, use the default installation, and finally confirm the installation will show the path of the Configurationfile.ini file, to this path to copy the installation configuration file to another path, such as D:, and then exit the installation

Second: Use Notepad to open this file, according to the actual need to replace the "C:Program FilesMicrosoft SQL Server" lookup with "D:program FilesMicrosoft SQL Server" after saving

Finally: at the command line go to the installation directory, start the installation, if it is Vista, remember to run the command line with administrator privileges, enter the following instructions:

Setup.exe/action=install/configurationfile=d:configurationfile.ini

Of course, we can also use the Advanced installation mode to choose to use the configuration file for installation, this is a graphical-

Method 4.

Do not use the Autorun installation after inserting the disc, use the command line to install the!CD into the root directory of the installation CD, enter the command:

setup.exe/installshareddir= "D:program filesmicrosoft sql Server/installsharedwowdir=" D:program Files (x86) Microsoft SQL Server

installation, where Installshareddir is the path to the x64 part installation, Installsharedwowdir to the x32 part installation path.