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

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

Leave a Reply

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


6 − 5 =

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=""> <strike> <strong>