Here are the steps to make connection with MS SQL Server 2012:
- Navigate to Run >> Type SSMS and click on Enter.
- Now SQL Server Management Studio will open and you have to enter below details in it.
- Server type: Database Engine
- Server name: Your_server_IP_address, with port number
- Authentication: SQL Server Authentication
- Login: Username
- Password: Password
- Hit on Connect button.