SQL Server Management Studio or SSMS allows you to connect ... To test the connectivity, click on Connect Now. It will open a Command Prompt window showing the version information.