This config stuff is getting a little bit ridiculous. I already had a
default instance of SQL Server 2005 SP2 down on the machine. I got all of
the IIS components installed on Vista in order to get an installation of
SSRS to go through. There was no installation option for configuration.
After installing, I applied SP2. Then I opened up IIS Manager and set the
app pool to Classic ASP.NET. When I launch RS Configuration, I select my
default instance, click connect, it it promptly blows up with the following
error:
YES, the SQL Server instance is started. If I click continue, it constantly
throws WMI errors. I managed to get to the database configuration and
create the reportserver and reportservertemp databases. Doing anything to
the virtual directories causes RS Configuration to simply abort and shut
down. I obviously can't get to either the reports or reportserver website,
because the config tool crashes and won't setup the virtual directories in
the config. (If I look in IIS admin, neither of the sites has a virtual
directory configured and the connection string is set to SQLEXPRESS and NOT
the default instance that I have on the machine.) This is getting
ridiculous. Does anyone have a manual config checklist which does NOT
require this Config tool, because the RS Config simply does NOT work.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
occurred and no additional error information is available. -->
System.Runtime.InteropServices.COMException (0x8000000A)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName,
ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
-- End of inner exception stack trace --
at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
at
ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
at
ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
itemName)
at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
at System.Windows.Forms.Form.set_Active(Boolean value)
at System.Windows.Forms.Form.WmActivate(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
---
RSConfigTool
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase:
file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
---
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
---
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
---
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
---
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
---
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
---
System.ServiceProcess
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
---
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
--
Mike - mhotek@.mssqlserver.com
President FilAm Software Technology, Inc
Vice-President MHS Enterprises, Inc
MCITP - SQL Server DBA, MCT
http://www.mssqlserver.com
http://www.mhse.netI hacked my way around and manually added the virtual directory within IIS
Admin for the Reports website. I then hacked and manually input the
<ReportServerVirtualDirectory> within the RSWebApplication.config file. It
at least finds the website now when I go to http://<machine>/reports.
However, it fails on the connection attempt with the VERY unhelpful error
message of:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
So, since I know that it is all compatible, I'm assuming that I missed
something when I manually created the connection string in IIS Admin. Does
anyone have a sample connection string from a working SSRS configuration?
--
Mike - mhotek@.mssqlserver.com
President FilAm Software Technology, Inc
Vice-President MHS Enterprises, Inc
MCITP - SQL Server DBA, MCT
http://www.mssqlserver.com
http://www.mhse.net
"Michael Hotek" <mike.hotek@.mhse.net> wrote in message
news:2D164AE8-B582-4478-8D92-96C284E996DA@.microsoft.com...
> This config stuff is getting a little bit ridiculous. I already had a
> default instance of SQL Server 2005 SP2 down on the machine. I got all of
> the IIS components installed on Vista in order to get an installation of
> SSRS to go through. There was no installation option for configuration.
> After installing, I applied SP2. Then I opened up IIS Manager and set the
> app pool to Classic ASP.NET. When I launch RS Configuration, I select my
> default instance, click connect, it it promptly blows up with the
> following error:
> YES, the SQL Server instance is started. If I click continue, it
> constantly throws WMI errors. I managed to get to the database
> configuration and create the reportserver and reportservertemp databases.
> Doing anything to the virtual directories causes RS Configuration to
> simply abort and shut down. I obviously can't get to either the reports
> or reportserver website, because the config tool crashes and won't setup
> the virtual directories in the config. (If I look in IIS admin, neither
> of the sites has a virtual directory configured and the connection string
> is set to SQLEXPRESS and NOT the default instance that I have on the
> machine.) This is getting ridiculous. Does anyone have a manual config
> checklist which does NOT require this Config tool, because the RS Config
> simply does NOT work.
> See the end of this message for details on invoking
> just-in-time (JIT) debugging instead of this dialog box.
> ************** Exception Text **************
> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
> occurred and no additional error information is available. -->
> System.Runtime.InteropServices.COMException (0x8000000A)
> at
> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> errorCode, IntPtr errorInfo)
> at System.Management.ManagementObject.InvokeMethod(String methodName,
> ManagementBaseObject inParameters, InvokeMethodOptions options)
> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> -- End of inner exception stack trace --
> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> at
> ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
> at
> ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
> itemName)
> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
> at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
> at System.Windows.Forms.Form.set_Active(Boolean value)
> at System.Windows.Forms.Form.WmActivate(Message& m)
> at System.Windows.Forms.Form.WndProc(Message& m)
> at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
> m)
> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
>
> ************** Loaded Assemblies **************
> mscorlib
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> ---
> RSConfigTool
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.3042.00
> CodeBase:
> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
> ---
> System.Windows.Forms
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> ---
> System
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
> ---
> System.Drawing
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> ---
> System.Xml
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
> ---
> System.Management
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
> ---
> System.ServiceProcess
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
> ---
> ************** JIT Debugging **************
> To enable just-in-time (JIT) debugging, the .config file for this
> application or computer (machine.config) must have the
> jitDebugging value set in the system.windows.forms section.
> The application must also be compiled with debugging
> enabled.
> For example:
> <configuration>
> <system.windows.forms jitDebugging="true" />
> </configuration>
> When JIT debugging is enabled, any unhandled exception
> will be sent to the JIT debugger registered on the computer
> rather than be handled by this dialog box.
> --
> Mike - mhotek@.mssqlserver.com
> President FilAm Software Technology, Inc
> Vice-President MHS Enterprises, Inc
> MCITP - SQL Server DBA, MCT
> http://www.mssqlserver.com
> http://www.mhse.net|||Turn off user account control (UAC) in Vista.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Michael Hotek" <mike.hotek@.mhse.net> wrote in message
news:91E85C23-8B52-49A4-B1A4-2F0F5CF7B362@.microsoft.com...
>I hacked my way around and manually added the virtual directory within IIS
>Admin for the Reports website. I then hacked and manually input the
><ReportServerVirtualDirectory> within the RSWebApplication.config file. It
>at least finds the website now when I go to http://<machine>/reports.
>However, it fails on the connection attempt with the VERY unhelpful error
>message of:
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.
> So, since I know that it is all compatible, I'm assuming that I missed
> something when I manually created the connection string in IIS Admin.
> Does anyone have a sample connection string from a working SSRS
> configuration?
> --
> Mike - mhotek@.mssqlserver.com
> President FilAm Software Technology, Inc
> Vice-President MHS Enterprises, Inc
> MCITP - SQL Server DBA, MCT
> http://www.mssqlserver.com
> http://www.mhse.net
> "Michael Hotek" <mike.hotek@.mhse.net> wrote in message
> news:2D164AE8-B582-4478-8D92-96C284E996DA@.microsoft.com...
>> This config stuff is getting a little bit ridiculous. I already had a
>> default instance of SQL Server 2005 SP2 down on the machine. I got all
>> of the IIS components installed on Vista in order to get an installation
>> of SSRS to go through. There was no installation option for
>> configuration. After installing, I applied SP2. Then I opened up IIS
>> Manager and set the app pool to Classic ASP.NET. When I launch RS
>> Configuration, I select my default instance, click connect, it it
>> promptly blows up with the following error:
>> YES, the SQL Server instance is started. If I click continue, it
>> constantly throws WMI errors. I managed to get to the database
>> configuration and create the reportserver and reportservertemp databases.
>> Doing anything to the virtual directories causes RS Configuration to
>> simply abort and shut down. I obviously can't get to either the reports
>> or reportserver website, because the config tool crashes and won't setup
>> the virtual directories in the config. (If I look in IIS admin, neither
>> of the sites has a virtual directory configured and the connection string
>> is set to SQLEXPRESS and NOT the default instance that I have on the
>> machine.) This is getting ridiculous. Does anyone have a manual config
>> checklist which does NOT require this Config tool, because the RS Config
>> simply does NOT work.
>> See the end of this message for details on invoking
>> just-in-time (JIT) debugging instead of this dialog box.
>> ************** Exception Text **************
>> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
>> occurred and no additional error information is available. -->
>> System.Runtime.InteropServices.COMException (0x8000000A)
>> at
>> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
>> errorCode, IntPtr errorInfo)
>> at System.Management.ManagementObject.InvokeMethod(String methodName,
>> ManagementBaseObject inParameters, InvokeMethodOptions options)
>> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> -- End of inner exception stack trace --
>> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
>> itemName)
>> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
>> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
>> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
>> at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
>> at System.Windows.Forms.Form.set_Active(Boolean value)
>> at System.Windows.Forms.Form.WmActivate(Message& m)
>> at System.Windows.Forms.Form.WndProc(Message& m)
>> at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
>> m)
>> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
>> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
>> IntPtr wparam, IntPtr lparam)
>>
>> ************** Loaded Assemblies **************
>> mscorlib
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
>> ---
>> RSConfigTool
>> Assembly Version: 9.0.242.0
>> Win32 Version: 9.00.3042.00
>> CodeBase:
>> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
>> ---
>> System.Windows.Forms
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
>> ---
>> System
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
>> ---
>> System.Drawing
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
>> ---
>> System.Xml
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
>> ---
>> System.Management
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
>> ---
>> System.ServiceProcess
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
>> ---
>> ************** JIT Debugging **************
>> To enable just-in-time (JIT) debugging, the .config file for this
>> application or computer (machine.config) must have the
>> jitDebugging value set in the system.windows.forms section.
>> The application must also be compiled with debugging
>> enabled.
>> For example:
>> <configuration>
>> <system.windows.forms jitDebugging="true" />
>> </configuration>
>> When JIT debugging is enabled, any unhandled exception
>> will be sent to the JIT debugger registered on the computer
>> rather than be handled by this dialog box.
>> --
>> Mike - mhotek@.mssqlserver.com
>> President FilAm Software Technology, Inc
>> Vice-President MHS Enterprises, Inc
>> MCITP - SQL Server DBA, MCT
>> http://www.mssqlserver.com
>> http://www.mhse.net
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment