Friday, February 26, 2010

SQL Server 2008 Installation Failed....

While trying to install SQL Server 2008 in Windows XP, I got a error in "System Configuration Check"
The error is Rule "Performance counter registry hive consistency check" failed. The performance counter registry hive is corrupted.
The problem occurred since the installation trying to read the above register value and does a calculation on Last Counter and Last Help.
We can solve this issue by changing the those Last Counter and Last Help values

Type regedit in the Run and press Enter. It will open Registry Editor window.




Open the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009.
Then you will get a screen as shown in below figure.



Double click on Counter record to get a window as shown below.



Then scroll to the second last line and you will see a number like 3422 as shown in the below figure and remember it.


This is the Last Counter number that the system uses.

Then do the same thing for the Help record too and it is the Last Help number that the system uses.

Then go to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib. The screen is shown below.



Double click on Last Counter and you will get a window as below.



Then select Decimal radio button and put the value taken from the earlier Counter record for the Value data field.
Do the same thing for Last Help which is in the same window.

It will solve the above mentioned issue and do the installation again.
You will be able to pass from that System Configuration Check...

Tuesday, February 2, 2010

Make the starting point of a the X-Axis as the Y-Axis in an Area Chart of SSRS

You can make the starting point of a the X-Axis as the Y-Axis in an Area Chart of SQL Server Reporting Services easily. Initially the Chart will be as shown below.



First right click on the the X-Axis and select Axis Properties.
Then you will get the "Category Axis Properties" window and change the Side margins property to Disabled as shown below.



It will do the task and you will get a chart as shown below.




That's all...