Hello,
I am a complete Newbie with SQL Server 2005. Can someone help with this problem or at least point me in the right directio for diagnosing it correctly.
I'm learning the Standard SQL product on Windows XP Pro, and everything on my computer has the latest updates (from Windows Updates). I had previously installed SQL Express, but removed all products associated with that according to steps listed at Microsoft's site (pre-installation steps for SQL Server 2005 Standard, as they relate to the removal of SQLExpress).
My problem is I can't run "Reporting Services Configuration". When I try to run it, the main window opens with "Report Server Installation Instance Selection" window, and immediately I get an error box that says, "An unknown error has occurred in the WMI Provider. Error Code 80040219". When I click Ok, I'm back at the instance selection window, where my computer name is by default the machine name, but the instance name is greyed out. After the error, Event Viewer/Application gives the info below. I noticed that it refers to MSSQL.2\Reporting Services\ - but that was the directory for SQL Express Reporting Services, according to the mapping in my registry. It shows mssql.4 as the Standard SQL Reporting Services directory
Event Type: Error
Event Source: Report Server
Event Category: (5)
Event ID: 133
Date: 1/3/2007
Time: 11:08:23 AM
User: N/A
Computer: BSDELL
Description:
The description for Event ID ( 133 ) in Source ( Report Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config.
When I try to connect to Report Services through SQL Server Management Studio, I get the following error: Cannot connect to BsDell - with the following technical details...
Program Location:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Thanks so much Albert!! It was the Namespace in the config file.
Removed, saved, and immediately connected in management studio.
:)
Brian
|||The error means that the config tool can't open the config file for the instance "MSSQL.2". Not surprising, since you uninstalled it. However, the instance name is apparently still in the registry. I'm not sure why the config tool is unable to continue after the error, but you may be able to work around it by cleaning the registry. Using Regedit, look for a key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\RS". Under that key, is there a value whose data is "MSSQL.2"? If so, delete the value.
-Albert
|||Thanks Albert, that was it.
After deleting that key, I was able to run the RS Config. But I'm still not able to pull up the web at http://localhost/Reports or http://localhost/ReportServer and I can't connect to Reporting Services in MS SQL Server Management Studio.
Should I delete the old mssql.2 folder (inside c:\program files\Microsoft SQL Server) that used to be for the SQLEXPRESS instance? And, along those lines, should I delete any other branches or keys in the registry that mention MSSQL.2? I have a branch at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2 which is almost an exact duplicate of HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4 (mssql.2 for SQLEXPRESS and mssql.4 for MSSQLSERVER standard)
I appreciate your help immensly.
Here's the last part of the SQLDUMPER_ERROR.log from "MSSQL.4\Reporting Services\LogFiles".
It's got about 10 dumps in it, and they are all exactly like what I've pasted in below.
01/04/07 16:39:48, ACTION, aspnet_wp.exe, Watson Invoke: No
01/04/07 16:40:18, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1180
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x11EB40D4
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
01/04/07 16:40:19, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
01/04/07 16:40:19, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\SQLDmpr0010.mdmp
01/04/07 16:40:19, ACTION, aspnet_wp.exe, Watson Invoke: No
|||It would not hurt to delete the registry key and files for the MSSQL.2 instance. I don't know if it's causing your problem, though. Can you scan the other log files in MSSQL.4\Reporting Services\LogFiles for error messages?
-Albert
|||Albert,
I have several logs that appeared in the mssql.4 log folder after trying to connect to report server in MS SQL Management Studio, and I have two "system" event log entries which both say the same thing, recorded with the same time stamp. I'll paste one of the report server error logs, the sql dumper and the system event item below, but first I will just paraphrase the errors from each log.
The system event error log puzzles me. I've looked up the referenced CLSID key in the registry (see below), starting in HKCR\CLSID\ and the clsid has 18 entries. The entries have various names, like Netork Connection Manager, Lan Connection, etc But I don't see any of the named items in the Component Services tool. Apparently the item or items need Local Activation permission. By the way, the Event Log mentions ASPNET as the user.
The ReportServer log makes reference to "Object reference not set to an instance of an object", just before the system event DCOM error, and then the same error again immediately following the system event DCOM error.
Thanks again for your help.
Brian
--System Event DCOM errors- (2 Items, both exactly the same, pasting only one item)
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 1/5/2007
Time: 10:54:29 AM
User: BSDELL\ASPNET
Computer: BSDELL
Description:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user BSDELL\ASPNET SID (S-1-5-21-1417001333-813497703-725345543-1008). This security permission can be modified using the Component Services administrative tool.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
--ReportServer__01_05_2007_10_54_20.log--
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\ReportServer__01_05_2007_10_54_20.log</Path>
<SystemName>BSDELL</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!webserver!1!1/5/2007-10:54:22:: i INFO: Reporting Web Server started
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
aspnet_wp!configmanager!1!1/5/2007-10:54:22:: w WARN: WebServiceAccount is not specified in the config file. Using default: BSDELL\ASPNET
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
aspnet_wp!resourceutilities!1!1/5/2007-10:54:22:: i INFO: Reporting Services starting SKU: Standard
aspnet_wp!resourceutilities!1!1/5/2007-10:54:22:: i INFO: Evaluation copy: 0 days left
aspnet_wp!resourceutilities!1!1/5/2007-10:54:22:: i INFO: Running on 1 physical processors, 2 logical processors
aspnet_wp!runningjobs!1!1/5/2007-10:54:22:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
aspnet_wp!runningjobs!1!1/5/2007-10:54:22:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!1!1/5/2007-10:54:22:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!1!1/5/2007-10:54:22:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!library!1!01/05/2007-10:54:22:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()
at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
aspnet_wp!library!1!01/05/2007-10:54:28:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!1!01/05/2007-10:54:31:: i INFO: Catalog SQL Server Edition = Standard
aspnet_wp!library!1!01/05/2007-10:54:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()
at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
End of inner exception stack trace
aspnet_wp!library!1!01/05/2007-10:54:32:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
--SQLDUMPER_ERRORLOG.log--
01/05/07 10:54:27, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3976
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
01/05/07 10:54:28, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
01/05/07 10:54:28, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\SQLDmpr0017.mdmp
01/05/07 10:54:28, ACTION, aspnet_wp.exe, Watson Invoke: No
01/05/07 10:54:31, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3976
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
01/05/07 10:54:32, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
01/05/07 10:54:32, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\SQLDmpr0018.mdmp
01/05/07 10:54:32, ACTION, aspnet_wp.exe, Watson Invoke: No
|||Check that the MSSQL.4\Reporting Services\ReportServer\web.config file has a configuration/system.web/authentication element. (See this thread). Also, if you have edited the ReportServer web site with VS2005, it may have altered the web.config by adding a namespace attribute to the configuration element. This would cause the exception you saw.
-Albert
No comments:
Post a Comment