RSExecutionLog_Update.dts fails for named SQL Instance

Hi:
I am running SRS on a named instance of SQL. When I attempt to run this DTS
package, it fails on the five update steps with the error message "Cannot
open database requested in login 'ReportServer'. Login fails."
How can I point it to the non-default instance of SQL.
Thanks in advance.
Bruce.Have you tried changing the server name in the RSExecutionLog_Update.ini
file? I have never used the package with a non-default instance of SQL
server, but I assume it should work when you make the appropriate edits in
the above ini file.
Charles Kangai, MCT, MCDBA
"bwschiek@.hotmail.com" wrote:
> Hi:
> I am running SRS on a named instance of SQL. When I attempt to run this DTS
> package, it fails on the five update steps with the error message "Cannot
> open database requested in login 'ReportServer'. Login fails."
> How can I point it to the non-default instance of SQL.
> Thanks in advance.
> Bruce.|||Hi Charles:
It worked! I changed the server setting for both the source and destination
from (local) to ServerName\SQLInstanceName and the DTS package executed as
intented!
Thanks for the quick and accurate reply!
Bruce.
"Charles Kangai" wrote:
> Have you tried changing the server name in the RSExecutionLog_Update.ini
> file? I have never used the package with a non-default instance of SQL
> server, but I assume it should work when you make the appropriate edits in
> the above ini file.
> Charles Kangai, MCT, MCDBA
> "bwschiek@.hotmail.com" wrote:
> > Hi:
> >
> > I am running SRS on a named instance of SQL. When I attempt to run this DTS
> > package, it fails on the five update steps with the error message "Cannot
> > open database requested in login 'ReportServer'. Login fails."
> >
> > How can I point it to the non-default instance of SQL.
> >
> > Thanks in advance.
> >
> > Bruce.

RS Web Parts on SharePoint 2007

Hi,

I'm having troubles connecting the webparts on SharePoint 2007. I installed the RSWebParts package from SQL Server 2005 Reporting Services on my MOSS 2007 box. The installation went smoothly and I can add both Report Explorer and Report Viewer on a page. But when I try to connect RE to RV I get the following error:

An unexpected error has occurred.

Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.

So I have to go to the maintenance page and remove the web parts.

Have anyone managed to bypass this and make them work together?

Thanks,

Hi kiral,

Not sure if you have already solved this one, but the answer lies deep within MSDN, and I only just found it yesterday after much googling and heartache.

http://msdn2.microsoft.com/en-us/library/ms159772.aspx

For Web Parts to communicate yuo need to specify -globalinstall on the STSADM.exe command line.

If you have already installed them without this you need to first uninstall them, then reinstall with the -globalinstall flag.

Why on earth this was not the default instead of the other way round though, only Microsoft knows.

Happy to Help.

RS Web Parts on SharePoint 2007

Hi,

I'm having troubles connecting the webparts on SharePoint 2007. I installed the RSWebParts package from SQL Server 2005 Reporting Services on my MOSS 2007 box. The installation went smoothly and I can add both Report Explorer and Report Viewer on a page. But when I try to connect RE to RV I get the following error:

An unexpected error has occurred.

Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.

So I have to go to the maintenance page and remove the web parts.

Have anyone managed to bypass this and make them work together?

Thanks,

Hi kiral,

Not sure if you have already solved this one, but the answer lies deep within MSDN, and I only just found it yesterday after much googling and heartache.

http://msdn2.microsoft.com/en-us/library/ms159772.aspx

For Web Parts to communicate yuo need to specify -globalinstall on the STSADM.exe command line.

If you have already installed them without this you need to first uninstall them, then reinstall with the -globalinstall flag.

Why on earth this was not the default instead of the other way round though, only Microsoft knows.

Happy to Help.

RS separately from SQL (express) 2005

Hi,
there's a package of the RS installable without SQL (express) 2005 ?
Thanks
AdrianoAdriano,
The publicity material and the product are a little out of step for
SQL Server 2005 Express.
The build of SQL Server 2005 Express Edition that should be launched
next month doesn't include Reporting Services.
There will some sort of update for Express Edition, maybe by mid 2006,
which will include limited Reporting Services functionality.
I don't think any dates have been announced yet.
Andrew Watt
MVP - InfoPath
On Mon, 17 Oct 2005 13:10:16 +0200, "Adry" <adry@.ij_nospam.it> wrote:
>Hi,
>there's a package of the RS installable without SQL (express) 2005 ?
>Thanks
>Adriano|||Until this moment I was sure that Reporting Services was included in SQL
Server Express Edition, then FREE (see the page
http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx).
Now, your answer generates confusion in me:
why MS publics a "SQL Server 2005 Features Comparison" including SQL Server
Express Edition ?
Further, Reporting Services is FREE or NOT ?
Thanks
Adriano
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> ha scritto nel
messaggio news:bt87l1dc4eiurqrelgsu1gjifmedcubg4m@.4ax.com...
> Adriano,
> The publicity material and the product are a little out of step for
> SQL Server 2005 Express.
> The build of SQL Server 2005 Express Edition that should be launched
> next month doesn't include Reporting Services.
> There will some sort of update for Express Edition, maybe by mid 2006,
> which will include limited Reporting Services functionality.
> I don't think any dates have been announced yet.
> Andrew Watt
> MVP - InfoPath
> On Mon, 17 Oct 2005 13:10:16 +0200, "Adry" <adry@.ij_nospam.it> wrote:
>>Hi,
>>there's a package of the RS installable without SQL (express) 2005 ?
>>Thanks
>>Adriano
>|||First, nothing is released yet. I am not sure of Andrew's statement about
release schedule for Express but I have not been following it since I don't
use Express.
Key points: Nothing is released yet. When it is, according to the link you
provided, RS will be supported with the Express product, with the caveat
that the data must exists locally on the same machine and relational only
(no cubes).
Second point: RS is not free. It is part of SQL Server. So it depends on the
version licensed. Just to be clear, since Express is free, then the version
with Express is free. But notice that there are limits to the use of RS with
Express(the data is local to machine). It is not free for all versions. For
instance, for Standard you need a standard SQL license. Enterprise you need
an enterprise license.
Also, Visual Studio 2005 will have winform and webform controls that can
work in stand alone mode, no server necessary. Give it a report and a
dataset and away it goes.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adry" <adry@.ij_nospam.it> wrote in message
news:%23MwzxDy0FHA.3256@.TK2MSFTNGP09.phx.gbl...
> Until this moment I was sure that Reporting Services was included in SQL
> Server Express Edition, then FREE (see the page
> http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx).
> Now, your answer generates confusion in me:
> why MS publics a "SQL Server 2005 Features Comparison" including SQL
> Server Express Edition ?
> Further, Reporting Services is FREE or NOT ?
>
> Thanks
> Adriano
>
> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> ha scritto nel
> messaggio news:bt87l1dc4eiurqrelgsu1gjifmedcubg4m@.4ax.com...
>> Adriano,
>> The publicity material and the product are a little out of step for
>> SQL Server 2005 Express.
>> The build of SQL Server 2005 Express Edition that should be launched
>> next month doesn't include Reporting Services.
>> There will some sort of update for Express Edition, maybe by mid 2006,
>> which will include limited Reporting Services functionality.
>> I don't think any dates have been announced yet.
>> Andrew Watt
>> MVP - InfoPath
>> On Mon, 17 Oct 2005 13:10:16 +0200, "Adry" <adry@.ij_nospam.it> wrote:
>>Hi,
>>there's a package of the RS installable without SQL (express) 2005 ?
>>Thanks
>>Adriano
>|||Hi Bruce,
now it's all OK (more clear).
How or where (site link, etc.) can I stay tuned to have last updated info
about the question (RS included in Express Edition) ?
Thanks
Adriano
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ha scritto nel messaggio
news:u4dle7y0FHA.460@.TK2MSFTNGP15.phx.gbl...
> First, nothing is released yet. I am not sure of Andrew's statement about
> release schedule for Express but I have not been following it since I
> don't use Express.
> Key points: Nothing is released yet. When it is, according to the link you
> provided, RS will be supported with the Express product, with the caveat
> that the data must exists locally on the same machine and relational only
> (no cubes).
> Second point: RS is not free. It is part of SQL Server. So it depends on
> the version licensed. Just to be clear, since Express is free, then the
> version with Express is free. But notice that there are limits to the use
> of RS with Express(the data is local to machine). It is not free for all
> versions. For instance, for Standard you need a standard SQL license.
> Enterprise you need an enterprise license.
> Also, Visual Studio 2005 will have winform and webform controls that can
> work in stand alone mode, no server necessary. Give it a report and a
> dataset and away it goes.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Adry" <adry@.ij_nospam.it> wrote in message
> news:%23MwzxDy0FHA.3256@.TK2MSFTNGP09.phx.gbl...
>> Until this moment I was sure that Reporting Services was included in SQL
>> Server Express Edition, then FREE (see the page
>> http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx).
>> Now, your answer generates confusion in me:
>> why MS publics a "SQL Server 2005 Features Comparison" including SQL
>> Server Express Edition ?
>> Further, Reporting Services is FREE or NOT ?
>>
>> Thanks
>> Adriano
>>
>> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> ha scritto nel
>> messaggio news:bt87l1dc4eiurqrelgsu1gjifmedcubg4m@.4ax.com...
>> Adriano,
>> The publicity material and the product are a little out of step for
>> SQL Server 2005 Express.
>> The build of SQL Server 2005 Express Edition that should be launched
>> next month doesn't include Reporting Services.
>> There will some sort of update for Express Edition, maybe by mid 2006,
>> which will include limited Reporting Services functionality.
>> I don't think any dates have been announced yet.
>> Andrew Watt
>> MVP - InfoPath
>> On Mon, 17 Oct 2005 13:10:16 +0200, "Adry" <adry@.ij_nospam.it> wrote:
>>Hi,
>>there's a package of the RS installable without SQL (express) 2005 ?
>>Thanks
>>Adriano
>>
>|||I assume when the do the lauch (Nov 7th) that all this should be clear.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adry" <adry@.ij_nospam.it> wrote in message
news:eh6hKUz0FHA.2924@.TK2MSFTNGP15.phx.gbl...
> Hi Bruce,
> now it's all OK (more clear).
> How or where (site link, etc.) can I stay tuned to have last updated info
> about the question (RS included in Express Edition) ?
>
> Thanks
> Adriano
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ha scritto nel messaggio
> news:u4dle7y0FHA.460@.TK2MSFTNGP15.phx.gbl...
>> First, nothing is released yet. I am not sure of Andrew's statement about
>> release schedule for Express but I have not been following it since I
>> don't use Express.
>> Key points: Nothing is released yet. When it is, according to the link
>> you provided, RS will be supported with the Express product, with the
>> caveat that the data must exists locally on the same machine and
>> relational only (no cubes).
>> Second point: RS is not free. It is part of SQL Server. So it depends on
>> the version licensed. Just to be clear, since Express is free, then the
>> version with Express is free. But notice that there are limits to the use
>> of RS with Express(the data is local to machine). It is not free for all
>> versions. For instance, for Standard you need a standard SQL license.
>> Enterprise you need an enterprise license.
>> Also, Visual Studio 2005 will have winform and webform controls that can
>> work in stand alone mode, no server necessary. Give it a report and a
>> dataset and away it goes.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Adry" <adry@.ij_nospam.it> wrote in message
>> news:%23MwzxDy0FHA.3256@.TK2MSFTNGP09.phx.gbl...
>> Until this moment I was sure that Reporting Services was included in SQL
>> Server Express Edition, then FREE (see the page
>> http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx).
>> Now, your answer generates confusion in me:
>> why MS publics a "SQL Server 2005 Features Comparison" including SQL
>> Server Express Edition ?
>> Further, Reporting Services is FREE or NOT ?
>>
>> Thanks
>> Adriano
>>
>> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> ha scritto nel
>> messaggio news:bt87l1dc4eiurqrelgsu1gjifmedcubg4m@.4ax.com...
>> Adriano,
>> The publicity material and the product are a little out of step for
>> SQL Server 2005 Express.
>> The build of SQL Server 2005 Express Edition that should be launched
>> next month doesn't include Reporting Services.
>> There will some sort of update for Express Edition, maybe by mid 2006,
>> which will include limited Reporting Services functionality.
>> I don't think any dates have been announced yet.
>> Andrew Watt
>> MVP - InfoPath
>> On Mon, 17 Oct 2005 13:10:16 +0200, "Adry" <adry@.ij_nospam.it> wrote:
>>Hi,
>>there's a package of the RS installable without SQL (express) 2005 ?
>>Thanks
>>Adriano
>>
>>
>|||When I was discussing this issue with a member of the Express team, it
was indicated that the best place to watch for updates is the SQL
Express team blog at http://blogs.msdn.com/sqlexpress
I hope that helps.
Andrew Watt
MVP - InfoPath
On Mon, 17 Oct 2005 18:08:35 +0200, "Adry" <adry@.ij_nospam.it> wrote:
>Hi Bruce,
>now it's all OK (more clear).
>How or where (site link, etc.) can I stay tuned to have last updated info
>about the question (RS included in Express Edition) ?
>
>Thanks
>Adriano
>
>"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ha scritto nel messaggio
>news:u4dle7y0FHA.460@.TK2MSFTNGP15.phx.gbl...
>> First, nothing is released yet. I am not sure of Andrew's statement about
>> release schedule for Express but I have not been following it since I
>> don't use Express.
>> Key points: Nothing is released yet. When it is, according to the link you
>> provided, RS will be supported with the Express product, with the caveat
>> that the data must exists locally on the same machine and relational only
>> (no cubes).
>> Second point: RS is not free. It is part of SQL Server. So it depends on
>> the version licensed. Just to be clear, since Express is free, then the
>> version with Express is free. But notice that there are limits to the use
>> of RS with Express(the data is local to machine). It is not free for all
>> versions. For instance, for Standard you need a standard SQL license.
>> Enterprise you need an enterprise license.
>> Also, Visual Studio 2005 will have winform and webform controls that can
>> work in stand alone mode, no server necessary. Give it a report and a
>> dataset and away it goes.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Adry" <adry@.ij_nospam.it> wrote in message
>> news:%23MwzxDy0FHA.3256@.TK2MSFTNGP09.phx.gbl...
>> Until this moment I was sure that Reporting Services was included in SQL
>> Server Express Edition, then FREE (see the page
>> http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx).
>> Now, your answer generates confusion in me:
>> why MS publics a "SQL Server 2005 Features Comparison" including SQL
>> Server Express Edition ?
>> Further, Reporting Services is FREE or NOT ?
>>
>> Thanks
>> Adriano
>>
>> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> ha scritto nel
>> messaggio news:bt87l1dc4eiurqrelgsu1gjifmedcubg4m@.4ax.com...
>> Adriano,
>> The publicity material and the product are a little out of step for
>> SQL Server 2005 Express.
>> The build of SQL Server 2005 Express Edition that should be launched
>> next month doesn't include Reporting Services.
>> There will some sort of update for Express Edition, maybe by mid 2006,
>> which will include limited Reporting Services functionality.
>> I don't think any dates have been announced yet.
>> Andrew Watt
>> MVP - InfoPath
>> On Mon, 17 Oct 2005 13:10:16 +0200, "Adry" <adry@.ij_nospam.it> wrote:
>>Hi,
>>there's a package of the RS installable without SQL (express) 2005 ?
>>Thanks
>>Adriano
>>
>>
>

RS Installation fail without message.

Hi!
I've installed RS alot during the last 6 months and been falling into every
pit there is in this package, but now theres something really fishy with my
current installation. During RS installation on a member server (Win2000 SP4,
SQL2000 Std SP3a, RS 2000 Std) i dont get the usual Server Components choices
and so on. The usual warning about Visual Studio apperas. But then as i click
"Next" in the warning box the installation just continues on. The box "To
continue please click next" appears but i dont get a chance to click next as
the installation just goes on "automagically". The installation rolls on and
on but after it says it finished successfully the IIS mappings and the RS DBs
arent there. Been googloing alot but noone seems to have any tips about this.
So i'm turning to the pro's =)
Any tips greatly appriciated...
JohanIf you have IIS installed and no other installations of RS, you should get
the server components.
In your %temp% directory, you will find log files from setup. You can send
them to me if you like and I will take a look.
--
| Thread-Topic: RS Installation fail without message.
| thread-index: AcVsKdmDrv64JJk4ShWRGHyRJB9KYQ==| X-WBNR-Posting-Host: 62.13.18.10
| From: "=?Utf-8?B?Sm9oYW4=?=" <Johan@.discussions.microsoft.com>
| Subject: RS Installation fail without message.
| Date: Wed, 8 Jun 2005 05:59:04 -0700
| Lines: 16
| Message-ID: <9AC9C5CC-E8C3-492D-9DC5-88842C81FEF9@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45543
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi!
| I've installed RS alot during the last 6 months and been falling into
every
| pit there is in this package, but now theres something really fishy with
my
| current installation. During RS installation on a member server (Win2000
SP4,
| SQL2000 Std SP3a, RS 2000 Std) i dont get the usual Server Components
choices
| and so on. The usual warning about Visual Studio apperas. But then as i
click
| "Next" in the warning box the installation just continues on. The box "To
| continue please click next" appears but i dont get a chance to click next
as
| the installation just goes on "automagically". The installation rolls on
and
| on but after it says it finished successfully the IIS mappings and the RS
DBs
| arent there. Been googloing alot but noone seems to have any tips about
this.
| So i'm turning to the pro's =)
|
| Any tips greatly appriciated...
|
| Johan
||||Here comes the logfiles you wanted from the SQL RS Community discussion
board. Cant read anything from them myself, maybe you can find anything in
them? If you need any more information about the servers behavior please
reply to this email.
Theres a file called RSMSI0.log which is 5 Meggs large...do you need that
too? Below is the file rsstp0.log...
Thanks in advance.
Johan
--Logfile start here--
Microsoft SQL Server 2000 Reporting Services Setup beginning at Thu Jun 09
08:48:55 2005
<Func Name='UpdateComponents'>
SCU_SetupMgr::InitComponents()
<Func Name='WindowsInstallerComp::Init'>
<Func Name='WindowsInstallerComp::IsRequired'>
<Func Name='DotNetFxComp::Init'>
<Func Name='DotNetFxComp::IsRequired'>
<EndFunc Name='DotNetFxComp::IsRequired' Return='F' GetLastError='0'>
SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:414}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
<Func Name='SqlSetupFilesComp::Install'>
<Func Name='BootstrapPackageLogic'>
<Func Name='InstallBootstrapPackage'>
/I "E:\Reporting Services Std\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033" /qn
<EndFunc Name='InstallBootstrapPackage' Return='0' GetLastError='183'>
<EndFunc Name='BootstrapPackageLogic' Return='0' GetLastError='183'>
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED, cancel_state=0,
is_done=1, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\Reporting Services Std
QuietMode=false
Unattended=false
WorkDir=E:\Reporting Services Std
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:420}
<EndFunc Name='UpdateComponents' Return='0' GetLastError='183'>
<Func Name='DwLaunchMsiExec'>
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Machine = PROMODEV3, Article = IIS, Result = 0 (0x0)
<Prerequisite Name="IsVS71Installed" Checked="Registry"
Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1\InstallDir" Found="Can not
read value" Expected="No error" Result="Fail" />
Machine = PROMODEV3, Article = VSNET, Result = 60351 (0xebbf)
Getting IIS Metabase data /LM/W3SVC/AppIsolated
Machine = PROMODEV3, Article = ASPNET, Result = 0 (0x0)
Machine = PROMODEV3, Article = MDAC, Result = 0 (0x0)
Machine = PROMODEV3, Article = DTC, Result = 0 (0x0)
Machine = PROMODEV3, Article = SERVEROS, Result = 0 (0x0)
Machine = PROMODEV3, Article = SHAREPOINT, Result = 0 (0x0)
Machine = PROMODEV3, Article = AUTHZ, Result = 0 (0x0)
Machine = PROMODEV3, Article = RSACCOUNTS, Result = 0 (0x0)
**************
PROMODEV3
**************
Report Designer component requirement
<B>Explanation:</B> Visual Studio .NET 2003 is not installed.
<B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to
install Report Designer. Or, continue Setup to complete the installation
without Report Designer.
Report size = 475
<Func Name='SetDotNetProperties'>
--Logfile ends here--
""Brad Syputa - MS"" wrote:
> If you have IIS installed and no other installations of RS, you should get
> the server components.
> In your %temp% directory, you will find log files from setup. You can send
> them to me if you like and I will take a look.
> --
> | Thread-Topic: RS Installation fail without message.
> | thread-index: AcVsKdmDrv64JJk4ShWRGHyRJB9KYQ==> | X-WBNR-Posting-Host: 62.13.18.10
> | From: "=?Utf-8?B?Sm9oYW4=?=" <Johan@.discussions.microsoft.com>
> | Subject: RS Installation fail without message.
> | Date: Wed, 8 Jun 2005 05:59:04 -0700
> | Lines: 16
> | Message-ID: <9AC9C5CC-E8C3-492D-9DC5-88842C81FEF9@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45543
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hi!
> | I've installed RS alot during the last 6 months and been falling into
> every
> | pit there is in this package, but now theres something really fishy with
> my
> | current installation. During RS installation on a member server (Win2000
> SP4,
> | SQL2000 Std SP3a, RS 2000 Std) i dont get the usual Server Components
> choices
> | and so on. The usual warning about Visual Studio apperas. But then as i
> click
> | "Next" in the warning box the installation just continues on. The box "To
> | continue please click next" appears but i dont get a chance to click next
> as
> | the installation just goes on "automagically". The installation rolls on
> and
> | on but after it says it finished successfully the IIS mappings and the RS
> DBs
> | arent there. Been googloing alot but noone seems to have any tips about
> this.
> | So i'm turning to the pro's =)
> |
> | Any tips greatly appriciated...
> |
> | Johan
> |
>|||I cannot determine why you are failing. I have tried setup on your exact
configuration myself and found no issues.
I you really need a resolution, you can contact MS Support Services. They
will be able to fix your issue or find out if it is a bug. If it is a bug
in an MS product, the support costs are reimbursed.
--
| Thread-Topic: RS Installation fail without message.
| thread-index: AcVsxnMFw0S6vuG8SuCOmkzmjcMrjw==| X-WBNR-Posting-Host: 62.13.18.10
| From: "=?Utf-8?B?Sm9oYW4=?=" <Johan@.discussions.microsoft.com>
| References: <9AC9C5CC-E8C3-492D-9DC5-88842C81FEF9@.microsoft.com>
<qGn1DmEbFHA.3336@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: RS Installation fail without message.
| Date: Thu, 9 Jun 2005 00:40:03 -0700
| Lines: 237
| Message-ID: <1DBE2B1B-6CF3-4482-9ACD-17D8A2B60FD3@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45620
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Here comes the logfiles you wanted from the SQL RS Community discussion
| board. Cant read anything from them myself, maybe you can find anything
in
| them? If you need any more information about the servers behavior please
| reply to this email.
|
| Theres a file called RSMSI0.log which is 5 Meggs large...do you need
that
| too? Below is the file rsstp0.log...
|
| Thanks in advance.
| Johan
|
| --Logfile start here--
| Microsoft SQL Server 2000 Reporting Services Setup beginning at Thu Jun
09
| 08:48:55 2005
| <Func Name='UpdateComponents'>
| SCU_SetupMgr::InitComponents()
| <Func Name='WindowsInstallerComp::Init'>
| <Func Name='WindowsInstallerComp::IsRequired'>
| <Func Name='DotNetFxComp::Init'>
| <Func Name='DotNetFxComp::IsRequired'>
| <EndFunc Name='DotNetFxComp::IsRequired' Return='F' GetLastError='0'>
| SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:414}
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| <Func Name='SqlSetupFilesComp::Install'>
| <Func Name='BootstrapPackageLogic'>
| <Func Name='InstallBootstrapPackage'>
| /I "E:\Reporting Services Std\Setup\bootmsi.dat"
REBOOT="ReallySuppress"
|
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles10
31,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,Hel
pFiles2052,HelpFiles3082,WatsonFiles1033" /qn
| <EndFunc Name='InstallBootstrapPackage' Return='0' GetLastError='183'>
| <EndFunc Name='BootstrapPackageLogic' Return='0' GetLastError='183'>
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
| ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
| ScuProgressDlg::SetupFinished()
| ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
| SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED, cancel_state=0,
| is_done=1, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
| HandleReboots=false
| ModuleDir=E:\Reporting Services Std
| QuietMode=false
| Unattended=false
| WorkDir=E:\Reporting Services Std
| }} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:420}
| <EndFunc Name='UpdateComponents' Return='0' GetLastError='183'>
| <Func Name='DwLaunchMsiExec'>
| <Func Name='PerformDetections'>
| 0
| <EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
| Machine = PROMODEV3, Article = IIS, Result = 0 (0x0)
| <Prerequisite Name="IsVS71Installed" Checked="Registry"
| Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1\InstallDir" Found="Can not
| read value" Expected="No error" Result="Fail" />
| Machine = PROMODEV3, Article = VSNET, Result = 60351 (0xebbf)
| Getting IIS Metabase data /LM/W3SVC/AppIsolated
| Machine = PROMODEV3, Article = ASPNET, Result = 0 (0x0)
| Machine = PROMODEV3, Article = MDAC, Result = 0 (0x0)
| Machine = PROMODEV3, Article = DTC, Result = 0 (0x0)
| Machine = PROMODEV3, Article = SERVEROS, Result = 0 (0x0)
| Machine = PROMODEV3, Article = SHAREPOINT, Result = 0 (0x0)
| Machine = PROMODEV3, Article = AUTHZ, Result = 0 (0x0)
| Machine = PROMODEV3, Article = RSACCOUNTS, Result = 0 (0x0)
| **************
| PROMODEV3
| **************
| Report Designer component requirement
| <B>Explanation:</B> Visual Studio .NET 2003 is not installed.
| <B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to
| install Report Designer. Or, continue Setup to complete the installation
| without Report Designer.
| Report size = 475
| <Func Name='SetDotNetProperties'>
|
| --Logfile ends
here--
|
|
|
|
|
|
| ""Brad Syputa - MS"" wrote:
|
| > If you have IIS installed and no other installations of RS, you should
get
| > the server components.
| >
| > In your %temp% directory, you will find log files from setup. You can
send
| > them to me if you like and I will take a look.
| > --
| > | Thread-Topic: RS Installation fail without message.
| > | thread-index: AcVsKdmDrv64JJk4ShWRGHyRJB9KYQ==| > | X-WBNR-Posting-Host: 62.13.18.10
| > | From: "=?Utf-8?B?Sm9oYW4=?=" <Johan@.discussions.microsoft.com>
| > | Subject: RS Installation fail without message.
| > | Date: Wed, 8 Jun 2005 05:59:04 -0700
| > | Lines: 16
| > | Message-ID: <9AC9C5CC-E8C3-492D-9DC5-88842C81FEF9@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:45543
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | Hi!
| > | I've installed RS alot during the last 6 months and been falling into
| > every
| > | pit there is in this package, but now theres something really fishy
with
| > my
| > | current installation. During RS installation on a member server
(Win2000
| > SP4,
| > | SQL2000 Std SP3a, RS 2000 Std) i dont get the usual Server Components
| > choices
| > | and so on. The usual warning about Visual Studio apperas. But then as
i
| > click
| > | "Next" in the warning box the installation just continues on. The box
"To
| > | continue please click next" appears but i dont get a chance to click
next
| > as
| > | the installation just goes on "automagically". The installation rolls
on
| > and
| > | on but after it says it finished successfully the IIS mappings and
the RS
| > DBs
| > | arent there. Been googloing alot but noone seems to have any tips
about
| > this.
| > | So i'm turning to the pro's =)
| > |
| > | Any tips greatly appriciated...
| > |
| > | Johan
| > |
| >
| >
|

RS Execution Log and SQL 2005

Hello All,
SQL 2000 Reporting Services came with a DTS package that could be configured
to collect data daily on Report Execution. The results were then stored in a
RSExecutionLog database. Is this functionality still supported in 2005
Reporting Services?Well, for RS 2005 it is not a DTS package, it is a Integration Services
package. I was trying to get this working and I did not have Integration
Services installed (which requires reinstalling all service packs). So I
delayed until I had some time to install it.
Bruce Loehle-Conger
"EFrayer@.community.nospam"
<EFrayercommunitynospam@.discussions.microsoft.com> wrote in message
news:9F060287-4EAF-4FBD-9DA8-A1192674999E@.microsoft.com...
> Hello All,
> SQL 2000 Reporting Services came with a DTS package that could be
> configured
> to collect data daily on Report Execution. The results were then stored
> in a
> RSExecutionLog database. Is this functionality still supported in 2005
> Reporting Services?|||Can I get a little more information on how to do this? Where can I find this
Integration Services package that you are taking about?
"Bruce L-C [MVP]" wrote:
> Well, for RS 2005 it is not a DTS package, it is a Integration Services
> package. I was trying to get this working and I did not have Integration
> Services installed (which requires reinstalling all service packs). So I
> delayed until I had some time to install it.
> Bruce Loehle-Conger
> "EFrayer@.community.nospam"
> <EFrayercommunitynospam@.discussions.microsoft.com> wrote in message
> news:9F060287-4EAF-4FBD-9DA8-A1192674999E@.microsoft.com...
> > Hello All,
> > SQL 2000 Reporting Services came with a DTS package that could be
> > configured
> > to collect data daily on Report Execution. The results were then stored
> > in a
> > RSExecutionLog database. Is this functionality still supported in 2005
> > Reporting Services?
>
>