23

I have the full Visual Studio 2010 (not express) installed, with SQL Server that came with it as well:

enter image description here

I was trying to locate SQL Server Management Studio (ssms) in order to follow this tutorial but I can't seem to find it in my installation.

I could theoretically download the 2008 Management Studio Express but given the so many editions and versions of SSMS (e.g. 2012 Express), how do I know whether it is compatible with my VS 2010?

Also, why download an Express Edition if I already have it in my original Visual Studio 2010 DVD?

So my questions are:

  1. Is SSMS already installed but I don't see it? (if so, how do I locate it?)
  2. If it's not installed, do I just need to run Setup again, then install it?
  3. If it isn't really on the VS 2010 DVD (as many on SO suggest), which downloadable Express edition is most compatible with my VS 2010 (not express)?

Update: (for the benefit of future MS SQL Server newcomers)

Thanks to the answers below I managed to successfully install what I needed and most importantly understand the tools picture.

So to answer my particular questions one by one:

  1. No
  2. No
  3. SQL Server Management Studio 2008 Express

Tips:

  1. Once everything is installed, the next question is "What do I do next?". Fortunately, there is a great tutorial which to me is much clearer than the cumbersome (repetitious, cyclic links, non-linear, etc.) official Microsoft documentation.
  2. Despite the greatness of the functionx.com tutorial, it doesn't provide enough details on how to initially connect to local. Once again, SO comes to the rescue and clarifies that 2 more conditions must be met: (a) SQL Server Browser service must be running. (b) Server name must not be "local" but rather <local-pc-name>\SQLEXPRESS.
  3. To programmatically create a database in C#, use ADO.NET as well.
  4. Why use schemas.
  5. Don't even think about storing database files on a network share.
  6. If you get "Invalid object name" in a SELECT statement for a table you just created, refresh the local cache.
  7. When encountering System.Data.SqlClient.SqlException for the first time you use C# with an existing database using new SqlConnection(), remember that "Data Source=" cannot specify the computer name alone (as in the tutorial) but rather have \SQLEXPRESS appended to the computer name. Also, make sure TCP/IP Client Protocol is enabled.
Community
  • 1
  • 1
Not So Sharp
  • 1,149
  • 2
  • 10
  • 20
  • 7
    I don't agree with the downvote and the close vote. The question is related to development tools, and thus, satisfying the site expectations. – Steve B Oct 11 '12 at 12:52
  • 5
    @SteveB Thank you. Some folks on SO don't seem to understand the value of SO as "better than Google", especially for beginners in a certain field. – Not So Sharp Oct 11 '12 at 12:55

3 Answers3

19

SSMS is for running queries and performing database administration tasks, etc. Configuration manager is a configuration tool for SQL Server, where you can configure (Start/Stop/user credentials, etc.) the services used by SQL Server.

However, installing Visual Studio does not mean you get the full version of SQL Server, but you get the Express edition, which does not include SSMS.

Maybe this MSDN link will help.

pascalhein
  • 5,700
  • 4
  • 31
  • 44
SchmitzIT
  • 9,227
  • 9
  • 65
  • 92
6

As said by bugfinder and others (+1 to all) sql management studio and sql configuration manager are not the same.

It doesn't matter which visual studios version you have.

What matters is the sql server version you have. I.e You have sql server 2008 installed thus you should download management studio for sql server 2008. ( you have the link in your question). I have vs 2010 ultimate and it didn't have management studio incorporated.

David Kroukamp
  • 36,155
  • 13
  • 81
  • 138
3

No configuration manager is for configuring how your SQL server allows connections. There is still an "SQL Server Management Studio" for queries etc

BugFinder
  • 17,474
  • 4
  • 36
  • 51