SQL Server installation tips… NOT

I have to admit that I shamelessly “steal” any info available on the net when it comes to SQL Server. Just to give you a quick example: Brent Ozar and Jonathan Kehayas both have some neat articles about installing SQL Server. Of course, I use the Next > Next > Finish feature, just as anybody else, but every now and then some wise IT managers are asking me “why did you do this”. Then I get to tell him or her that is because some guys said that this is good practiceJ.

Anyway, moving on, I want to point out how to change the default installation of SQL Server.

Change the default installation path

Truth be told, I have no idea how to change the default installation path for SQL Server per se, but rather to where the Program Files folder will reside. To change the default location:

  1. Go to Registry Editor (regedit); on my local machine (Windows 7), the sequence is Start > type regedit in the Search Programs and Files text box, and click regedit.exe.
  2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion

You should see something similar to the window (ok, dialog box; stop it, you technical writers) below:

As you can see, the CommonFilesDir entry holds the default path of Program Files. Simply change the value data in the Edit String dialog box (double-click the entry to get there) and you’re done.

I hope this helps.

Best regards,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.