How to connect to SQL Server 2012 using SQL Server Management Studio?

0
1241

Configuration sometimes becomes very important while using any application. Some applications are configured on their own during the installation while others need to be configured manually. Same is the case SQL server management studio as it is configured during the installation but some further management can make it work efficiently. It can either be downloaded from Microsoft and select premium or express version according to your need.

The installation is very simple and you just have to follow the steps automatically mentioned to you. Create new alias after the installation of program. Follow the simple steps to connect to SQL Server 2012 using SQL Server Management Studio.

1.First, connect to server on your first opening of management studio and enter some information which you have to fill according to these instructions:

  • Server Type: Select Database Engine from the drop down menu.
  • Server Name: Use “db8801.zhuji91.com, 1430” as your server name.
  • Authentication: Select the option of “SQL Server Authentication”.
  • Login and Password: Here, you have to enter the user name which you used to create the database and the same password.

connect to SQL Server 2012 using SQL Server Management Studio 1
2.Hitting the connect button after filling in all this information will generate the connection between your database and SQL server management studio. Besides, the list of databases will be shown on your left hand side of the window and you will be able to see many databases. However, you can only govern your own.
connect to SQL Server 2012 using SQL Server Management Studio 2
Then, you will be given full access to manage your database if you get the permission of your database administrator. When you connect to the SQL Server 2012 using SQL Server Management Studio, you are able to enjoy a lot of advantages and features, including managing, scheduling and re-sizing dialogs as well as exporting the server registration. Besides, you will get enhanced support for performing your administration tasks easily.