Installing SQL Reporting Services Express

Installing SQL Reporting services Express on Windows 2003 Server "trick"

I dont know why this works but if you are having

• Security problems with Reporting Services on Windows Server 2003.
• Trouble logging into reporting services from .NET Report Viewer

The solution is the following:

1. Open the windows registry
   
2. Locate the key HKEY_LOCAL_MACHINES\SYSTEM\CurrentControlSet\Control\LSA
3. Add a DWork to Value and named DisableloopbackCheck and set its value to 1
4. Close the Registry and restart the server.

Unfortunately this does not resolve the problem Cannot create a connection to data source 'myDataset'. but at least now you'll be able to log into your report server and report manager and manage your reports.