Please help me install RS on Vista Business 64bit

SS2005 64bit is installed and running fine on my copy of Vista Business 64
here
I've gone into Programs and Features and enabled all the IIS/ASP.NET stuff
posted on the internet.
I've also created a IWAM_computername account and added it to the
Administrators group.
The setup program says it has to be run from the command prompt with the
SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
This is what I've tried:
E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
ADDLOCAL=RS_Server
INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
It gets to installing Reporting Services and when the status is "Configuring
Components" it gives the error:
"SQL Server setup could not validate the service accounts. Either the
service accounts have not been provided for all of the services being
installed, or the specified username or password is incorrect. For each
service, specify a valid username, password and domain or specify a built-in
system account."
I've also tried:
E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
ADDLOCAL=RS_Server
INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
and
E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
ADDLOCAL=RS_Server
INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
Any help much appreciated!
Clive (London UK)If you don't get any help here you might have better luck on the web forum.
It has the other RS MVP and lots more MS people hanging there.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Clive" <clive@.EndorphinSoftware.co.uk> wrote in message
news:uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl...
> SS2005 64bit is installed and running fine on my copy of Vista Business 64
> here
> I've gone into Programs and Features and enabled all the IIS/ASP.NET stuff
> posted on the internet.
> I've also created a IWAM_computername account and added it to the
> Administrators group.
> The setup program says it has to be run from the command prompt with the
> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
> This is what I've tried:
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
> It gets to installing Reporting Services and when the status is
> "Configuring Components" it gives the error:
> "SQL Server setup could not validate the service accounts. Either the
> service accounts have not been provided for all of the services being
> installed, or the specified username or password is incorrect. For each
> service, specify a valid username, password and domain or specify a
> built-in system account."
> I've also tried:
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
> and
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
> Any help much appreciated!
> Clive (London UK)|||Ok to begin with if there was not an IWAM_ account already created then you
don't need to create one.
Secondly ignore that SKUUPGRADE thing. It's just a warning and I've seen it
when I know for a fact that I am using the same edition that was already
installed.
Follow the steps in the article here:
http://support.microsoft.com/kb/934164/en-us
Also, make sure that you've run aspnet_regiis -i from the
c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the 64bit ASP
.NET extensions aren't registered then it won't even load up the pages in
the first place. Then make sure that the 32bit ASP .NET web service
extensions have been disabled from IIS and that the 64bit extensions are
enabled.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> Subject: Please help me install RS on Vista Business 64bit
> Date: Fri, 26 Oct 2007 18:09:51 +0100
> Lines: 44
> MIME-Version: 1.0
> Content-Type: text/plain;
> format=flowed;
> charset="iso-8859-1";
> reply-type=original
> SS2005 64bit is installed and running fine on my copy of Vista Business
64
> here
> I've gone into Programs and Features and enabled all the IIS/ASP.NET
stuff
> posted on the internet.
> I've also created a IWAM_computername account and added it to the
> Administrators group.
> The setup program says it has to be run from the command prompt with the
> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
> This is what I've tried:
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
> It gets to installing Reporting Services and when the status is
"Configuring
> Components" it gives the error:
> "SQL Server setup could not validate the service accounts. Either the
> service accounts have not been provided for all of the services being
> installed, or the specified username or password is incorrect. For each
> service, specify a valid username, password and domain or specify a
built-in
> system account."
> I've also tried:
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
> and
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
> Any help much appreciated!
> Clive (London UK)
>|||Thanks for that Chris. It's installing now - but not working. (I noticed
that also no new RS system DBs have been added).
I've removed all mentions of ASP.NET 32 in IIS Manager (Anything that didn't
say 64) - from ISAPI and CGI Restrictions and ISAPI Filters
The Reporting Services Configuration Manager gives a WMI error (see below):
What else am I doing wrong?
(I've ended up installing various instances and setup REMOVE=RS_Server
doesn't seem to be removing them. Tips on that would also be helpful.)
Many thanks,
Clive
---
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%20(x86)/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.
"Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
news:fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> Ok to begin with if there was not an IWAM_ account already created then
> you
> don't need to create one.
> Secondly ignore that SKUUPGRADE thing. It's just a warning and I've seen
> it
> when I know for a fact that I am using the same edition that was already
> installed.
> Follow the steps in the article here:
> http://support.microsoft.com/kb/934164/en-us
> Also, make sure that you've run aspnet_regiis -i from the
> c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the 64bit ASP
> NET extensions aren't registered then it won't even load up the pages in
> the first place. Then make sure that the 32bit ASP .NET web service
> extensions have been disabled from IIS and that the 64bit extensions are
> enabled.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
>> From: "Clive" <clive@.EndorphinSoftware.co.uk>
>> Subject: Please help me install RS on Vista Business 64bit
>> Date: Fri, 26 Oct 2007 18:09:51 +0100
>> Lines: 44
>> MIME-Version: 1.0
>> Content-Type: text/plain;
>> format=flowed;
>> charset="iso-8859-1";
>> reply-type=original
>> SS2005 64bit is installed and running fine on my copy of Vista Business
> 64
>> here
>> I've gone into Programs and Features and enabled all the IIS/ASP.NET
> stuff
>> posted on the internet.
>> I've also created a IWAM_computername account and added it to the
>> Administrators group.
>> The setup program says it has to be run from the command prompt with the
>> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
>> This is what I've tried:
>> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> ADDLOCAL=RS_Server
>> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
>> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
>> It gets to installing Reporting Services and when the status is
> "Configuring
>> Components" it gives the error:
>> "SQL Server setup could not validate the service accounts. Either the
>> service accounts have not been provided for all of the services being
>> installed, or the specified username or password is incorrect. For each
>> service, specify a valid username, password and domain or specify a
> built-in
>> system account."
>> I've also tried:
>> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> ADDLOCAL=RS_Server
>> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
>> and
>> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> ADDLOCAL=RS_Server
>> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
>> Any help much appreciated!
>> Clive (London UK)
>>
>|||0x8000000A means "The data necessary to complete this operation is not yet
available."
There was a bug that caused this error on Vista Systems but it was fixed in
SP2.
Did you install Reporting Services before or after you installed SP2?
If you installed Reporting Services after you installed SP2 then you will
need to apply SP2 again since Reporting Services will not be upgraded and
therefore the bug will not be fixed.
If you want you can delete the ReportServer and TempDB databases since they
can be easily recreated using the configuration tool.
> 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%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
ConfigTool.exe
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> References: <uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl>
<fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
> In-Reply-To: <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
> Subject: Re: Please help me install RS on Vista Business 64bit
> Date: Fri, 26 Oct 2007 19:38:12 +0100
> Lines: 211
> MIME-Version: 1.0
> Content-Type: text/plain;
> format=flowed;
> charset="iso-8859-1";
> reply-type=original
> Content-Transfer-Encoding: 7bit
> Thanks for that Chris. It's installing now - but not working. (I
noticed
> that also no new RS system DBs have been added).
> I've removed all mentions of ASP.NET 32 in IIS Manager (Anything that
didn't
> say 64) - from ISAPI and CGI Restrictions and ISAPI Filters
> The Reporting Services Configuration Manager gives a WMI error (see
below):
> What else am I doing wrong?
> (I've ended up installing various instances and setup REMOVE=RS_Server
> doesn't seem to be removing them. Tips on that would also be helpful.)
> Many thanks,
> Clive
> ---
> 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(ConfigurationItemName
s
> 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%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
ConfigTool.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__b77a5c561
934e089/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__b03f5f7f11d50a3
a/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/Sy
stem.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__b03f5f7f11d5
0a3a/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__b03f5f7f
11d50a3a/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.
>
>
>
> "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
> news:fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> > Ok to begin with if there was not an IWAM_ account already created then
> > you
> > don't need to create one.
> >
> > Secondly ignore that SKUUPGRADE thing. It's just a warning and I've
seen
> > it
> > when I know for a fact that I am using the same edition that was already
> > installed.
> >
> > Follow the steps in the article here:
> > http://support.microsoft.com/kb/934164/en-us
> >
> > Also, make sure that you've run aspnet_regiis -i from the
> > c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the 64bit ASP
> > NET extensions aren't registered then it won't even load up the pages in
> > the first place. Then make sure that the 32bit ASP .NET web service
> > extensions have been disabled from IIS and that the 64bit extensions are
> > enabled.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > --
> >> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> >> Subject: Please help me install RS on Vista Business 64bit
> >> Date: Fri, 26 Oct 2007 18:09:51 +0100
> >> Lines: 44
> >> MIME-Version: 1.0
> >> Content-Type: text/plain;
> >> format=flowed;
> >> charset="iso-8859-1";
> >> reply-type=original
> >>
> >> SS2005 64bit is installed and running fine on my copy of Vista Business
> > 64
> >> here
> >>
> >> I've gone into Programs and Features and enabled all the IIS/ASP.NET
> > stuff
> >> posted on the internet.
> >>
> >> I've also created a IWAM_computername account and added it to the
> >> Administrators group.
> >>
> >> The setup program says it has to be run from the command prompt with
the
> >> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
> >>
> >> This is what I've tried:
> >>
> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> ADDLOCAL=RS_Server
> >> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
> >> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
> >>
> >> It gets to installing Reporting Services and when the status is
> > "Configuring
> >> Components" it gives the error:
> >>
> >> "SQL Server setup could not validate the service accounts. Either the
> >> service accounts have not been provided for all of the services being
> >> installed, or the specified username or password is incorrect. For
each
> >> service, specify a valid username, password and domain or specify a
> > built-in
> >> system account."
> >>
> >> I've also tried:
> >>
> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> ADDLOCAL=RS_Server
> >> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
> >>
> >> and
> >>
> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> ADDLOCAL=RS_Server
> >> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
> >>
> >> Any help much appreciated!
> >>
> >> Clive (London UK)
> >>
> >>
> >
>|||I had upgraded SQL2005 to SP2 - but ran the original setup CD to try and
install RS again.
Now I've applied SP2 to the failed RS installation from original CD - and it
is looking much better - but I still can't access the reportserver from IE -
it fails to authenticate when I try to log in as Administrator. It just
keeps prompting again for username and password - and I've changed the Admin
password so as to be sure I'm definitely entering it correctly in IE. After
three attempts it gives HTTP Error 401.3 - Unauthorized
In Programs and Features, in IIS -> World Wide Web Services -> Security,
I've turned on Windows Authrntication as well as Basic Authrntication,
Request Filtering and URL Authorisation
I've tried too many things to mention - and I think it's now a complete
mess. Now I'd just like to wipe off all instances of the DB Engine and RS
but I'm even having difficulty doing that. The uninstall program only
mentions some of the instances - and after "uninstalling" an RS instance -
it's still there!
Is there a global SS 2005 wipe function that will enable me to start again?
If not I think I'll just wipe Vista and put Win 2003 on the laptop and start
again from there.
Many thanks for your help
Clive
"Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
news:cbqRstAGIHA.360@.TK2MSFTNGHUB02.phx.gbl...
> 0x8000000A means "The data necessary to complete this operation is not yet
> available."
> There was a bug that caused this error on Vista Systems but it was fixed
> in
> SP2.
> Did you install Reporting Services before or after you installed SP2?
> If you installed Reporting Services after you installed SP2 then you will
> need to apply SP2 again since Reporting Services will not be upgraded and
> therefore the bug will not be fixed.
> If you want you can delete the ReportServer and TempDB databases since
> they
> can be easily recreated using the configuration tool.
>> 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%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
> ConfigTool.exe
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
>> From: "Clive" <clive@.EndorphinSoftware.co.uk>
>> References: <uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl>
> <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
>> In-Reply-To: <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
>> Subject: Re: Please help me install RS on Vista Business 64bit
>> Date: Fri, 26 Oct 2007 19:38:12 +0100
>> Lines: 211
>> MIME-Version: 1.0
>> Content-Type: text/plain;
>> format=flowed;
>> charset="iso-8859-1";
>> reply-type=original
>> Content-Transfer-Encoding: 7bit
>> Thanks for that Chris. It's installing now - but not working. (I
> noticed
>> that also no new RS system DBs have been added).
>> I've removed all mentions of ASP.NET 32 in IIS Manager (Anything that
> didn't
>> say 64) - from ISAPI and CGI Restrictions and ISAPI Filters
>> The Reporting Services Configuration Manager gives a WMI error (see
> below):
>> What else am I doing wrong?
>> (I've ended up installing various instances and setup REMOVE=RS_Server
>> doesn't seem to be removing them. Tips on that would also be helpful.)
>> Many thanks,
>> Clive
>> ---
>> 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(ConfigurationItemName
> s
>> 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%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
> ConfigTool.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__b77a5c561
> 934e089/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__b03f5f7f11d50a3
> a/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/Sy
> stem.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__b03f5f7f11d5
> 0a3a/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__b03f5f7f
> 11d50a3a/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.
>>
>>
>>
>> "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
>> news:fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl...
>> > Ok to begin with if there was not an IWAM_ account already created then
>> > you
>> > don't need to create one.
>> >
>> > Secondly ignore that SKUUPGRADE thing. It's just a warning and I've
> seen
>> > it
>> > when I know for a fact that I am using the same edition that was
>> > already
>> > installed.
>> >
>> > Follow the steps in the article here:
>> > http://support.microsoft.com/kb/934164/en-us
>> >
>> > Also, make sure that you've run aspnet_regiis -i from the
>> > c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the 64bit
>> > ASP
>> > NET extensions aren't registered then it won't even load up the pages
>> > in
>> > the first place. Then make sure that the 32bit ASP .NET web service
>> > extensions have been disabled from IIS and that the 64bit extensions
>> > are
>> > enabled.
>> >
>> > --
>> > Chris Alton, Microsoft Corp.
>> > SQL Server Developer Support Engineer
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> > --
>> >> From: "Clive" <clive@.EndorphinSoftware.co.uk>
>> >> Subject: Please help me install RS on Vista Business 64bit
>> >> Date: Fri, 26 Oct 2007 18:09:51 +0100
>> >> Lines: 44
>> >> MIME-Version: 1.0
>> >> Content-Type: text/plain;
>> >> format=flowed;
>> >> charset="iso-8859-1";
>> >> reply-type=original
>> >>
>> >> SS2005 64bit is installed and running fine on my copy of Vista
>> >> Business
>> > 64
>> >> here
>> >>
>> >> I've gone into Programs and Features and enabled all the IIS/ASP.NET
>> > stuff
>> >> posted on the internet.
>> >>
>> >> I've also created a IWAM_computername account and added it to the
>> >> Administrators group.
>> >>
>> >> The setup program says it has to be run from the command prompt with
> the
>> >> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
>> >>
>> >> This is what I've tried:
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
>> >> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
>> >>
>> >> It gets to installing Reporting Services and when the status is
>> > "Configuring
>> >> Components" it gives the error:
>> >>
>> >> "SQL Server setup could not validate the service accounts. Either the
>> >> service accounts have not been provided for all of the services being
>> >> installed, or the specified username or password is incorrect. For
> each
>> >> service, specify a valid username, password and domain or specify a
>> > built-in
>> >> system account."
>> >>
>> >> I've also tried:
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
>> >>
>> >> and
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
>> >>
>> >> Any help much appreciated!
>> >>
>> >> Clive (London UK)
>> >>
>> >>
>> >
>>
>|||Chris - over the w/e I completely wiped my copy of Vista Business 64 and
started again.
RS2005 now works on Vista Business 64 - albeit web access is a bit slow to
get going.
But the important thing is it's working - thank you very much for your help.
Regards
Clive
"Clive" <clive@.EndorphinSoftware.co.uk> wrote in message
news:e8Vj8JHGIHA.5208@.TK2MSFTNGP04.phx.gbl...
>I had upgraded SQL2005 to SP2 - but ran the original setup CD to try and
>install RS again.
> Now I've applied SP2 to the failed RS installation from original CD - and
> it is looking much better - but I still can't access the reportserver from
> IE - it fails to authenticate when I try to log in as Administrator. It
> just keeps prompting again for username and password - and I've changed
> the Admin password so as to be sure I'm definitely entering it correctly
> in IE. After three attempts it gives HTTP Error 401.3 - Unauthorized
> In Programs and Features, in IIS -> World Wide Web Services -> Security,
> I've turned on Windows Authrntication as well as Basic Authrntication,
> Request Filtering and URL Authorisation
> I've tried too many things to mention - and I think it's now a complete
> mess. Now I'd just like to wipe off all instances of the DB Engine and RS
> but I'm even having difficulty doing that. The uninstall program only
> mentions some of the instances - and after "uninstalling" an RS instance -
> it's still there!
> Is there a global SS 2005 wipe function that will enable me to start
> again?
> If not I think I'll just wipe Vista and put Win 2003 on the laptop and
> start again from there.
>
> Many thanks for your help
> Clive
>
> "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
> news:cbqRstAGIHA.360@.TK2MSFTNGHUB02.phx.gbl...
>> 0x8000000A means "The data necessary to complete this operation is not
>> yet
>> available."
>> There was a bug that caused this error on Vista Systems but it was fixed
>> in
>> SP2.
>> Did you install Reporting Services before or after you installed SP2?
>> If you installed Reporting Services after you installed SP2 then you will
>> need to apply SP2 again since Reporting Services will not be upgraded and
>> therefore the bug will not be fixed.
>> If you want you can delete the ReportServer and TempDB databases since
>> they
>> can be easily recreated using the configuration tool.
>> 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%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
>> ConfigTool.exe
>> --
>> Chris Alton, Microsoft Corp.
>> SQL Server Developer Support Engineer
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> --
>> From: "Clive" <clive@.EndorphinSoftware.co.uk>
>> References: <uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl>
>> <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
>> In-Reply-To: <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
>> Subject: Re: Please help me install RS on Vista Business 64bit
>> Date: Fri, 26 Oct 2007 19:38:12 +0100
>> Lines: 211
>> MIME-Version: 1.0
>> Content-Type: text/plain;
>> format=flowed;
>> charset="iso-8859-1";
>> reply-type=original
>> Content-Transfer-Encoding: 7bit
>> Thanks for that Chris. It's installing now - but not working. (I
>> noticed
>> that also no new RS system DBs have been added).
>> I've removed all mentions of ASP.NET 32 in IIS Manager (Anything that
>> didn't
>> say 64) - from ISAPI and CGI Restrictions and ISAPI Filters
>> The Reporting Services Configuration Manager gives a WMI error (see
>> below):
>> What else am I doing wrong?
>> (I've ended up installing various instances and setup REMOVE=RS_Server
>> doesn't seem to be removing them. Tips on that would also be helpful.)
>> Many thanks,
>> Clive
>> ---
>> 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(ConfigurationItemName
>> s
>> 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%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
>> ConfigTool.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__b77a5c561
>> 934e089/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__b03f5f7f11d50a3
>> a/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/Sy
>> stem.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__b03f5f7f11d5
>> 0a3a/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__b03f5f7f
>> 11d50a3a/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.
>>
>>
>>
>> "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
>> news:fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl...
>> > Ok to begin with if there was not an IWAM_ account already created
>> > then
>> > you
>> > don't need to create one.
>> >
>> > Secondly ignore that SKUUPGRADE thing. It's just a warning and I've
>> seen
>> > it
>> > when I know for a fact that I am using the same edition that was
>> > already
>> > installed.
>> >
>> > Follow the steps in the article here:
>> > http://support.microsoft.com/kb/934164/en-us
>> >
>> > Also, make sure that you've run aspnet_regiis -i from the
>> > c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the 64bit
>> > ASP
>> > NET extensions aren't registered then it won't even load up the pages
>> > in
>> > the first place. Then make sure that the 32bit ASP .NET web service
>> > extensions have been disabled from IIS and that the 64bit extensions
>> > are
>> > enabled.
>> >
>> > --
>> > Chris Alton, Microsoft Corp.
>> > SQL Server Developer Support Engineer
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> > --
>> >> From: "Clive" <clive@.EndorphinSoftware.co.uk>
>> >> Subject: Please help me install RS on Vista Business 64bit
>> >> Date: Fri, 26 Oct 2007 18:09:51 +0100
>> >> Lines: 44
>> >> MIME-Version: 1.0
>> >> Content-Type: text/plain;
>> >> format=flowed;
>> >> charset="iso-8859-1";
>> >> reply-type=original
>> >>
>> >> SS2005 64bit is installed and running fine on my copy of Vista
>> >> Business
>> > 64
>> >> here
>> >>
>> >> I've gone into Programs and Features and enabled all the IIS/ASP.NET
>> > stuff
>> >> posted on the internet.
>> >>
>> >> I've also created a IWAM_computername account and added it to the
>> >> Administrators group.
>> >>
>> >> The setup program says it has to be run from the command prompt with
>> the
>> >> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
>> >>
>> >> This is what I've tried:
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
>> >> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
>> >>
>> >> It gets to installing Reporting Services and when the status is
>> > "Configuring
>> >> Components" it gives the error:
>> >>
>> >> "SQL Server setup could not validate the service accounts. Either
>> >> the
>> >> service accounts have not been provided for all of the services being
>> >> installed, or the specified username or password is incorrect. For
>> each
>> >> service, specify a valid username, password and domain or specify a
>> > built-in
>> >> system account."
>> >>
>> >> I've also tried:
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
>> >>
>> >> and
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
>> >>
>> >> Any help much appreciated!
>> >>
>> >> Clive (London UK)
>> >>
>> >>
>> >
>>
>|||That's great. Sorry about the late reply got a bit under the weather there
for a few days.
I was going to mention to you that a 401.3 error means that the account
accessing the web page does not have file access permissions to the file
being accessed. If you are using "anonymous" access this usually means that
the IUSR_MACHINENAME account does not have access to the SRS files in the
C:\program files\microsoft sql server\MSSQL.#\Reporting Services\Report
Manager folder. So all you need to do is add the IUSR_MACHINENAME account
to the Report Manager folder,give it read access and make sure that the
subfolders/items get that setting too.
Good luck on your future SRS endeavors :)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> References: <uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl>
<fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
<uzBgg9$FIHA.284@.TK2MSFTNGP02.phx.gbl>
<cbqRstAGIHA.360@.TK2MSFTNGHUB02.phx.gbl>
<e8Vj8JHGIHA.5208@.TK2MSFTNGP04.phx.gbl>
> In-Reply-To: <e8Vj8JHGIHA.5208@.TK2MSFTNGP04.phx.gbl>
> Subject: Re: Please help me install RS on Vista Business 64bit
> Date: Mon, 29 Oct 2007 13:43:45 -0000
> Chris - over the w/e I completely wiped my copy of Vista Business 64 and
> started again.
> RS2005 now works on Vista Business 64 - albeit web access is a bit slow
to
> get going.
> But the important thing is it's working - thank you very much for your
help.
> Regards
> Clive
>
>
> "Clive" <clive@.EndorphinSoftware.co.uk> wrote in message
> news:e8Vj8JHGIHA.5208@.TK2MSFTNGP04.phx.gbl...
> >I had upgraded SQL2005 to SP2 - but ran the original setup CD to try
and
> >install RS again.
> >
> > Now I've applied SP2 to the failed RS installation from original CD -
and
> > it is looking much better - but I still can't access the reportserver
from
> > IE - it fails to authenticate when I try to log in as Administrator.
It
> > just keeps prompting again for username and password - and I've changed
> > the Admin password so as to be sure I'm definitely entering it
correctly
> > in IE. After three attempts it gives HTTP Error 401.3 - Unauthorized
> >
> > In Programs and Features, in IIS -> World Wide Web Services ->
Security,
> > I've turned on Windows Authrntication as well as Basic Authrntication,
> > Request Filtering and URL Authorisation
> >
> > I've tried too many things to mention - and I think it's now a complete
> > mess. Now I'd just like to wipe off all instances of the DB Engine and
RS
> > but I'm even having difficulty doing that. The uninstall program only
> > mentions some of the instances - and after "uninstalling" an RS
instance -
> > it's still there!
> >
> > Is there a global SS 2005 wipe function that will enable me to start
> > again?
> >
> > If not I think I'll just wipe Vista and put Win 2003 on the laptop and
> > start again from there.
> >
> >
> > Many thanks for your help
> >
> > Clive
> >
> >
> > "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
> > news:cbqRstAGIHA.360@.TK2MSFTNGHUB02.phx.gbl...
> >> 0x8000000A means "The data necessary to complete this operation is not
> >> yet
> >> available."
> >>
> >> There was a bug that caused this error on Vista Systems but it was
fixed
> >> in
> >> SP2.
> >>
> >> Did you install Reporting Services before or after you installed SP2?
> >>
> >> If you installed Reporting Services after you installed SP2 then you
will
> >> need to apply SP2 again since Reporting Services will not be upgraded
and
> >> therefore the bug will not be fixed.
> >>
> >> If you want you can delete the ReportServer and TempDB databases since
> >> they
> >> can be easily recreated using the configuration tool.
> >>
> >> 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%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
> >> ConfigTool.exe
> >>
> >> --
> >> Chris Alton, Microsoft Corp.
> >> SQL Server Developer Support Engineer
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> --
> >> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> >> References: <uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl>
> >> <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
> >> In-Reply-To: <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
> >> Subject: Re: Please help me install RS on Vista Business 64bit
> >> Date: Fri, 26 Oct 2007 19:38:12 +0100
> >> Lines: 211
> >> MIME-Version: 1.0
> >> Content-Type: text/plain;
> >> format=flowed;
> >> charset="iso-8859-1";
> >> reply-type=original
> >> Content-Transfer-Encoding: 7bit
> >>
> >> Thanks for that Chris. It's installing now - but not working. (I
> >> noticed
> >> that also no new RS system DBs have been added).
> >>
> >> I've removed all mentions of ASP.NET 32 in IIS Manager (Anything that
> >> didn't
> >> say 64) - from ISAPI and CGI Restrictions and ISAPI Filters
> >>
> >> The Reporting Services Configuration Manager gives a WMI error (see
> >> below):
> >>
> >> What else am I doing wrong?
> >>
> >> (I've ended up installing various instances and setup REMOVE=RS_Server
> >> doesn't seem to be removing them. Tips on that would also be
helpful.)
> >>
> >> Many thanks,
> >> Clive
> >>
> >> ---
> >> 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(ConfigurationItemName
> >> s
> >> 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%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
> >> ConfigTool.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__b77a5c561
> >> 934e089/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__b03f5f7f11d50a3
> >> a/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/Sy
> >> stem.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__b03f5f7f11d5
> >> 0a3a/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__b03f5f7f
> >> 11d50a3a/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.
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
> >> news:fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> >> > Ok to begin with if there was not an IWAM_ account already created
> >> > then
> >> > you
> >> > don't need to create one.
> >> >
> >> > Secondly ignore that SKUUPGRADE thing. It's just a warning and I've
> >> seen
> >> > it
> >> > when I know for a fact that I am using the same edition that was
> >> > already
> >> > installed.
> >> >
> >> > Follow the steps in the article here:
> >> > http://support.microsoft.com/kb/934164/en-us
> >> >
> >> > Also, make sure that you've run aspnet_regiis -i from the
> >> > c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the
64bit
> >> > ASP
> >> > NET extensions aren't registered then it won't even load up the
pages
> >> > in
> >> > the first place. Then make sure that the 32bit ASP .NET web service
> >> > extensions have been disabled from IIS and that the 64bit
extensions
> >> > are
> >> > enabled.
> >> >
> >> > --
> >> > Chris Alton, Microsoft Corp.
> >> > SQL Server Developer Support Engineer
> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> > --
> >> >> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> >> >> Subject: Please help me install RS on Vista Business 64bit
> >> >> Date: Fri, 26 Oct 2007 18:09:51 +0100
> >> >> Lines: 44
> >> >> MIME-Version: 1.0
> >> >> Content-Type: text/plain;
> >> >> format=flowed;
> >> >> charset="iso-8859-1";
> >> >> reply-type=original
> >> >>
> >> >> SS2005 64bit is installed and running fine on my copy of Vista
> >> >> Business
> >> > 64
> >> >> here
> >> >>
> >> >> I've gone into Programs and Features and enabled all the
IIS/ASP.NET
> >> > stuff
> >> >> posted on the internet.
> >> >>
> >> >> I've also created a IWAM_computername account and added it to the
> >> >> Administrators group.
> >> >>
> >> >> The setup program says it has to be run from the command prompt
with
> >> the
> >> >> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
> >> >>
> >> >> This is what I've tried:
> >> >>
> >> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> >> ADDLOCAL=RS_Server
> >> >> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
> >> >> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
> >> >>
> >> >> It gets to installing Reporting Services and when the status is
> >> > "Configuring
> >> >> Components" it gives the error:
> >> >>
> >> >> "SQL Server setup could not validate the service accounts. Either
> >> >> the
> >> >> service accounts have not been provided for all of the services
being
> >> >> installed, or the specified username or password is incorrect. For
> >> each
> >> >> service, specify a valid username, password and domain or specify a
> >> > built-in
> >> >> system account."
> >> >>
> >> >> I've also tried:
> >> >>
> >> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> >> ADDLOCAL=RS_Server
> >> >> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
> >> >>
> >> >> and
> >> >>
> >> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> >> ADDLOCAL=RS_Server
> >> >> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
> >> >>
> >> >> Any help much appreciated!
> >> >>
> >> >> Clive (London UK)
> >> >>
> >> >>
> >> >
> >>
> >>
> >>
> >
>sql