Today I tried installing Reporting services in my machine. After two attempts, I installed successfully. These are my learning's from this installation...
1. SQL Server Reporting services require SQL Server SP3a for SQL Server 2000. Install that first. You can dowload this from the following location.
http://www.microsoft.com/sql/downloads/2000/sp3.asp
After installing, do a reboot.
2. If you have installed whidbey or longhorn bits, then you need do some registry hack. Otherwise Reporting services will give an error “ASP.NET v1.1 not Installed” so it wont install server components. This error is coming because when you install whidbey, ASP.NET version is mapped to 2.0*.. However reporting services requires 1.1 only.. I dont why such requirement is there as 1.x ASP.NET pages will work in 2.0 version also..
To avoid this just change this reqistry setting,
\\HKLM\SOFTWARE\Microsoft\ASP.NET\RootVer] = "1.1.4322.573"
For more details, refer this blog
3. If you provide service account for running reporting service, then you will get a error “install an hotfix XXXX if you want to run this service in NT Service account”.. To avoid this give any domain account credentials.
4. After you install reporting service, install reporting service service pack1. you can download it from here,
http://www.microsoft.com/downloads/details.aspx?FamilyId=580FEBF7-2972-40E7-BCCF-6CD90AC2F464&displaylang=en
In my previous project, we used XMLHTTP request object extensively to submit the web page without refreshing that page. It is a very nice feature, which is required in most of the projects. During those days, I thought why this feature is not used by many people. One reason might be, it was not supported by all the browser at that time.. Now i think most of browsers provide an option to achieve this Microsoft.XMLHttp object in IE and XMLHttpRequest in Netscape.. That is why its been used extensively now,
In Whidbey, Microsoft is using this feature to implement Client Callback mecahnism and google is now using this feature for implementing Google Suggest.
To know how Google Suggest works, check out this blog. If you want to take look at javascript file which does this job, then download it from here...