maandag 25 mei 2009

Configure Authentication Types in Reporting Services

When setting up a Team Foundation Server 2008 environment, I ran into some problems with Reporting Services.
The environment consists of:

  • Windows 2008 server
  • SQL Server 2008
  • Team Foundation Server 2008

This is a supported configuration for TFS, and with a lot of manual configuration the environment was finally functioning fine. Except the Reporting part…

When accessing a report, any non-admin  user got challenged with an authentication prompt. After three attempts they received a blank screen without a report.

On the web there were several articles about this problem, but none were able to provide the solution. After some testing and digging around in the server, the authentication type seemed to be the problem.

One of the articles I found was about disabling Kerberos on the server (IIS7), and it described my exact problem. But unfortunately it didn't help. The problem was still there. It seemed not to work.

After some more digging I found the answer in the SQL books online of TechNet. One line in the chapter was:

In previous versions of Reporting Services, all authentication support was provided by IIS. In this release, IIS is no longer used. Reporting Services handles all authentication requests internally.

Ah… That’s why turning the Kerberos setting off in IIS didn’t help. After this the solution was straightforward. I removed the RSWindowsNegotiate option from the RSeportServer.config file and my authentication problem was solved.

The link to the full chapters on TechNet SQL books online: http://technet.microsoft.com/en-us/library/cc281310.aspx

woensdag 13 mei 2009

Master Page and Content Page Interaction.

When programming asp.net web applications with master and content pages, I often need to access some controls on the master page from the content pages. And it is always a reinvention of the wheel on how to do it the right way.

I have been using the same method for some time now, but never gotten to share this knowledge with the public. I believe the information is unknown to most developers.

Yesterday I came across an article on CodeProject, which describes this method in a very clear way. There goes my article.

The details are in short:

  • Add
    <%@ MasterType virtualpath="~/DetailsMaster.master" %>

    to the content page.




  • Create a public function in the master page to access the control

    public Label LabelReference()

    {
    ' Create a reference to an actual label on the page
    LabelReference = lblDetailsItemName;

    }



  • Call the function from the content page



    Master.LabelReference.Text = "Some Text";






The full details of the aricle are here: CodeProject: Master Page and Content Page Interaction.

dinsdag 5 mei 2009

Performance issues with Virtual PC on laptops

I have been working with Virtual Machines for a long time. Because I work on different environments with different configurations (Windows 2008, Windows 2003, SQL 2005 and 2008, etc.), it is not an option to reinstall my machine every time.

But the annoying thing is always the limited performance of them. You need to wait a lot as it runs slower than a normal physical machine.

A colleague of me found a little hack to speed up a Microsoft Virtual PC. By adding a line to the configuration of VPC it will use get a bit more processing power, thus running a bit faster.

Check out the article below:
SharePoint 2007 development: Performance issues with Virtual PC on laptops