Sql Server Management Console? Options

[ssjaronx4]

Hi Guys,

Quick question. I have the MS Press book for SQL 2005 and I'm upto Chapter 2. I've installed SQL Enterprise and all the extra as stated in the practices but there is no SSMC installed. Is the management console not installed by default of have I done something wrong?

[cbrzana]

Are you referring to SQL Server Management Studio (SSMS) or SQL Server Configuration Manager? The "management console" term is the generic term used to describe SSMS...

This post has been edited by cbrzana: Nov 11 2007, 07:41 AM

[ssjaronx4]

Oh right. Ive seen the download links on msn for the SSMS but wasnt sure if that should have been included in the enterprise edition disk. Basically I did a full install of the CD but I'm unable to add databases or create them with the tools I have avaliable. From your guide you show what appears to be the SSMS in "Post-Installation" and label it the SQL Server Management Console. Just wondering if this is something that should have been installed by default or whether it is an added extra as it seems to be something that you'd pritty much require as I've been unable to figure out any other way of managing databases without it.

BTW I litterally just opened up the SQL textbook today and started reading and I've never had any experience of SQL before so I'm pritty new to this aspect of IT. Furthest I've ever gone with databases is creating one wih Access and VB

[cbrzana]

I checked my guide and found where I do mention that the scripts to load the Adventureworks database will launch the "SQL Server Management Console". Again, this is just referring to SSMS (but perhaps I should change that to avoid any confusion).

SSMS is the main component of SQL Server 2005...so you're saying SSMS isn't installed on your machine after installing SQL Server? Try going to Start | All Programs | Microsoft SQL Server 2005 | SQL Server Management Studio.

[ssjaronx4]

Cheers for the help. Found out what the problem was. I didn't unistall SQL express when I installed it a while back. That caused problems as the installer thinks that SSMS is already installed when it isn't included in the Express edition. Found the answer on Technet:

----------------------------------------------------------------------------------------------------------------------------------------

DavidCat

I hit this same problem where reinstalling did not work, but I think I found the problem. If there is a version of SQL Server Express already on the server (mine was installed by the Symantic (Viritas) SQL Backup program), the installer assumes the Workstation component is already installed because it sees the SQL Express Tools. But the express tools does not include management studio.

The first time I encountered this, I ended up downloading the advanced version of Express which has the express version of SQL Server Management Studio and installing it. But even that was problematic install with many frustrations.

Here is the problem--there is no way on the Add Remove programs to uninstall the express tools. You have to uninstall everything. Even that caused problems because the uninstall program errored out to the point that Add/Remove said all was ininstalled, but the SQL Install program said Workstation components were still installed.

This time I found something on Aaron Stebner's Weblog (http://blogs.msdn.com/astebner/archive/2005/07/01/434814.aspx)

that showed how to manually uninstall the Express Tools. I cannot give you the command because it involves a GUID that is likely unique to your installation. Download the tool he suggests and it will tell you the GUID to uninstall.

Mine was:

Microsoft SQL Server 2005 Tools Express Edition
Product code: {2750B389-A2D2-4953-99CA-27C1F2A8E6FD}

and to ininstal I ran the command line:

msiexec /x{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}

I think this is a major bug that Microsoft should address. If anyone is listening from Microsoft, please let us know how to report this bug and get an official fix or work around. When Standard version is installed when Express version is already installed, the workstation components should be upgraded to install the management studio tools.

Dave C.
------------------------------------------------------------------------------------------------------------------------------

Wish Microsoft would fix their bugs =).

This post has been edited by ssjaronx4: Nov 12 2007, 08:53 AM