Getting Connected With SQL Server Management Studio
If you haven't completed the steps in my previous Hub, "So you want to learn SQL?" please refer to the link below:
So you want to learn SQL?
- So you want to learn SQL?
This is a simple guide for downloading, installing and getting connected to SQL Server Express edition.
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)
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"
Password: [administrative password we created during our installation]
In the "Object Explorer" you should see the following subfolders once you have connected successfully.
You have successfully connected to your local SQL Server instance.