Solved

SQl Server Management

Posted on 2013-11-15
6
275 Views
Last Modified: 2013-11-15
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
Comment
Question by:mlcktmguy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39651212
look for
microsoft SQL server management studio
0
 
LVL 11

Assisted Solution

by:N R
N R earned 100 total points
ID: 39651234
Search for it in your start menu it's there.  

SQL Server Management Stuido.

Attached is a screenshot.
mssql.png
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 39651320
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 61

Accepted Solution

by:
mbizup earned 150 total points
ID: 39651338
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
 
LVL 11

Expert Comment

by:N R
ID: 39651470
@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
 
LVL 1

Author Closing Comment

by:mlcktmguy
ID: 39651564
Thanks, it wasn't installed in originally, not sure why.  I updated the installation and now see it.
0

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question