Anil's Tips 'n' Tricks Series: Common SQL Server Problems and Resolutions - by Anil Mahadev
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
- 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:
Click on the Messages link and it brings up the following window:
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.
- Finally, restart IIS.
Now re-run the SQL Server setup and you won't see any warnings:
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.
End of Technical Article
SQL Server Club is a free community service from Norb Technologies - Making SQL Server Faster - www.norbtechnologies.com