Installation of SQL Server 2008 Developer Edition

Question

This is an item I downloaded from Microsoft.  The file are SQLManagementStudio_x86_ENU.exe or SQLManagementStudio_x64_ENU.exe.  My object is to install SQL Server 2008 so I can practice creating Procedures, Triggers, Functions on the real system instead of reading a book about it.  The book I am reading is "Microsoft SQL Server 2008, Step by Step".  When I try to load the software under rules I get a red x next to "Previous release of Microsoft Visual Studio 2008".  When I click on Failed another message appears "Rule Previous release of Microsoft Visual Studio 2008 failed.  And under that it says "A previous release of Microsoft Visual Studio 2008 is installed on this computer.  Upgrade Microsoft Visual Studio 2008 to SP1 before installing SQL Server 2008."  This could be a major point.  I also have Visual Studio 2010 installed on computer.  To upgrade VS 2008 to SP1 I located "Visual Studio 2008 SDK 1.0.  I loaded it.  Then I retried to install SQLManagementStudio_x86_ENU.exe and again I get the same error.  My operating system is Windows 7.

I expect the reference questions answer my question, but if so I do not understand the answers.

 

Answer 1

Can you try to install Visual studio 2008 SP1

from

http://www.microsoft.com/en-us/download/details.aspx?id=10986

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 2

http://blogs.msdn.com/psssql/archive/2008/08/11/sql-server-2008-visual-studio-2008-sp1-and-net-framework-3-5-sp1-explained.aspx

1) If you don't have Visual Studio 2008 installed and have never installed a SQL Server 2008 CTP build, 
SQL Server 2008 RTM comes with everything you need and you should not encounter this problem.

2) If have Visual Studio 2008 installed, you must install VS 2008 SP1 before you install SQL Server 2008 RTM (or don't pick features that require it).

3) If you do not have VS 2008 installed but are encountering this problem, do not attempt to install VS 2008 SP1. 
Rather, uninstall Visual Studio 2008 Shell (integrated mode) and Visual Studio Tools for Applications 2.0. 
You should then be allowed to proceed with the installation.

4) SQL Server 2008 RTM comes with the .Net Framework 3.5 SP1 final release. 
This requirement is independent of the binaries we need from VS 2008 SP1. 
There is no need for you to run any update to the .Net Framework after installing SQL Server 2008.

5) If you install Visual Studio 2008 RTM after installing SQL Server 2008 RTM,
 you must install VS 2008 SP1 to be supported if you are using the features in SQL Server that depend on
 VS 2008 SP1 (BIDS, Integration Services, or Management Tools).



http://www.sqlservercentral.com/blogs/pearlknows/archive/2010/07/19/sql-server-2008-installation-on-windows-7-help-is-finally-here.aspx

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 3

This is an item I downloaded from Microsoft.  The file are SQLManagementStudio_x86_ENU.exe or SQLManagementStudio_x64_ENU.exe.  My object is to install SQL Server 2008 so I can practice creating Procedures,

SQLManagementStudio_x86_ENU.exe and SQLManagementStudio_x864_ENU.exe contain only the SQL Server Management Studio but not SQL Server 2008 Developer Edition.

SQL Server 2008 Developer Edition is a separatly available SQL Server Edition which is not free and you've to pay for it - either by buying the SKU or by buying MSDN / Technet subscription.

higher Visual Studio 2008/2010 editions can install a SQL Server 2008 Express  - which is free - but that is not the Developer Edition. As such you need take care which edition you've installed when you want to apply a service pack to the SQL Server.

Please check if you can found a tool called SQL Server Configuration Manager and start it to check which - if any - SQL Server editions you've installed on your computer together with VS installation.

Otherwise I would recommand that you directly install SQL Server 2008R2 Express edition with Advanced Services which includes all the stuff for SQL Server as well as the SQL Server Management Studio Express edition:

Microsoft® SQL Server® 2008 R2 SP1 - Express Edition and download SQLEXPRADV_x64_ENU.exe or SQLEXPRADV_x86_ENU.exe

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.