I believe Reporting Services are very powerful tool for report generation. Unfortunately the installation process can be time consuming as you might face some problems with the cofiguration… Of course such problems can be the reason of unsufficient knowledge in SQL Server configuration and management, etc.
Anyway, blank Report Manager screen can be one of the problems, which displays as shown below:
Solution
This issue can be easily fixed by unsetting Enable anonymous access feature for either Reports or ReportServer virtual directory in IIS. In my case (on Windows 2003) I had to switch that of for both that virtual directories.
To do that follow the steps below:
- go to Properties of either virtual directory in the IIS manager
- select Directory Security tab in the Property window
- click Edit in the Authentication and access control section
- disable Enable anonymous access feature
- close all windows by clicking OK buttons in the windows that showed up
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
If you’re bored with standard Windows XP Themes and you’d like to try something different, have a try with Windows XP official Zune Theme. You can have a look at it on Softpedia.
I haven’t had any problems with it and I’m pretty hapy with the effect 
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
Today I couldn’t install some tool on Windows 2003 SE despite being assigned to the Admisnitrators group. Whenever I tried I get the following message:
Windows cannot access the specified device, path, or file. You may not have the appropraiate permissions to access the item.
If you face such problem, first of all check what permissions you have. To do that, right click on My Computer and choose Manage; then System Tools\Local Users and Groups\Groups; double click Administrators on the right part of the window and check if you are on the list of users with that persmissions.
As I said, I was the Admisnitrator of that machine so that was really strange. So I righ clicked the exe file I needed to run and chose Properties. In the Security tab I found out I have the appropriate rights on that file. I went to General tab of that window; at the bottom, in Security section there was the infromation:
This file came from another computer and might be blocked to help protect this computer.
.
That was it! You just need to click Unblock button which is next to the above information.
FYI: The whole security section is only visible for ‘unsecure’ files. Once you enable a file’s exection and click OK, you will no longer see it.
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
It’s possible to have more than one ASP.NET IIS installed and registrated on one machine (that runs Windows).
To check which version is currently registered run Command Line (Start/Run… and type ‘cmd’) and go to %SystemRoot%\Microsoft.NET\Framework\vXXX directory where %SystemRoot% is a special system-wide environment variable found on Microsoft Windows NT and its derivatives (read more on Wikipedia) and vXXX is the directory with ASP.NET IIS files.
Being in that directory, type aspnet_regiis -lv. You will be then given the list of installed/registered versions of ASP.NET IIS.
To register a new version of ASP.NET IIS, go to its direcotry in %SystemRoot%\Microsoft.NET\Framework (using Command Line) and run the following command: aspnet_regiis -i.
To unregister a new version of ASP.NET IIS, go to its direcotry in %SystemRoot%\Microsoft.NET\Framework (using Command Line) and run the following command: aspnet_regiis -u.
To learn more about ASP.NET IIS Registration Tool (Aspnet_regiis.exe) visit the description available on MSDN service.
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
Recently, I’ve learned how to write DTS (Data Transformation Services) in SQL Server 2000. In general, this tool allows transformation of data: copying between different databases (by different vendors) and files (Excel, CSV, etc.). The idea is simple; the usage often priceless.
The execution path of a package is defined using a kind of graph, where nodes are tasks to execute. To operate on data one can write VB/ActiveX script and SQL queries (either direct queries or encapsulated within stored procedures).
Everything would be great if it were easier to write the packages… I believe it’s quite difficult to write the first package, especially with loops - not everything is obvious why/how to use. Also, there’s much less information on the Internet (guides, code examples, fora) than for example for Java programming language…
Anyway, I found the following links useful: SQL DTS and this
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
Have you ever lacked from run menu from KDE (Alt+F2) in your Windows? Try Launchy. It’s open source software that not only runs programs you have installed on your PC but also can launch your documents, project files, bookmarks etc.
I really recommend it! To learn more, see Launchy homepage.
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
