Sql Server database is divided in two, one physical part composed of database and log files and a logical part divided in Database Structures, tables, etc. Typically the physical database files can be found on a directory into the computer where Sql Server was installed.
On the other hand if you want to have access to the logical part of your database you need some tools called Database Management Systems (DBMS). One of those tools that belong to Microsoft is Sql Server Management Studio (SSMS).
Sql Server Management Studio gives you the possibility to access your database, it gives you the ability to administer and execute queries at your database using commands or if you prefer you can do that on a graphical way. SSMS gives you a great variety of tools to improve your data Management.
One Fascinating thing about SSMS is that you can create, delete or modify a database on a graphical interface, also you can modify, add or delete rows and configuring some parameter of your database without writing a single query. For example you can Import databases from Csv, txt or Excel files into Tables.
SSMS has a lot of functionalities that you will discover according to your needs. By using this tool, you can connect to different servers with different versions of SQL SERVER (2008, 2012, 2016, etc.) and execute queries on different Databases. I think that this tool is mandatory when developing and optimizing queries.
SSMS is installed by default when you execute Sql Server Installer (Unless you didn’t want to and uncheck the option). If you didn’t install SSMS or you want to access from other computer that is not the host, you can download Sql Server Management Studio from the following link.
Sql Server Management Studio Install
SSMS install is easy all you have to do is to run installer and then click on “Install”
And then wait a few minutes to complete installation process.
Sql Server Database Engine login with SSMS
If your Sql Server is installed in the same computer where your SSMS is located, login is easy. All you have to do is to choose the authentication mode that you configure during Sql Server installation. If you are using “Database Engine Authentication” you will have to introduce your logging Credentials (Superadmin user is “sa” and use the password established during installation).
In case you are using Windows Authentication, Sql Server validates the user and password using Windows credentials of the current Windows user using the computer to connect using SSMS. This means that Windows confirms the user and not Sql Server.
If you are connecting from a remote computer to Sql Server, one of the first things you will have to do is to check if port 1433(Default Sql Server port) from Sql Server Host is reachable from your computer.
You have several options to check, the easiest one is trying to login with SSMS if it fails You can check if port is enabled for your computer using telnet on windows “command prompt”
If telnet is not enabled follow the next steps
- Go to Start > Control Panel.
- Go to Programs and Features.
- Click Turn Windows features on or off.
- In the Windows Features dialog box, check the Telnet Client check box.
You will have to wait a little until files are installed and configured on your computer. After finishing the installation process telnet will be ready to use.
Type on your Command Prompt
Telnet “SqlServerHostIP” 1433
If telnet is working for port 1433(Sql Server default connection port) that means that remote Sql Server is reachable, it is 100% sure that you will be able to connect. In case IP port 1433 is not reachable you will have to check your network connections and check if there is no firewall or other security configuration blocking your connection.