Yes, you can connect to MS SQL database through SQL Server Management Studio. Following are two options as per the SQL Server Management Studio's version:
- You can refer to this article to obtain steps to connect to MS SQL Server 2008.
- You can refer to this article to obtain steps to connect to MS SQL Server 2012.