Keep your system up to date with the most recent cumulative update package for SQL Server 2008 SP1. This package contains the hotfixes released after SQL Server 2008 SP1.
Previous CU KB Articles:
SQL Server Sustained Engineering
Good info. However, I can't seem to find a description about the different packages? There is a SNAC version and a RS_Sharepo version in addition to the main update? I suspect that the RS_Sharepo version is related to using Reporting Services in SharePoint integrated mode, but what is SNAC?
SNAC stands for SQL Native Client. I 've tried to post this here two times before, but this site eats my submits - hope, this posting will be displayed.
I have tried to apply CU2 (970315) and CU3 (971491) on SQL Server 2008 SP1, but every time I got this error:
“There are no SQL Server Instances or shared features that can be updated on this computer”
I have both the default instance and named instance, but both are not detected by the CU installer.
Could you please help me ASAP.
Thanks in adv. for your time.
Shoaib from Canada
Thanks for submitting your query; I would need more information to be able to accurately diagnose the root cause. This issue as described is commonly encountered when one of the following scenarios are met:
- The database has a build earlier than SQL Server 2008 SP1 (build 10.00.2531).
- A more recent CU, such as SQL Server 2008 SP1 CU 4 to 7 may have already been applied (greater than build 10.00.2723).
Consider executing 'SELECT @@version’ on each instance to determine the exact version of SQL Server 2008.
If the above scenarios do not describe your current environment please feel free to email me at Abhishek.Sinha@Microsoft.com with the results from the execution of 'SELECT @@version’ on the instance(s).
I'm facing the same problem as Shoaib while installing CU2.
The output for 'SELECT @@version’ is:
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
Can you tell me whats going wrong?
Thanks & Regards,
- Vivek Athalye