Tag Archive for 'sqlserver'

Page 2 of 2

Reporting Services – blank Report Manager screen

Published on March 28, 2008 in SQL Server and ssrs. 38 Comments Tags: , .

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:
Reporting Services blank Report Manager screen

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

Data Transformation Services

Published on October 29, 2007 in SQL Server and dts. 0 Comments Tags: , .

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