Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We currently have 2 named instances of SQL Server 2008 installed and the folder paths for the database engine look like this

C:\Program Files\Microsoft SQL Server\MSAS10.DevSQL.
C:\Program Files\Microsoft SQL Server\MSAS10.StagingSQL

I'm now trying to install a 3rd named instance, I give it the instance name of TestSQL during the install but for some reason it installs to this path

C:\Program Files\Microsoft SQL Server\MSSQL.10

I would really rather the folder naming convention followed our first 2 installs so it installed to MSSQL.10.TestSQL

Is there something I need to do in the installer to get it to install the database engine in this path

share|improve this question

You have to set the instance root directory to point to the desired directory in the Instance Configuration step of the install wizard.

I thought that the install wizard did this automatically when installing a named instance so are you sure that you're installing a named instance rather than a default instance?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.