Manage Your Database with SSMS 2012

Hello,

In order to manage sql databases on ASP servers, first we will need to install SQL Management studio.

1) Download the correct version:

http://www.microsoft.com/en-us/download/details.aspx?id=29062

Screen Shot 2013-11-29 at 6.06.03 PM

Select either x86 for 32 bit systems:

Screen Shot 2013-11-29 at 6.06.48 PM

Or x64 for 64 bit computers

Screen Shot 2013-11-29 at 6.06.26 PM

2) After your download, run the package:

Screen Shot 2013-11-29 at 6.18.47 PM

Accept terms & next:

Screen Shot 2013-11-29 at 6.18.54 PM

Include product updates if you wish (you can update later), wait, and next:

Screen Shot 2013-11-29 at 6.19.14 PM

Wait for the scan, and install:

Screen Shot 2013-11-29 at 6.21.21 PM

Make sure that at the very least, the 2 checkboxes are checked, next:

Screen Shot 2013-11-29 at 6.25.50 PM

Wait for the install, and next:

Screen Shot 2013-11-29 at 6.28.29 PM

Finished!

Screen Shot 2013-11-29 at 8.11.39 PM

3) Open Sql Server Management Studio 2012, enter your server name, database name, select SQL server authentication, enter the username and password, and click Connect:

Screen Shot 2013-11-29 at 8.12.57 PM

4) Expand the server, then expand databases:

Screen Shot 2013-11-29 at 8.18.21 PM

5) Expand your database and manage!

Screen Shot 2013-11-29 at 8.18.10 PM

Looking for quality web hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , , | Posted under 3rd Party Software, ASP .NET 2, ASP .NET 4.0, DotNet/Windows Hosting, DotNetPanel Administration, MSSQL, Operating Systems, Programming/Coding, Using Arvixe, Web Deploy, Windows 7, Windows Server Admin | RSS 2.0

10 Comments on Manage Your Database with SSMS 2012

  1. HELLO:

    PLEASE, WHAT YOUR VERSION OF SQL SERVER 2012?
    I CAN’T RESTORE DATA BASE :(

    THANKS.

  2. Andrew says:

    Is there a way after you connect through SQL Management Studio to only view the Databases that are you are the owner of?

    Thanks,

  3. louise says:

    Hi how to view my SQL Database after I uploaded it?

  4. Jordan says:

    How Do I find out if I have a “shared server”, “dedicated server” or “VPS”. I was directed here after adding a database and a user to that database then clicking “Browse Database”. I have a Visual Studio Project that I made using LightSwich in Visual Studio. I know it has to be installed to an instance of a server. I would like to setup a link between my login page http://www.healthsonictools.com/Account/Login.aspx and this project either hosted here or through Windows Azure. Do you have information on code for that? I want to demonstrate my project through users having access to it.

    • Noah S says:

      Hi Jordan, Unfortunately that type of coding would be something you would want to talk with a developer about. The easiest way to tell what type of hosting you have is to ask your host. Usually VPS/Dedicated plans are named as such.

  5. KK says:

    How can I restore a MS SQL 2012 Database? I have a Personal Class ASP Plan.

Leave a Reply

Your email address will not be published. Required fields are marked *


2 × = 14

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>