Wednesday 25 February 2015

The current SKU is invalid - SQL Server 2008

This is an error you might get when when you try to install SQL Server 2008 or 2008 R2 to add a node to a failover cluster. As mentioned in the Microsoft KB Article:

FIX: Error message when you try to add a second node to a SQL Server 2008 failover cluster: "The current SKU is invalid"

http://support.microsoft.com/kb/957459

This problem occurs when you install SQL Server 2008 from a deployment share that uses a custom Defaultsetup.ini file, and this custom file includes the product key for SQL Server 2008. Additionally, this problem may occur when you install a second node for SQL Server 2008 from installation media that has a custom Defaultsetup.ini file that includes the product key.

While the resolution provided in the KB article to install CU1 for SQL Server 2008 might be the best step forward, unfortunately it did not seem to work for us. So we planned a work-around and it did work for us.

Even i have another solution. I had applied Service pack 3 (SP3) prior to add node and it worked perfectly fine.
https://connect.microsoft.com/SQLServer/feedback/details/363036/add-node-to-sql-server-failover-cluster-failed-with-invalid-sku-error

Warm Regards,
Chhavinath Mishra 
Sr. Specialist Database Administrator

Tuesday 24 February 2015

SQL Server 2008/2012 Reporting Services service doesn't start after the installation

The error message you are getting when you try to start SSRS:
"The request failed or the service did not respond in a timely fashion."

Modify the registry to increase the default time-out value for the service control manager. To increase this value to 60 seconds, follow these steps:
       1. Click Start, click Run, type regedit,and then click OK.
       2. Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control.
       3.  In the right pane, locate the ServicesPipeTimeout entry.


            Note If the ServicesPipeTimeout entry does not exist, you must créate it. To do this, follow these steps:
    1. On the Edit menu, point to New, and then click DWORD Value.
    2. Type ServicesPipeTimeout, and then press ENTER.
    3. Right-click ServicesPipeTimeout, and then click Modify.
    4. Click Decimal, type 180000, and then click OK.
      This value represents the time in milliseconds befor
            Restart the computer for the changes to take effect.
 Check that SSRS service can be started now...

http://blogs.msdn.com/b/mariae/archive/2012/11/12/reporting-services-service-doesn-t-start-after-the-installation-of-ms12-070-security-patch.aspx