ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software

Getting Connected With SQL Server Management Studio

Updated on January 16, 2016

If you haven't completed the steps in my previous Hub, "So you want to learn SQL?" please refer to the link below:

Step 1: Install SQL Server Management Studio

This is our primary workbench for accessing our newly created instance of SQL Server Express.

We previously downloaded SQL Server Management Studio, navigate to your downloads folder and double-Click the executable "SQLManagementStudio_x64_ENU"

A dialogue menu will open.

Select "New SQL Server stand-alone installation or add features to an existing installation"

The installation package will check for updates. Once complete, click the "Next" button.

In the "Installation Type" section:

Choose "Add features to an existing instance of SQL Server 2012". Keep the default instance name (i.e. SQLEXPRESS)

Click "Next"

Under "Shared Features", check "Management Tools - Basic"

Click "Next" until you reach the "Complete" section of the installation package.

You should see the dialogue box shown above upon successful installation.

Open "SQL Server Management Studio"


In the "Connect to Server" dialogue box.

Change Authentication to "SQL Server Authentication"

Login: sa

Password: [administrative password we created during our installation]


Click "Connect"

In the "Object Explorer" you should see the following subfolders once you have connected successfully.

Congrats!

You have successfully connected to your local SQL Server instance.

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.