Scott on Writing

Musings on technical writing...

Problems Installing Management Studio with SQL Server 2005 Standard and Express

On Monday of this week (Nov. 7th), Microsoft officially released .NET 2.0 (including ASP.NET 2.0), Visual Studio 2005, and SQL Server 2005. In fact, my most recent 4Guys article, Working with Databases in ASP.NET 2.0 and Visual Studio 2005, examines how to connect and display data from a SQL Server 2005 database from an ASP.NET 2.0 page.

Like Visual Studio 2005, SQL Server 2005 comes in a number of product lines.  There's the free “Express” version that ships with Visual Studio 2005 (or can be downloaded independently) along with a Workgroup, Standard, and Enterprise versions. You can compare the featuresets of the various versions here.

One slight annoyance is that SQL Server 2005 Express edition does not (at this time) ship with Management Studio. Management Studio is the slick new name for what was called Enterprise Manager in SQL Server 2000 - basically a stand-alone GUI Windows application for managing SQL Server databases. Since SQL Server 2005 Express edition lacks the Management Studio, you will most likely create and modify your SQL Server 2005 Express databases directly through the Visual Studio 2005 IDE. (I discuss this in greater detail in my 4Guys article.) There will be, however, a Management Studio Express version; currently it's being released as a Community Technical Preview (CTP); learn more from this blog entry by Euan Garden.

SQL Server 2005 is designed to allow side-by-side installations, both with its varying versions and previous versions of Microsoft SQL Server. When setting up my desktop for .NET last week I installed, first, Visual Studio 2005 Professional edition, which prompted me if I wanted to also install SQL Server 2005 Express edition. Being a rather genial fellow, I said, Sure. After installing VS 2005, I decided to install SQL Server 2005 Standard edition. After installing it I noticed that I did not have Management Studio installed. Weird.

I went to the Control Panel, then Add/Remove Programs, and chose Microsoft SQL Server 2005. Next I was asked to choose an instance (SQL2005 or SQLEXPRESS). I chose SQL2005, since that instance is what supports Management Studio. I then stepped through a few more screens until I reached a screen where there was a Customize button to tailor the installation options. Clicking this displayed the familiar tree of installation options, but, to my surprise, there was no Management Studio option. In talking with others, I found that they had a Management Studio option.

Turns out, from the first screen where I chose an instance (SQL2005 or SQLEXPRESS) there was a link up at the top that read, “To install a new component, click here.” (Screenshot shown below.) I needed to click that particular link to configure the SQL Server 2005 setup to install Management Studio. Seemed odd to place this link here in this screen, as it breaks from the standard UI paradigm used in countless other installation wizards. (Thanks to Adam Sills for helping me get the Management Studio installation working.)

posted on Wednesday, November 09, 2005 8:50 AM

Feedback

# re: Problems Installing Management Studio with SQL Server 2005 Standard and Express 11/11/2005 1:28 AM HappyTommy

As I have read your article of "Visual Studio 2005, SQL Server 2005, and ASP.NET 2.0 Launched!" and you said they are lack of "enterprise-level tools",would you indicate the exact difference between the editions of Visual Studio 2005?

# re: Problems Installing Management Studio with SQL Server 2005 Standard and Express 11/11/2005 8:52 AM Scott Mitchell

HappyTommy, I've updated the article to include some of the features lacking in the Express SKU:
http://aspnet.4guysfromrolla.com/articles/110705-1.aspx

Refer to the VS2005 Product Overview [http://lab.msdn.microsoft.com/vs2005/productinfo/productline/default.aspx] for more information... hth

# re: Problems Installing Management Studio with SQL Server 2005 Standard and Express 11/14/2005 7:08 AM Cameron

The problem with the Management Studio Express CTP is that it doesn't support import or export. So it's pretty useless IMO.

# re: Problems Installing Management Studio with SQL Server 2005 Standard and Express 5/15/2007 2:33 PM Shigg

Another sloppy MS product. Props to this tip

# re: Problems Installing Management Studio with SQL Server 2005 Standard and Express 1/21/2008 3:57 PM kp

I did not see SQL Server Management Studio after installing SQL Server 2005

# re: Problems Installing Management Studio with SQL Server 2005 Standard and Express 2/3/2008 2:20 PM Fred Karmally

Installed SQL Server 2005 on my Windows Vista, had to install SP2. Now realize I must not have selected something but there is no Management Studio. Do I need to uninstall, install SQL2005 and SP2 again, or can I add Management Studio? I have the original disks (never asked me for disk2 when I installed) Please email.

Fred
fred_karmally@hotmail.com

Title:  
Name:  
Url:
Protected by Clearscreen.SharpHIPEnter the code you see:
Comments   

Add To Your Reader

My Links

Archives

Post Categories

 

I am a Microsoft MVP for ASP.NET.
I am an ASPInsider.
<May 2008>
SMTWTFS
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567

Comment Stats

DayTotal% of Total
Sunday 1866.8%
Monday 37913.9%
Tuesday 45316.7%
Wednesday 50418.5%
Thursday 53519.7%
Friday 49418.2%
Saturday 1666.1%
Total 2717100.0%

Hour1Total% of Total
12:00 AM 652.4%
1:00 AM 682.5%
2:00 AM 622.3%
3:00 AM 742.7%
4:00 AM 572.1%
5:00 AM 1033.8%
6:00 AM 1084.0%
7:00 AM 1585.8%
8:00 AM 1716.3%
9:00 AM 1475.4%
10:00 AM 1716.3%
11:00 AM 1816.7%
12:00 PM 1886.9%
1:00 PM 1696.2%
2:00 PM 1605.9%
3:00 PM 1324.9%
4:00 PM 1073.9%
5:00 PM 923.4%
6:00 PM 913.3%
7:00 PM 963.5%
8:00 PM 833.1%
9:00 PM 782.9%
10:00 PM 792.9%
11:00 PM 772.8%
Total 2717100.0%

Comments by Blog Entry Date/Time

Day Entry MadeAvg.Total
Sunday 5.54144
Monday 5.22339
Tuesday 4.28419
Wednesday 7.67637
Thursday 6.90607
Friday 5.48411
Saturday 5.33160
Total 5.842717

Hour1 Entry MadeAvg.Total
12:00 AM 5.0035
1:00 AM 1.002
5:00 AM 0.000
7:00 AM 7.0035
8:00 AM 5.35107
9:00 AM 6.32278
10:00 AM 6.47246
11:00 AM 4.41181
12:00 PM 6.88330
1:00 PM 3.00111
2:00 PM 5.41222
3:00 PM 8.64285
4:00 PM 4.0589
5:00 PM 5.92154
6:00 PM 4.52113
7:00 PM 9.67174
8:00 PM 9.80147
9:00 PM 5.05111
10:00 PM 5.4265
11:00 PM 4.5732
Total 5.842717

Learn More About Comment Stats
1 - All times GMT -8...


Blog Stats

Favorite Web Sites

My Books

My MSDN Articles