Tag Archives: SQL Installation

DotNet 3.5 on Windows 7 to Install SQL Server 2008

This is a quick post to install or enable .Net 3.5 on windows 7. Last couple of weeks I’m seeing more questions on installing SQL Server 2008 in windows 7 and the users are unable to install SQL Server 2008 pre-requisite (.Net 3.5 ). To Install SQL Server 2008, windows installer 4.5 & .Net 3.5 is required. Windows installer 4.5 is installed and enabled by default, .Net 3.5 is included in windows features, so you can directly go there and turn on .Net 3.5, windows 7 will automatically install this. To turn on .Net 3.5  in Windows 7 just follow the steps below

Read more »

VN:F [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)

SQL Server 2005 SP3 Released

SQL Server 2005 SP3 released today after the release of SP3 beta a couple of weeks ago. You can download SP3 from the link below.

DOWNLOAD SQL SERVER 2005 SP3

Above download link is applicable to below products.
* SQL Server 2005 Enterprise
* SQL Server 2005 Enterprise Evaluation
* SQL Server 2005 Developer
* SQL Server 2005 Standard
* SQL Server 2005 Workgroup

For Express edition check the link http://go.microsoft.com/fwlink/?LinkId=64064 for SP3.

For a list of new features and improvements that are included in SQL Server 2005 SP3, review the What’s New document.
Once the server is patched with SP3, SQL Server version will be changed to 9.00.4035. You can use the below query to check it.

SELECT SERVERPROPERTY('ProductLevel')
SELECT SERVERPROPERTY('ProductVersion')
VN:F [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)

SQL Server 2008 CU2 Released

After the release of CU1 for SQL 2008 a month ago now SQL Server team has released the next cumulative update for SQL Server 2008 on November 19, 2008. To know more about cumulative update 2 for SQL Server 2008 check the link “http://support.microsoft.com/default.aspx/kb/958186/en-us“. This build of the cumulative update package is also known as build 10.00.1779.00.

APPLIES TO

• Microsoft SQL Server 2008 Analysis Services
• Microsoft SQL Server 2008 Community Technology Preview
• Microsoft SQL Server 2008 Developer
• Microsoft SQL Server 2008 Enterprise
• Microsoft SQL Server 2008 Express
• Microsoft SQL Server 2008 Express with Advanced Services
• Microsoft SQL Server 2008 Reporting Services
• Microsoft SQL Server 2008 Standard
• Microsoft SQL Server 2008 Standard Edition for Small Business
• Microsoft SQL Server 2008 Web
• Microsoft SQL Server 2008 Workgroup

VN:F [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)

How to proceed Trouble Free SQL Server 2008 Installation with Cumulative Update 1

I was reading PSS MSDN blogs and found an useful information about SQL 2008 installation and thought of sharing this with you. There is a know issue with SQL 2008 setup (refer KB article http://support.microsoft.com/kb/957453/) and they have fixed this in cumulative update 1. Lets see how to use CU1 to fix this installation issue.

  • Before Installing SQL 2008 from CD \ DVD, download cumulative update 1(http://support.microsoft.com/kb/956717) and install it in the machine, this will install the newly updated setup support files alone with the version 10.00.1763.0.
  • Once this is done, you can now proceed with SQL 2008 installation. When the installation starts it will use the newly installed setup support files bypassing the know issue with the KB article 957453.
  • After successful installation of SQL 2008 you need to re-run cumulative update 1 to update all SQL 2008 components.

That’s it you have done with the installation!!

To know more on this topic you can refer this PSS blog link “How to fix your SQL Server 2008 Setup before you run setup…“.

VN:F [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.17_1161]
Rating: +1 (from 1 vote)

How to Install \ Un-install Cumulative Update 1 for SQL Server 2008

Installing Cumulative Update 1

To install CU1 you need to download cumulative update 1 from the link “Cumulative update package 1 for SQL Server 2008“. Download link is not given in the KB article, you need to request for CU as shown in the below image.

sql2008_cu1_1
Once you placed your request an download link with password will be sent to the email address given at the time of request. Extract the content of the exe file with the help of password provided in the mail. Once its done you are ready for installation.
Read more »

VN:F [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)
  • Page 1 of 2
  • 1
  • 2
  • >