To Connect to Microsoft SQL Using the Management Studio tool

1. Run SQL Server Management Studio.

2. Navigate to File -> Connect Object Explorer.

3. Apply the following settings:

   • Server Type: Database Engine

   • Server Name: Name of the computer

   • Authentication : SQL Server Authentication. In order to use SQL Server authentication, you need to select the Mixed Mode (Windows authentication + SQL Server authentication) option while installing Microsoft SQL.

     • Login : sa

     • Password : MSSQL administrator password assigned during installation

4. Click Connect.

5. Select New Query in the Management Studio tool.

6. Type create database lportal and click Execute.

   The message “Query executed successfully” is displayed on successful creation of the database named lportal.