Excel Web Access Graphs Showing Gray Color

In my SharePoint2007 environment I use Excel Web Access to show the Excel charts with-in SharePoint site. The issue was , all Excel Web Access Charts started showing only gray color . I did lot of search on Google but could not find any solution.

Solution: I ran "sharepoint Technologies and Configuration wizard" on my SharePoint servers and rebooted them. That resolved my issue. I hope this helps some else in future.

HTTP 500 Internal Server Error in SCCM Reporting

When you try to run a large report on SCCM 2007 you might come across this error “HTTP 500 Internal Server Error” and page shows “The website cannot display the page” . This is the default behavior of IIS which has a default buffer size limited 4 MB for ASP response. To resolve the issue we need to increase the size of ASP response to resolve the HTTP 500 Internal Server Error .

Steps:

-On SCCM server go to Start—>Run—>cmd—>Click Ok—>Type cd /d %systemdrive%\inetpub\adminscripts -–>Enter—> type cscript.exe adsutil.vbs SET w3svc/aspbufferinglimit 67108864

( buffer size increased to 64MB)

For more details please read this article.

[Solved]error: System Changes Require Reboot

While installing SQL Management studio on my Windows 7 computer I came across the error “Pending System Changes Require Reboot” . I restarted the system but again same error came up. I did some research on Google and found this solution.

1. Locate the registry :
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SessionManager\

2. Delete registry value “PendingFileRenameOperations”

3. Look for the same registry value at these locations and delete it:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentSet001\Control\SessionManager\

HKEY_LOCAL_MACHINE\SYSTEM\CurrentSet002\Control\SessionManager\

Note: Backup the registry before doing any change and do the registry changes at your own risk

How to Export Members of Exchange Distribution List

I came across this nice VB script to export the list of members of a distribution list of exchange :

'Script begins here

Dim objGroup, objUser, objFSO, objFile, strDomain, strGroup, Domain, Group

'Change DomainName to the name of the domain the group is in
strDomain = Inputbox ("Enter the Domain name", "Data needed", "Default domain name")
'Change GroupName to the name of the group whose members you want to export
strGroup = InputBox ("Enter the Group name", "Data needed", "Default group name")
Set objFSO = CreateObject("Scripting.FileSystemObject")
'On the next line change the name and path of the file that export data will be written to.
Set objFile = objFSO.CreateTextFile("C:\Bin\" & strGroup & " - Members.csv")
Set objGroup = GetObject("WinNT://" & strDomain & "/" & strGroup & ",group")
For Each objUser In objGroup.Members
    objFile.WriteLine objUser.Name & " - " & objUser.Class
Next
objFile.Close
Set objFile = Nothing
Set objFSO = Nothing
Set objUser = Nothing
Set objGroup = Nothing
Wscript.Echo "Done"
Wscript.Echo "Please check the c: for your output file"

Note: The script will ask you the domain name and the group the distribution group for which member list to be created.

What’s new in SCCM2012 SP1

MS has introduced some cool features in the latest release of SCCM2012 SP1. The major new thing I am interested is support for Linux and MC OS.

This blog article summaries the overall changes which has been added. Also there is the announcement from MS on there Channel 9 website: http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/MGT309

Cannot click desktop icons in Windows7

I recently came across an issue where I Cannot click desktop icons in Windows7 computer. After some research I found this solution:

1. Open Task Manager
2. Kill explorer.exe process
3. Now go to File—>New Task –> type in explorer.exe and click OK

It will load the desktop again and you will be able to click desktop icons

You cannot import a new version of driver SCCM if one or more driver files in the package are already imported into the site

Problem: When you try to import a new version of driver which was imported earlier , SCCM gives this error:  The selected driver has already been imported at this site.

Solution: Microsoft has launched a hotfix to resolve that issue, it can be downloaded from this location: http://support.microsoft.com/kb/2213600 

After installing the hot fix you will be able to import a new version of driver which was imported earlier .