SQL-Articles

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')

SQL Server 2005 Administration, Service Pack, SQL Installation

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

SQL Server 2008 Administration, SQL Installation, SQL Server 2008

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…“.

SQL Server 2008, Troubleshoot Administration, SQL Installation

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.

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…

SQL Server 2008 Administration, SQL Installation

Question : While installing SQL Server 2008 I’m getting the below error Y? How can I rectify.

Description:
Microsoft .NET Framework 3.5 SP1 has encountered a problem during setup.  Setup did not complete correctly.
Problem signature:
Problem Event Name:    VisualStudio8Setup
Problem Signature 01:    35101
Problem Signature 02:    3.5.30729.01_ORCAS_X86_NET
Problem Signature 03:    CBS
Problem Signature 04:    INST
Problem Signature 05:    F
Problem Signature 06:    gencomp750,{61040379-156d-4ece-b126-ea395a3b2
Problem Signature 07:    BASERET_UNKNOWN
Problem Signature 08:    -
Problem Signature 09:    1058
Problem Signature 10:    WUSA
OS Version:    6.0.6001.2.1.0.256.1
Locale ID:    1033
Additional information about the problem:
LCID:    1033
Read our privacy statement:
http://go.microsoft.com/fwlink/?linkid=50163&clcid=0×0409

Solution: .Net 3.5 is required and its mandatory as part of SQL Server 2008 Installation, hence when you start SQL Server 2008 setup it will first install .Net 3.5. Actually when .Net 3.5 installs it will start downloading the CAB file from the installation location (say your SQL setup folder), for this you need to enable windows update service else it will fail. To correct this problem make sure you have not disabled windows update service.

Read more…

SQL Server 2008 Administration, SQL Installation