• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

SQl Server Management

This is being done on a Win 7 Pro machine.

I am developing a project in Access 2010 that will eventually be run on SQL Server.  

I installed the 180 day evaluation version of SQL Server 2012 on my machine.

I used the MS Access SQL Server upsizing tool to create the SQL Server database.  I got a detailed report showing me all of the tables thad had been created in SQL Server.

At this point I want to be able to manage the SQL Server tables in SQL Server.  First of all I want to see them then perform operations like add a new field to one of the tables.

From the 'Start', 'All Programs' I find the 'Microsoft SQL Server 2012' group.  Under that group the options are:

Import and Export Data (64 bit)
Configuration Tools
          Reporting Service Configuration
           SQL Server Configuration Manager
          SQL Server Error and Usage Report
          SQL Server Installation Center (64 bit)
Data Quality Services
         Data Quality Client
         Data Quality Server Installer

None of these options take me to where I can see the tables and possibly revise them.  How do I get to what I would call my SQL Server manager?
0
mlcktmguy
Asked:
mlcktmguy
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
look for
microsoft SQL server management studio
0
 
Nathan RileyFounder/CTOCommented:
Search for it in your start menu it's there.  

SQL Server Management Stuido.

Attached is a screenshot.
mssql.png
0
 
mlcktmguyAuthor Commented:
I guess that's the issue because the only items I see under the SQL server 2012 group are the ones I listed in my original question.

Why would I not have all ofthe options in mssql.png included by Gallitin?

Is there a way I can create them?
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
mbizupCommented:
Try running the install wizard again... you can select components individually for installation, and you may have missed it in your initial installation:

http://technet.microsoft.com/en-us/library/bb500469.aspx

You specifically want to ensure that 'management tools' are installed)
0
 
Nathan RileyFounder/CTOCommented:
@mlcktmguy - If you don't see them then I would bet you didn't originally install it.  Just re-run the installation and during the options you can select to install the management studio without effecting anything else.
0
 
mlcktmguyAuthor Commented:
Thanks, it wasn't installed in originally, not sure why.  I updated the installation and now see it.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now