In this example `DESKTOP_HQVAMA3` is the hostname and `SQLEXPRESS` is the instance name. We generally provide the IP address and the instance name of the SQL Server. `Server Name` is the name or IP adress of the server.`Server Type` specifies what is the remote server type like Database Engine etc.We generally provide username and password in order to login local or remote SQL Server Database. We will see a Connect to Server screen which will list some options. In this case it is 17.9 Start SQL Server Management Studio Connect To SQL Server We will start SQL Server Management Studio and we will see following startup screen which will also provide the version of the SSMS. Downloading Packages Start SQL Server Management Studio Download Microsoft SQL Server Management Studio Downloading PackagesĪfter we click to the install the process will continue with the download of required packages. We will just click to the install button. We will start downloaded installer and we will see following screen which is a welcome screen for the installation process.

We will download the installer application from the following link. Download Microsoft SQL Server Management Studio In order to manage this SQL server service and instances with GUI we need to install Microsoft SQL Server Management Studio. SQL Server is a service running on Windows operating systems.

Sql management studio 2008 download