Skip to main content

Microsoft SQL Reporting Services FIX

Scenario

MS SQL 2005 Reporting Services on Windows Server 2003. App based on MS SQL Reporting services web service failing.

Error "System.Configuration.ConfigurationErrorsException: The RSA key container could not be opened"

Trouble shooting steps I followed.

  1. Check IIS, how are you authenticating?
  2. Check permissions on the sql database, ensure the web server HOSTNAME$ is db owner. If IIS is anonymous then NETWORK SERVICE must have db permissions too.
  3. Check permissions on your web services via the admin interface usually something like this http://HOSTNAME/Reports$DBINSTANCENAME/Pages/Folder.aspx
  4. Check you can access the web services from a workstation to ensure the service is "exposed"
  5. Check you can access the web services from the web server, you should be able to enter the web service required variables and return data.

If the site is running in the "Network Service" context then it is possible that the access to key store was removed. To reassign permissions to allow Network Service account access to the key store run the following command from the .net Framework folder.

%WINDOWS%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -pa "NetFrameworkConfigurationKey" "Network Service"

This seems to occur sometimes with SUS security updates but I haven't completely figured it out, will update once I do.

Popular posts from this blog

Mac OS X "SOE" Day 7

Page Redirection> continued from day 6...

In summary, here is my method for creating a Mac OS X 10.7.3 Standard Operating Environment "SOE" Image.


Overview The goal is to create a "MASTER" non-booted SOE that can be used with multiple models and it multiple sites with different local requirements.

My intention is to use this "MASTER" image in a manual restore procedure due to the fact netboot facilities cannot be made available to all the sites I support however the DMG files are netboot compatible.

RequirementsLion Recovery Disk Assistant v1.0"TARGET" workstation. A compatible workstation that will be used to install Mac OS X 10.7.3 and capture a DMG image(s)."ADMIN" workstation. A workstation with Disk Utility that you will use to capture your DMG image(s).External storage such as a USB HARD DISK. SetupDownloaded the Lion Recovery Disk Assistant v1.0 and followed the instructions to setup an external Recovery D…

TFTP on Mac OS X 10.7 shell script

I've just started getting into Cisco support a little more. It's my goal to eventually specialise (its probably the first time I've found something in I.T. support that I don't eventually get bored with ). Since I've got about 1 of each OS I need make sure I can perform my job on anything. Was working on my macbook pro and needed to download some router configs. Give tftp a kick on Mac OS X 10.7 #!/bin/bash #* TFTP.sh #+ A quick script to enable/disable tftp (for use with cisco devices). #+ Usage: TFTP.sh on NO_ARGS=0 if [ $# -eq "$NO_ARGS" ] # no arguments? then /bin/echo "Disabling tftp." #+ Always unload, just to be on the safe side. sudo launchctl unload -w /System/Library/LaunchDaemons/tftp.plist #+ Cleanup any files so they aren't floating around ;) /bin/echo "Removing default tftp files." sudo /bin/rm -f /private/tftpboot/running-config sudo /bin/rm -f /private/tftpboot/startup-config sudo /bin/rm -f /private/tft…