Friday, February 11, 2011

SQL Server 2008 Reporting services install fails with: “Input string was not in a correct format.”

One of the components I was scheduled to deploy at a client’s office required SQL Server 2008 Reporting Services and since I was semi-fluent with performing SQL installs, I went ahead and told the client that rather than waiting for his resources, I’ll go ahead and install SSRS.  I’ve done many SSRS installs in the past and was surprised when I ran into the following error:

Microsoft SQL Server 2008 Setup

The following error has occurred:

Input string was not in a correct format.

image

What’s interesting was that if you look into the services console, the SSRS services are there and started but it’s obvious that it’s half broken as you’ll find plenty of event ID: 113 errors logged:

image

The report server cannot create the Cache Misses/Sec (Semantic Models) performance counter.

The report server cannot create the Total Deliveries performance counter.

Doing some research on the internet showed that people have had success with the following KB: http://support.microsoft.com/kb/300956.  However, this appeared to be instructions for Windows Server 2003 and since the server I was working with was Windows Server 2008 R1, I dug a bit more and noticed this blog post: http://blogs.technet.com/b/yongrhee/archive/2009/10/06/how-to-rebuild-performance-counters-on-windows-vista-server2008-7-server2008r2.aspx.  I went ahead and uninstalled SQL Server 2008 Reporting Services then executed the following on the server:

Microsoft Windows [Version 6.0.6002]

Copyright (c) 2006 Microsoft Corporation. All rights reserved.

C:\Windows\system32>CD\windows\system32

C:\Windows\system32>LodCtr.exe /S:Backup_Original.INI

C:\Windows\system32>LodCtr.exe /R:PerfStringBackup.INI

Info: Successfully restored performance counter setting from backup file C:\Wind

ows\system32\PerfStringBackup.INI

C:\Windows\system32>LODCTR /R

Info: Successfully rebuilt performance counter setting from system backup store

C:\Windows\system32>

image

From here on, I tried to install SSRS again and this time it installed without any issues:

image

I was sort of glad I was using Windows Server 2008 as the operating system as the KB had many steps that needed to be done.  Hope this helps anyone out there who may run into this problem.

No comments: