Last post Apr 21, 2010 08:00 AM by tamilcodes
Apr 18, 2010 06:36 AM|geoffHome|LINK
This I have done several times with the final message saying successfully installed yet 'About' shows only
Microsoft Visual Studio 2008 Version 9.0.30729.1 SP
Microsoft .NET Framework Version 3.5 SP1
Installed Edition: Professional
I've removed SQL Server 2005 Management Studio Express. Now I have no confidence left.
One suggestion is to remove the existing SQL Server 2008 and start again.
I'm sure upgrading stuff shouldn't take 3-4 days of frustration and potential loss of my workhorse PC.
Any suggestions how I should proceed from here?
Apr 19, 2010 01:21 AM|PeterCwpan|LINK
You have to clarify the version and Edition of both SQL Server and Visual Studio. SQL Server 2008 got to match with SQL Server 2008 Management Studio. Express edition got to match with Mangement Studio Express.
What is your SQL server version and edition? 2005 or 2008 / standard edition or express edition
What is your Management Studio version and edition?
What is the new feature?
Apr 19, 2010 04:15 AM|geoffHome|LINK
Version of SQL 2008 is 10.00.1600
It's server reference is USER\SQLEXPRESS so I'm assuming that it is Express.
I feel completely out of touch with what is really going on once I start these installation.
The version of Management studio version I'm attempting to install is 10.0.1600.22
The new feature I'm assuming is the Management Studio that is not apparent anywhere.
Hope this helps!
Apr 19, 2010 05:47 AM|PeterCwpan|LINK
I have downloaded the package from the following link with advanced services. This package should include managment studio and reporting services etc.
Is it the same package as you installed? If you do not have any database set up it sql server 2008, I suggest you uninstall it and reinstall it. Otherwise, backup all the databases before reinstall it. When you install it, select all features.
Hope this help.
Apr 19, 2010 07:02 AM|tamilcodes|LINK
Did u download and install visual studio 2008 sp 1, you can download from the following link
then retry installing the sql server.
Apr 19, 2010 08:58 AM|PeterCwpan|LINK
Visual studio 2008 is not required unless you use Business Intelligence Development Studio, but the following must be installed
Step 1: Download and install Microsoft .Net Framework 3.5 SP1.
Step 2: Download and install Windows Installer 4.5.
Step 3 Download and install Windows PowerShell 1.0.
Apr 19, 2010 09:16 AM|PeterCwpan|LINK
Sorry, my apology. Visual Studio 2008 SP1 is also required.
Apr 19, 2010 04:30 PM|geoffHome|LINK
My problem is that despite installing the VS SP1 'successfully' my version doesn't appear to accept it (the 'About' screen only shows VS with SP, not SP1).
Apr 19, 2010 07:53 PM|PeterCwpan|LINK
I believe what you concern is installing SQL Server 2008 Express, not VS 2008 service pack one. Don't worry about the Microsoft Visual Studio 2008 SP. Mine is also showing the same.
Go ahead with step 2 and 3 (installer 4.5 and PowerShell 1.0 because the package will verify whether your system is compatible and return failed on the item if it is not.
Apr 21, 2010 12:48 AM|geoffHome|LINK
Thanks for all suggestions.... still no luck.
Have spent another day uninstalling then reinstalling visual studio 2008 and reinstalling Management Studio Express 2005 and have promised to myself never to try to upgrade MS stuff again (life is too short!)
I'm almost back to a useable development PC again. Boy I'm impressed with Ubuntu and just wish I could use it for my web development.
Apr 21, 2010 08:00 AM|tamilcodes|LINK
Even my visual studio show only VISUAL STUDIO V 9 SP AND .NET 3.5 SP1.
Are u struggling installing visual studio, or sql server express 2005 management studio, or sql server express 2008 advanced with management studio.
we all have been through this once, and we can help.