Change the Default installation path for SQL Server management Studio using Command Prompt

I previously wrote a blog post about using PowerShell and the registry editor to modify the default installation path for SQL Server Management Studio here.
Since then, I’ve tried a few alternative approaches, and now I’m back with a new method for installing SQL Server Management Studio via the command line to a user-specified location.

Steps to do so are as follows
1. Download latest version of SSMS from this link
2. Press Win+Q key to open search on your computer and type in cmd you will see below screen

Click on Run as administrator.
3. Browse to recently downloaded SSMS media from URL in step 1, In my case it was in D:\Software
4. Use below command to install it to a different folder, In my case I am installing it on D:\test.

SSMS-Setup-ENU.exe /Install /quiet /norestart /log D:\Test\log.txt SSMSInstallRoot = D:\test”

And you are all set…

6 thoughts on “Change the Default installation path for SQL Server management Studio using Command Prompt

  1. Pingback: Change the default installation path of SQL Server Management Studio - Saurabh Srivastava's SQL Server Blog

    1. sqlx86 Post author

      Send me the screenshot and I would be able to help you.. Also with newer versions this post is not entirely true… With newer versions MS has enabled the path option again

      Like

      Reply
  2. Rakesh R K

    I tried this method, but got the following error from log file.
    [22BC:3A7C][2020-07-02T09:34:00]e000: Error 0x80070057: UX did not provide variable name.
    How can i fix this error?

    Like

    Reply
    1. sqlx86 Post author

      Hi Rakesh,

      You can try latest SSMS Version that will not have this issue.

      However if you still have to install this version please send more details from log file for me to understand the error better

      Like

      Reply
      1. Rakesh R K

        I was trying to copy the log file content here but i got the error message “Invalid security token”

        FYI, I tried to install 18.5.1(latest), 18.5, 18.4 and also 18.0 but all attempts failed.

        Could not figure out the exact issue….

        I am very thankful to your quick reply. If you provide me your email id I shall send you the full log

        Thank you very much dear Sourabh.

        Like

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 )

Twitter picture

You are commenting using your Twitter 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.