Manage Your Database with SSMS 2012


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

1) Download the correct version:

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


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

18 Comments on Manage Your Database with SSMS 2012

  1. HELLO:



  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?


  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 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.

  6. John Walborn says:

    So is it possible to browse my databases using SSMS if I have a shared hosting account? If so, what name do I use for the server / instance name? I’m not seeing this question addressed above.

    • Noah S says:

      Hi John, yes you can. The server name can be found in your sign-up information e-mail and it is in your billing panel under hosting accounts-

  7. Please disregard my previous email. I have gained access to my Database.
    I have a different question:
    Where do I find the list of our Sales Accounts? I cannot locate the list of users, I need to update it.
    Please help,

    • Noah S says:

      Hi Gordon, Do you mean inside the database? That would be something you check with the developer of your script or whoever set up your database.

  8. Joe Thayer says:

    I have created the database but I see nothing that tells me what my server name URL would be.

    • Noah S says:

      Hi Joe, The server name can be found in your sign-up information e-mail and it is also in your billing panel under hosting accounts-

  9. Roy Z says:

    What is the server name and where do I find it?

Leave a Reply

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