Steps to connect MSSQL server 2012 via SQL Server Management Studio


Staff member
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.
Now you are successfully connected with MSSQL server 2012.