January 3, 2007 at 9:19 am
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()
January 8, 2007 at 8:00 am
This was removed by the editor as SPAM
October 2, 2007 at 3:12 pm
Did you ever find a way to fix this? I am having the same problem.
October 3, 2007 at 7:42 am
I am basically having the same issue (posted 2 different topics on here about it) but haven't heard anything from anyone regarding a solution.
Anyone?? Thanks in advance for any help.
October 3, 2007 at 12:43 pm
I don't know for sure, but off of the top of my head - I don't think you can use WinXP with SQL standard and get RS working. I think you either have to be on a server instance and/or use SQL developer edition.
I know it doesn't solve the problem, but it might point you in another direction to research.
Good luck.
-M
October 3, 2007 at 1:08 pm
This happened for us after we installed Service Pack 2 for SQL. We tried re-installing Reporting Services but that didn't work. The only thing I can think of now is reinstall SQL.
October 3, 2007 at 1:18 pm
I reinstalled SQL server about a dozen times, all to no avail. I am successfully running it on another machine for testing, which has WinXP and it works on there.
October 3, 2007 at 2:59 pm
Have you tried reregistering asp.net and/or activating reporting services?
for .Net 1.1, run C:\Windows\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
for .Net 2.0, run C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
(i think rs 2005 uses 2.0, but i'm not positive, and i didn't look it up)
run rskeymgmt -d
run rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\rsreportserver.config"
It's probably a long shot...
-M
June 3, 2009 at 6:56 am
You have to check the ..\MSSQL.\reporting services folder here and see the proper folder structure is there..if not..
Solution 1:Reinstall SQL Server
Solution 2:Copy and overwrite the folder contents from some other instance to this folder.SQL server will automaticaaly make the config file changes.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply