SQL Server Club
Home Articles Essential Guides Blogs Links Twitter Facebook Join Contact About
Anil's Tips 'n' Tricks Series: Common SQL Server Problems and Resolutions
Anil Mahadev About the Author

Anil was the world's first featured contributor for the IBM DB2 Express-C product on its web site and is currently serving on the Board of Leaders for the DB2 India User Group. He was a major player in organizing IDUG India 2009 and works full time as a SQL Server and SharePoint Consultant and is loving every day of it.

India TechNet also crowned him as Microsoft's first ever Efficiency Super Hero! To get in touch with Anil or read more of his technical articles, please visit his web site.

Typepad Profile Anil Mahadev on Twitter
Send to a Friend Printer Friendly Version
To all SQL Server Club members and loyal readers, a Happy and Prosperous 2010!

Starting this week I intend to write about some of most of the most commonly faced issues and resolutions found when using SQL Server, and will cover topics from installations to administrative tasks.

This week, we take a look at two issues concerning SQL Server Reporting services and SQL Server Business Intelligence Studio.

SQL Server 2005 Installation:

Problem 1: ASP.NET Version Registration Requirement warning

  1. You are trying to install SQL Server 2005 Reporting Services on a 64bit machine and during the pre-requisite check, you see the following warnings:

    SQL Server 2005 Setup - System Configuration Check

    Click on the Messages link and it brings up the following window:

    ASP.NET Version Registration Requirement

    Resolution: you need to enable 32bit app support within IIS.

    To do this, perform the following steps:

    • For Windows Vista, launch IIS Manager by going to Start > Run and then typing inetmgr.exe (Instructions for other versions of Windows).
    • Click on Application Pools. Click on Set Application Pool Defaults.
    • Under the General section, set Enable 32-bit Applications property to TRUE.

      IIS Application Pool Defaults

    • Finally, restart IIS.

    Now re-run the SQL Server setup and you won't see any warnings:

    SQL Server System Configuration
Problem 2: Visual Studio 2008 SP1 is already installed, you run the setup and BIDS installation fails

Resolution Perform the setup with the following command:

start /wait setup.exe /qb REINSTALL=SQL_WarehouseDevWorkbench REINSTALLMODE=OMUS

This command should repair BIDS.

More tips coming up! Please do write to me at anil.mahadev2009@live.com or anil.mahadev@gmail.com.
If you found this article useful, please visit our sponsors who keep us going...

SQL Defrag Studio 2009
Fragmented indexes can cause your SQL Server to gradually slow down until it grinds
to a complete stop. Performance may be slow but you'll need to solve it fast.

SQL Defrag Studio finds fragmented indexes and automatically defrags them for you.
Download
Send to a Friend Printer Friendly Version
Top of Page
© Norb Technologies 2007-2010 Privacy Policy Norb Technologies Devdex Feedback Home
Feedback Form