I just installed SQL Server 2008 with reporting services on Windows Server 2003 R2 Standard. When I run Reporting Services Configuration Manager, it shows the the connection URL should be http://[servername]/ReportServer_SQL2008. (SQL2008 is the instance name, so that makes sense.) When I go to that URL, I am asked for a username and password, but no matter what I enter I get:
Server Error in '/ReportServer_SQL2008' Application. Provider type not defined. (Exception from HRESULT: 0x80090017)
Exception Details: System.Runtime.InteropServices.COMException: Provider type not defined. (Exception from HRESULT: 0x80090017
One comment on another online message board suggested that this works for some users in IE but breaks in Firefox. I'm already using IE. Another board suggested using regedit to add read permissions for the "Everyone" group on the HKLM and HKU hives, but this group already has read permission there.
As far as permissions go, the SQL server processes are running as domain user "SQL" which has local admin privileges on the machine.
(I'm not quite sure what username and password it's asking for above. I tried entering credentials for an account that has the sysadmin role in SQL server, the same account I use to get into SQL Server Management Studio. Either way, it's not complaining about authentication, so I don't think it's even getting far enough to check the username and password entered.)
One more note: SQL Server 2005 is also installed on this machine, but the SQL Server 2008 instance name is in the Reporting Services URL, so it seems to be properly separated.
Here's the stack trace on the error page:
[COMException (0x80090017): Provider type not defined. (Exception from HRESULT: 0x80090017)]
System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +43
System.Reflection.Assembly.InternalGetSatelliteAssembly(CultureInfo culture, Version version, Boolean throwOnFileNotFound) +215
System.Resources.ResourceManager.GetSatelliteAssembly(CultureInfo lookForCulture) +79
System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents) +299
System.Resources.ResourceManager.GetString(String name, CultureInfo culture) +74
Microsoft.ReportingServices.Diagnostics.Utilities.Keys.GetString(String key) +21
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException..ctor(Exception innerException, String additionalTraceMessage) +22
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.WriteErrorResponse(Int32 code, String shortHttpDescription, Exception exception, Boolean errorResponseAsXml) +67
Microsoft.ReportingServices.WebServer.Global.WriteServerError(Exception e) +44
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e) +188
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
