SQL Server Club
Join the Club About Us Contact Us Submit an Article Norb Technologies Tell a Friend Link to Us Home
Articles Essential Guides Blogs Fun Stuff Sniglets Links Join SQL Server Club on Facebook Join us on Facebook Follow us on Twitter Visitor Feedback
Technical Articles
Anil's Tips 'n' Tricks Series: Common SQL Server Problems and Resolutions

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 personal web page.
Printer Friendly Version Send to a Friend Add to Favorites
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.
Has SQL Server slowed down?
Speed up SQL Server by defragmenting your indexes the easy way with SQL Defrag Studio.
Download a free trial.
Top of Page
© Norb Technologies 2007-2010 | Home | Privacy Policy | Norb Technologies | Developersdex
Feedback Form