Getting Started With SQL Server 2012 Management Studio

Introduction

Microsoft SQL Server 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

Download SQL Server Here!

Procedure to Install

1. Run the file "SQLManagementStudio_x64_ENU".

2. Select the "New SQL Server stand-alone installation or add features to an existing installation" option.

SQLManagementStudio

3. Then let the setup check for product updates.

4. Then wait for the tasks operation to be completed.

install setup file

5. Then accept the license terms to continue and click Next.

accept the license

6. Then in the next window select all the check boxes and click Next.

Select ALL the check boxes

7. Then the setup will install some important files and then you are done!

Problem (Rarely occurs)

During the installation if the setup asks you for the Server Name, Instance Name and Password and Databases Name then its fine but if the setup doesn't ask for it, then you should do the procedure to create your instances for the local db and set up your Server Name.

8. Open a Command Prompt and enter this command.

SqlLocalDb create "MyInstance" -s

Then the following is the expected result:

LocalDB instance "MyInstance" created with version 11.0.
LocalDB instance "MyInstance" started.

SqlLocalDb


9. Now Open SQL Server Management Studio.

Open SQL Server Management Studio

10. Then enter this name into the Server Name text box. "(localdb)\MyInstance-s"and select Windows Authentication and click Connect.

Authentication

Now you are connected to SQL Server and can create new databases.

Happy Coding :).

Personal Blog: Amat Ul Jameel Kazmi's Blog.

Up Next
    Ebook Download
    View all
    Learn
    View all