Install SQL Server Management Studio

This article covers how to install SQL Server Management Studio after following the instructions to Install the database. If your practice uses 'thick client' workstations, you can now Update Windows Firewall for your operating system to allow workstations to access the server database. The below instructions assume that the user has already installed the SQL Server database and is logged into Windows as an Administrative user,

Download SQL Server Management Studio installation file

1. From the SQL Server Installation Centre select the link to Install SQL Server Management Tools.
   
   



2. A web browser page will open the Microsoft website with a download option for SQL Server Management Studio.
3. Download the file and save to an easily accessible location.

Install SQL Server Management Studio

1. Run the SSMS-Setup executable file as Administrator.



2. The Microsoft SQL Server Management Studio Installation Wizard will begin.
3. Do not change the Location, unless you are installing SQL Server Management Studio to a different path (for example, installing to the server machine's 'D:\' drive).



4. Select Install.
5. Once the installation is complete, you will need to Restart your computer before the setup can continue.
6. Select Restart.



7. Once the computer has restarted, use the Windows search bar to find SQL Server Management Studio and begin the process to Configure SQL Server users