I'm installing a new instance of MS SQL. There is a step asking to specify instance root. The current DBA is off but I want to follow his logic / way of doing things.
The installer lists the existing instances but does not specify the configured paths. A quick google search doesn't reveal anything useful either.
The question is in the title.

  • check this msdn link and other one – vijayp Sep 15 '14 at 7:38
  • nothing in either of them about "instance root" – Alex Sep 15 '14 at 7:43

Found it by comparing several articles and looking at existing file structure and registry under: HKLM\software\Microsoft\Microsoft SQL Server\MSSQL10.INSTANCEID\Setup
There are a few "path" and "dir" references, most of them quite long. The common denominator seems to be the SqlProgramDir key, for all the existing instances. In our case the DBA decided to put them all under "D:\SQL\Data\"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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