PORTS USED: services

Showing posts with label services. Show all posts

Monday, March 26, 2012

Pre Printed Forms in Reporting Services 2005

Hello
I have a requirement that I want to use reporting service for -- but I can't
seem to get it to work. I've researched this all weekend with no luck.
I'm trying to use reporting services 2005 to print content into pre printed
forms. The building of the report is very simple -- the problem is placing
the
fields correctly in the designer.
The approach that I'm using is a 5 step process as follows:
1) Scan an image of the form to a gif;
2) Add it in the designer in an image control;
3) Send the image control to the back;
4) Place text controls where the data is to be printed; and
5) Remove the image from the designer before publishing.
What I'm experiencing is the image IS NOT being rendered as the original size
within the designer so the printing doesn't match the physical forms.
No matter what I've tried, I can't solve this issue. Do you know of a
solution
and/or could you forward to someone that can help me out?
Thanks in advance.
Clay SeifertClay- We got forms lineup to work in the new Framework 2 controls by setting
the background form image to 96 dpi. We aren't exactly sure why it works --
just that it does. You might give that a try.
BillJ
"Clay" wrote:
> Hello
> I have a requirement that I want to use reporting service for -- but I can't
> seem to get it to work. I've researched this all weekend with no luck.
> I'm trying to use reporting services 2005 to print content into pre printed
> forms. The building of the report is very simple -- the problem is placing
> the
> fields correctly in the designer.
> The approach that I'm using is a 5 step process as follows:
> 1) Scan an image of the form to a gif;
> 2) Add it in the designer in an image control;
> 3) Send the image control to the back;
> 4) Place text controls where the data is to be printed; and
> 5) Remove the image from the designer before publishing.
> What I'm experiencing is the image IS NOT being rendered as the original size
> within the designer so the printing doesn't match the physical forms.
> No matter what I've tried, I can't solve this issue. Do you know of a
> solution
> and/or could you forward to someone that can help me out?
> Thanks in advance.
> Clay Seifert
>

Powerpoint-Reporting with SQL2005 Reporting Services

Hi All,
the SQL Server Business Intelligence Development Studio is not equipped with
an option to output powerpoint presentations.
we have to migrate an legacy application which has been coded in access-vba.
the vba code uses data within an MSSQL Database and a powerpoint template
(.pot) and the output is a powerpoint presentation with lots of graphs and
charts in it.
we are thinking about porting the vba code into a code module within the SQL
Server Business Intelligence Development Studio.
does anybody know if it would technically be possible to use plain vba code
(ported from the access application) within SQL Server Business Intelligence
Development Studio to fill a powerpoint template and thus to generate a
whole powerpoint presentation? (provided that this whole vba-magic is
working within the access-application)
if the above stated idea is complete rubbish then please let me know. if it
might be possible to use SQL Server Business Intelligence Development Studio
to achieve this aim, please let me also know which steps this should
involve.
thanks a lot in advance!
best regards, janYou'd need to convert from VBA to VB.net.. I would really reccomend
writing some of the core logic in DLLs or something; I dont think that
putting hundreds of pages in code inside of a report would make a lot
of sense.. more importantly; you don't want 100 different copies of
this code; that would make maintenance difficult.
Then you would just digest this code inside the report properties
section; there is a 'code' window.
Why do you use powerpoint; anyways?
by chance do you work for a large auction web company in the Bay Area?
LoL?
We use OfficeWriter by SoftArtisans.. If I were you; I would push them
HARD to see if they can come up with a solution and then stand on the
shoulders of giants.
I just think that exporting to PPT might be a major pain.
Now.. for example.. if you wanted to talk about something that might be
a LOT LOT LOT easier to deal with?
you probably could just export the reports to XML format; and then
maybe make an XSLT that would 'translate' the XML out of SSRS into the
XML for PPT 07 or even 03.
Hope that helps; SSRS rocks!
-Aaron
Jan wrote:
> Hi All,
> the SQL Server Business Intelligence Development Studio is not equipped with
> an option to output powerpoint presentations.
> we have to migrate an legacy application which has been coded in access-vba.
> the vba code uses data within an MSSQL Database and a powerpoint template
> (.pot) and the output is a powerpoint presentation with lots of graphs and
> charts in it.
> we are thinking about porting the vba code into a code module within the SQL
> Server Business Intelligence Development Studio.
> does anybody know if it would technically be possible to use plain vba code
> (ported from the access application) within SQL Server Business Intelligence
> Development Studio to fill a powerpoint template and thus to generate a
> whole powerpoint presentation? (provided that this whole vba-magic is
> working within the access-application)
> if the above stated idea is complete rubbish then please let me know. if it
> might be possible to use SQL Server Business Intelligence Development Studio
> to achieve this aim, please let me also know which steps this should
> involve.
> thanks a lot in advance!
> best regards, jansql

PowerPoint format possible?

Hello,

we plan to use Reporting Services in the company in the near future. However, management prefers power point reports, a format which reporting services does not support (please correct me if I am wrong here).

Is there a third party extenstion tool for RS available which can produce PPT reports?

Best regards,

Michael Fuchs

Hello,

I'm not aware of any third-party PowerPoint renderer.

Can you explain your scenario that calls for PowerPoint rendering? Any insight you can offer will help to justify the possibility of providing this functionality in the future.

Thanks,
Chris

|||

Hello,

Management presents the reports in periodic meetings, currently pdf slides are used (these pdfs don't come from RS but from a self developed program), but this is not desired by management anymore, as pdf is not optimal for a presentation. What we need is nothing too fancy, just a slide with some formatting options (i.e. different templates) and the relevant charts and data presented on the slide.

I heard that ppt output is planned anyway in the next version of reporting services and that it already is in the testing stage. Is that just a rumor or can you confirm that?

Thanks,

Michael

Friday, March 23, 2012

Potential conflicts during cluster installs of SS2000 and AS2000

Hi,
Generally, are there any potential problems with installing Analysis
Services on a clustered server that already has SQLServer 2000
installed on multiple virtual servers? I mean in terms of
cross-dependencies between AS2000 and SS2000 with respect to their
functionalities or Service Pack requirements, or even any impacts on
client-side MDAC? Are there any good resources covering this?
In more detail... and where it gets tricky... and apologies for the
length but you will appreciate the need for detail...
I work in a validated environment. We run SS2000 SP1 on the production
cluster and SS2000 SP1 on a 2nd cluster (the 2nd cluster contains 2
validation instances and 1 reporting instance). Both production and
validation would have to be on the same service pack because it is
likely that the re-validation effort required would preclude an
upgrade.
[For those of you who are unfamiliar with the term validation...
Validation is essentially the same as testing, but testing in the
context of a regulated US FDA formal, documented testing regime which
medical device and pharmaceutical companies must adhere to. This puts a
very large and expensive burden on project lifecycles and means that
every change to the software or environment must be assessed as to its
impact on the quality of the system. As you can imagine, nothing gets
changed unless there is a very, very high level of confidence that
everything will be ok.]
Specifically... I have a production instance on 1 cluster. On a second
cluster I have 2 validation instances and 1 reporting instance (hence
AS2000). The applications are all VB6 client/server architecture
(although AS2000 will be a mixture of web and client MMC consoles)
Both machines are 2 node, active/passive clusters running Windows 2003
Server with SAN storage. The production cluster has 1 virtual server
with a SS2000 instance running on it. The second cluster has 3 virtual
servers which each have their own instance (i.e. separate binaries on
the E:\, F:\ and G:\ drives of the underlying single OS.) There are
SS2000 files on the C:\ drive which look like they might be shared -
not sure but they could also be the client tools for SS2000 (any
ideas?).
This is the output from the @.@.version command which is identical on
each of the instances:
"Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition on Windows NT 5.2 (Build 3790: Service Pack 1)"
Is it possible to:
1. Install separate service packs on the different instances on the
second cluster, i.e. keeping the 2 validation instances on SP1 and
moving the reporting instance to SP4. Are there any side-effects to
common files, regedit or uninstalling service packs complaining about
shared DLLs on C:\ drive?
2. After installing AS2000 (SP?) on the reporting virtual server on the
second cluster, would the presence of AS2000 on the second cluster
compromise in any way (i) the operation of the validation instances,
(ii) force an upgrade to a higher service pack on SS2000 the validation
instance, (iii) interfere with the way in which client MDAC DLLs
communicate with the validation instance or (iv) compromise an
uninstall scenario?
What makes me wonder about this is there there are a lot of components
and pre-requisites for AS2000. I successfully installed it on my own PC
(XP with MSDE - command line install) and found that the install was
quite intricate. The question is if the installs clearly and cleanly
operate independently of each other in a clustered/virtual server
context.
Any help would be very much appreciated.
Regards
LiamHi
From your @.@.VERSION you are on SQL Server 2000 Service Pack 4, if you are
using AWE then you should really be on version 2040 and this is a very
important fix if you ever need more than 50% of the RAM, if you enviage this
happening it may be worth planning ahead for your regression tests.
The main thing you may be concerned about is the performance impact of the
Analysis services, without performance testing the whole system you will not
know if this will affect performance of the other systems. I assume you have
good benchmarks that you performance criteria and data? From the software
side I don't know of any dependencies, the service packs are certainly
separate and your clients will not be affected. Different instances can run
of different service packs in a clustered environment. Most installations
don't have the executables on the SAN as this can cause a catch 22 situation
if the SAN fails, but you don't say what files are in which location so it is
imposible to know what is common and what is not in your configuration.
HTH
John
"Liam Caffrey" wrote:
> Hi,
> Generally, are there any potential problems with installing Analysis
> Services on a clustered server that already has SQLServer 2000
> installed on multiple virtual servers? I mean in terms of
> cross-dependencies between AS2000 and SS2000 with respect to their
> functionalities or Service Pack requirements, or even any impacts on
> client-side MDAC? Are there any good resources covering this?
> In more detail... and where it gets tricky... and apologies for the
> length but you will appreciate the need for detail...
> I work in a validated environment. We run SS2000 SP1 on the production
> cluster and SS2000 SP1 on a 2nd cluster (the 2nd cluster contains 2
> validation instances and 1 reporting instance). Both production and
> validation would have to be on the same service pack because it is
> likely that the re-validation effort required would preclude an
> upgrade.
> [For those of you who are unfamiliar with the term validation...
> Validation is essentially the same as testing, but testing in the
> context of a regulated US FDA formal, documented testing regime which
> medical device and pharmaceutical companies must adhere to. This puts a
> very large and expensive burden on project lifecycles and means that
> every change to the software or environment must be assessed as to its
> impact on the quality of the system. As you can imagine, nothing gets
> changed unless there is a very, very high level of confidence that
> everything will be ok.]
> Specifically... I have a production instance on 1 cluster. On a second
> cluster I have 2 validation instances and 1 reporting instance (hence
> AS2000). The applications are all VB6 client/server architecture
> (although AS2000 will be a mixture of web and client MMC consoles)
> Both machines are 2 node, active/passive clusters running Windows 2003
> Server with SAN storage. The production cluster has 1 virtual server
> with a SS2000 instance running on it. The second cluster has 3 virtual
> servers which each have their own instance (i.e. separate binaries on
> the E:\, F:\ and G:\ drives of the underlying single OS.) There are
> SS2000 files on the C:\ drive which look like they might be shared -
> not sure but they could also be the client tools for SS2000 (any
> ideas?).
> This is the output from the @.@.version command which is identical on
> each of the instances:
> "Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
> 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
> Edition on Windows NT 5.2 (Build 3790: Service Pack 1)"
> Is it possible to:
> 1. Install separate service packs on the different instances on the
> second cluster, i.e. keeping the 2 validation instances on SP1 and
> moving the reporting instance to SP4. Are there any side-effects to
> common files, regedit or uninstalling service packs complaining about
> shared DLLs on C:\ drive?
> 2. After installing AS2000 (SP?) on the reporting virtual server on the
> second cluster, would the presence of AS2000 on the second cluster
> compromise in any way (i) the operation of the validation instances,
> (ii) force an upgrade to a higher service pack on SS2000 the validation
> instance, (iii) interfere with the way in which client MDAC DLLs
> communicate with the validation instance or (iv) compromise an
> uninstall scenario?
> What makes me wonder about this is there there are a lot of components
> and pre-requisites for AS2000. I successfully installed it on my own PC
> (XP with MSDE - command line install) and found that the install was
> quite intricate. The question is if the installs clearly and cleanly
> operate independently of each other in a clustered/virtual server
> context.
> Any help would be very much appreciated.
> Regards
> Liam
>|||Yes, you are right... SP4 and yes, that hotfix is important especially
after we ordered extra RAM for the machine to bring it up to 8GB!!
SS2000 SP4 simplifies the whole thing... the question now is can the
installation of AS2000 affect in any way the installed SS2000 SP4 files
that reside outside of the virtual servers , i.e. on the C:\ with the
OS. I attach the directory listing?
(BTW, I am assuming that any SS2000 files inside the virtual servers
will not be affected. Is this correct? )
>From this posting it looks like the answer might be yes... this person
had a problem installing SP4 on a multi-instance 2003 server...
http://groups.google.ie/group/microsoft.public.sqlserver.setup/browse_frm/thread/cc58d69e4ad1524/98ec03c19d001c99?lnk=st&q=msxmlsql.dll+-failed&rnum=4&hl=en#98ec03c19d001c99
It wouldn't let him write to a shared file that is listed below
(msxmlsql.rll) during the application of SP4 while the second instance
was running. What was it trying to write? Would the same happen with
AS2000 install or the hotfix? This is precisely what I am trying to
figure out. What is the impact of whatever is written?
This is the current directory for the listing:
C:\Program Files\Microsoft SQL Server
Do anything here stand out? (We don't use replication or log shipping -
just backup log/copy/restore jobs)
Thanks for your help...
Liam
.\80
.\80\COM
.\80\Shared
.\80\Tools
.\80\COM\1033
.\80\COM\distrib.exe
.\80\COM\dw15.exe
.\80\COM\impprov.dll
.\80\COM\logread.exe
.\80\COM\mergetxt.dll
.\80\COM\msgprox.dll
.\80\COM\Other
.\80\COM\qrdrsvc.exe
.\80\COM\rdistcom.dll
.\80\COM\replagnt.dll
.\80\COM\repldist.dll
.\80\COM\repldp.dll
.\80\COM\repldsui.dll
.\80\COM\repldts.dll
.\80\COM\replerrx.dll
.\80\COM\replmerg.exe
.\80\COM\replprov.dll
.\80\COM\replprox.dll
.\80\COM\replrec.dll
.\80\COM\replsub.dll
.\80\COM\replsync.dll
.\80\COM\Resources
.\80\COM\rinitcom.dll
.\80\COM\snapshot.exe
.\80\COM\spresolv.dll
.\80\COM\sqldistx.dll
.\80\COM\sqldumper.exe
.\80\COM\sqlfth75.dll
.\80\COM\sqlinitx.dll
.\80\COM\sqlmergx.dll
.\80\COM\sqlresld.dll
.\80\COM\sqlvdi.dll
.\80\COM\ssradd.dll
.\80\COM\ssravg.dll
.\80\COM\ssrdown.dll
.\80\COM\ssrmax.dll
.\80\COM\ssrmin.dll
.\80\COM\ssrpub.dll
.\80\COM\ssrup.dll
.\80\COM\1033\dwintl.dll
.\80\COM\Other\dwintl.dll
.\80\COM\Resources\1033
.\80\COM\Resources\1033\replres.rll
.\80\Shared\msxmlsql.dll
.\80\Shared\Resources
.\80\Shared\Resources\1033
.\80\Shared\Resources\1033\msxmlsql.rll
.\80\Tools\Binn
.\80\Tools\Books
.\80\Tools\DevTools
.\80\Tools\HTML
.\80\Tools\Install
.\80\Tools\Scripts
.\80\Tools\sqlsun.dll
.\80\Tools\sqlsunin.ini
.\80\Tools\Templates
.\80\Tools\Uninst.isu
.\80\Tools\Binn\autoplt.dll
.\80\Tools\Binn\autowiz.dll
.\80\Tools\Binn\axscphst.dll
.\80\Tools\Binn\bcp.exe
.\80\Tools\Binn\cdw.exe
.\80\Tools\Binn\cdwtasks.dll
.\80\Tools\Binn\cdwtskui.dll
.\80\Tools\Binn\cnfgsvr.exe
.\80\Tools\Binn\cnfgsvr.ini
.\80\Tools\Binn\colctrl.dll
.\80\Tools\Binn\comnevnt.dll
.\80\Tools\Binn\ctasksui.dll
.\80\Tools\Binn\custtask.dll
.\80\Tools\Binn\dcomscm.exe
.\80\Tools\Binn\dtsffile.dll
.\80\Tools\Binn\dtspkg.dll
.\80\Tools\Binn\dtspump.dll
.\80\Tools\Binn\dtsrun.exe
.\80\Tools\Binn\dtsrunui.exe
.\80\Tools\Binn\dtsui.dll
.\80\Tools\Binn\dtswiz.dll
.\80\Tools\Binn\dtswiz.exe
.\80\Tools\Binn\hhsetup.dll
.\80\Tools\Binn\isql.exe
.\80\Tools\Binn\isqlw.exe
.\80\Tools\Binn\itwiz.exe
.\80\Tools\Binn\objmgr.dll
.\80\Tools\Binn\objmgr80.xml
.\80\Tools\Binn\odbccmpt.exe
.\80\Tools\Binn\osql.exe
.\80\Tools\Binn\pfclnt80.dll
.\80\Tools\Binn\pfutil80.dll
.\80\Tools\Binn\profiler.exe
.\80\Tools\Binn\psdcscm.dll
.\80\Tools\Binn\rebuildm.exe
.\80\Tools\Binn\replmon.pmc
.\80\Tools\Binn\Resources
.\80\Tools\Binn\scm.exe
.\80\Tools\Binn\sdiclnt.dll
.\80\Tools\Binn\semcomn.dll
.\80\Tools\Binn\semcros.dll
.\80\Tools\Binn\semdll.dll
.\80\Tools\Binn\semdts.dll
.\80\Tools\Binn\semexec.dll
.\80\Tools\Binn\semmap.dll
.\80\Tools\Binn\semnt.dll
.\80\Tools\Binn\semobj.dll
.\80\Tools\Binn\semrepl.dll
.\80\Tools\Binn\semsfc.dll
.\80\Tools\Binn\semsys.dll
.\80\Tools\Binn\semwebwz.dll
.\80\Tools\Binn\semwiz.dll
.\80\Tools\Binn\sqdedev.dll
.\80\Tools\Binn\sql iis admin.msc
.\80\Tools\Binn\SQL Server Enterprise Manager.MSC
.\80\Tools\Binn\sqladhlp.exe
.\80\Tools\Binn\sqlbrows.cnt
.\80\Tools\Binn\sqlbrows.hlp
.\80\Tools\Binn\sqldmo.dll
.\80\Tools\Binn\sqldmo80.cnt
.\80\Tools\Binn\sqldmo80.hlp
.\80\Tools\Binn\sqldts80.cnt
.\80\Tools\Binn\sqldts80.hlp
.\80\Tools\Binn\sqlftwiz.dll
.\80\Tools\Binn\sqlftwiz.exe
.\80\Tools\Binn\sqlgui.dll
.\80\Tools\Binn\sqllex.dll
.\80\Tools\Binn\sqlmangr.exe
.\80\Tools\Binn\sqlmmc.dll
.\80\Tools\Binn\sqlmmcem.chm
.\80\Tools\Binn\sqlmmcii.chm
.\80\Tools\Binn\sqlns.dll
.\80\Tools\Binn\sqlns80.cnt
.\80\Tools\Binn\sqlns80.hlp
.\80\Tools\Binn\sqlqry.dll
.\80\Tools\Binn\sqlresld.dll
.\80\Tools\Binn\sqlslic.cpl
.\80\Tools\Binn\sqlsui.dll
.\80\Tools\Binn\sqlsun.dll
.\80\Tools\Binn\sqlsvc.dll
.\80\Tools\Binn\sqlvdir.dll
.\80\Tools\Binn\stardds.dll
.\80\Tools\Binn\svrnetcn.dll
.\80\Tools\Binn\svrnetcn.exe
.\80\Tools\Binn\uncol.exe
.\80\Tools\Binn\w95scm.dll
.\80\Tools\Binn\wiztrace.exe
.\80\Tools\Binn\Resources\1033
.\80\Tools\Binn\Resources\1033\autoplt.rll
.\80\Tools\Binn\Resources\1033\autowiz.rll
.\80\Tools\Binn\Resources\1033\axscphst.rll
.\80\Tools\Binn\Resources\1033\bcp.rll
.\80\Tools\Binn\Resources\1033\cdw.rll
.\80\Tools\Binn\Resources\1033\cdwtasks.rll
.\80\Tools\Binn\Resources\1033\cdwtskui.rll
.\80\Tools\Binn\Resources\1033\ctasksui.rll
.\80\Tools\Binn\Resources\1033\custtask.rll
.\80\Tools\Binn\Resources\1033\dtsffile.rll
.\80\Tools\Binn\Resources\1033\dtspkg.rll
.\80\Tools\Binn\Resources\1033\dtspump.rll
.\80\Tools\Binn\Resources\1033\dtsrun.rll
.\80\Tools\Binn\Resources\1033\dtsrunui.rll
.\80\Tools\Binn\Resources\1033\dtsui.rll
.\80\Tools\Binn\Resources\1033\dtswiz.rll
.\80\Tools\Binn\Resources\1033\isqlw.rll
.\80\Tools\Binn\Resources\1033\itwiz.rll
.\80\Tools\Binn\Resources\1033\objmgr.rll
.\80\Tools\Binn\Resources\1033\pfclnt80.rll
.\80\Tools\Binn\Resources\1033\pfutil80.rll
.\80\Tools\Binn\Resources\1033\profiler.rll
.\80\Tools\Binn\Resources\1033\rebuildm.rll
.\80\Tools\Binn\Resources\1033\semcomn.rll
.\80\Tools\Binn\Resources\1033\semcros.rll
.\80\Tools\Binn\Resources\1033\semdll.rll
.\80\Tools\Binn\Resources\1033\semdts.rll
.\80\Tools\Binn\Resources\1033\semexec.rll
.\80\Tools\Binn\Resources\1033\semmap.rll
.\80\Tools\Binn\Resources\1033\semnt.rll
.\80\Tools\Binn\Resources\1033\semobj.rll
.\80\Tools\Binn\Resources\1033\semrepl.rll
.\80\Tools\Binn\Resources\1033\semsfc.rll
.\80\Tools\Binn\Resources\1033\semsys.rll
.\80\Tools\Binn\Resources\1033\semwebwz.rll
.\80\Tools\Binn\Resources\1033\semwiz.rll
.\80\Tools\Binn\Resources\1033\sqladevn.rll
.\80\Tools\Binn\Resources\1033\sqldmo.rll
.\80\Tools\Binn\Resources\1033\sqlftwiz.rll
.\80\Tools\Binn\Resources\1033\sqlgui.rll
.\80\Tools\Binn\Resources\1033\sqlmangr.rll
.\80\Tools\Binn\Resources\1033\sqlmmc.rll
.\80\Tools\Binn\Resources\1033\sqlns.rll
.\80\Tools\Binn\Resources\1033\sqlqry.rll
.\80\Tools\Binn\Resources\1033\sqlsui.rll
.\80\Tools\Binn\Resources\1033\sqlsvc.rll
.\80\Tools\Binn\Resources\1033\sqlvdir.rll
.\80\Tools\Binn\Resources\1033\svrnetcn.rll
.\80\Tools\Binn\Resources\1033\wiztrace.rll
.\80\Tools\Books\acdata.chi
.\80\Tools\Books\acdata.chm
.\80\Tools\Books\adminsql.chi
.\80\Tools\Books\adminsql.chm
.\80\Tools\Books\adosql.chi
.\80\Tools\Books\adosql.chm
.\80\Tools\Books\architec.chi
.\80\Tools\Books\architec.chm
.\80\Tools\Books\bldgapps.chi
.\80\Tools\Books\bldgapps.chm
.\80\Tools\Books\coprompt.chi
.\80\Tools\Books\coprompt.chm
.\80\Tools\Books\createdb.chi
.\80\Tools\Books\createdb.chm
.\80\Tools\Books\createdw.chi
.\80\Tools\Books\createdw.chm
.\80\Tools\Books\dblibc.chi
.\80\Tools\Books\dblibc.chm
.\80\Tools\Books\dbmigwiz.chi
.\80\Tools\Books\dbmigwiz.chm
.\80\Tools\Books\dbmntwiz.chi
.\80\Tools\Books\dbmntwiz.chm
.\80\Tools\Books\distsql.chi
.\80\Tools\Books\distsql.chm
.\80\Tools\Books\dtsdsgnr.chi
.\80\Tools\Books\dtsdsgnr.chm
.\80\Tools\Books\dtsprog.chi
.\80\Tools\Books\dtsprog.chm
.\80\Tools\Books\dtsrunui.chi
.\80\Tools\Books\dtsrunui.chm
.\80\Tools\Books\dtssql.chi
.\80\Tools\Books\dtssql.chm
.\80\Tools\Books\dtswizrd.chi
.\80\Tools\Books\dtswizrd.chm
.\80\Tools\Books\entrmgr.chi
.\80\Tools\Books\entrmgr.chm
.\80\Tools\Books\eqbol.chi
.\80\Tools\Books\eqbol.chm
.\80\Tools\Books\esqlforc.chi
.\80\Tools\Books\esqlforc.chm
.\80\Tools\Books\fulltxt.chi
.\80\Tools\Books\fulltxt.chm
.\80\Tools\Books\glossary.chi
.\80\Tools\Books\glossary.chm
.\80\Tools\Books\hlpview.chi
.\80\Tools\Books\hlpview.chm
.\80\Tools\Books\howtosql.chi
.\80\Tools\Books\howtosql.chm
.\80\Tools\Books\iisadmin.chi
.\80\Tools\Books\iisadmin.chm
.\80\Tools\Books\indextun.chi
.\80\Tools\Books\indextun.chm
.\80\Tools\Books\instsql.chi
.\80\Tools\Books\instsql.chm
.\80\Tools\Books\mdacxml.chi
.\80\Tools\Books\mdacxml.chm
.\80\Tools\Books\netconf.chi
.\80\Tools\Books\netconf.chm
.\80\Tools\Books\odbcsql.chi
.\80\Tools\Books\odbcsql.chm
.\80\Tools\Books\odssql.chi
.\80\Tools\Books\odssql.chm
.\80\Tools\Books\olapdmad.chi
.\80\Tools\Books\olapdmad.chm
.\80\Tools\Books\olapdmpr.chi
.\80\Tools\Books\olapdmpr.chm
.\80\Tools\Books\oledbsql.chi
.\80\Tools\Books\oledbsql.chm
.\80\Tools\Books\optimsql.chi
.\80\Tools\Books\optimsql.chm
.\80\Tools\Books\profiler.chi
.\80\Tools\Books\profiler.chm
.\80\Tools\Books\qryanlzr.chi
.\80\Tools\Books\qryanlzr.chm
.\80\Tools\Books\rebldmst.chi
.\80\Tools\Books\rebldmst.chm
.\80\Tools\Books\repconf.chi
.\80\Tools\Books\repconf.chm
.\80\Tools\Books\replprog.chi
.\80\Tools\Books\replprog.chm
.\80\Tools\Books\replsql.chi
.\80\Tools\Books\replsql.chm
.\80\Tools\Books\reposad.chi
.\80\Tools\Books\reposad.chm
.\80\Tools\Books\repospr.chi
.\80\Tools\Books\repospr.chm
.\80\Tools\Books\repsync.chi
.\80\Tools\Books\repsync.chm
.\80\Tools\Books\repwizrd.chi
.\80\Tools\Books\repwizrd.chm
.\80\Tools\Books\samples.chi
.\80\Tools\Books\samples.chm
.\80\Tools\Books\setupsql.chm
.\80\Tools\Books\sql80.chs
.\80\Tools\Books\SQL80.chw
.\80\Tools\Books\sql80.col
.\80\Tools\Books\sqldmo.chi
.\80\Tools\Books\sqldmo.chm
.\80\Tools\Books\sqlns.chi
.\80\Tools\Books\sqlns.chm
.\80\Tools\Books\startsql.chi
.\80\Tools\Books\startsql.chm
.\80\Tools\Books\trblsql.chi
.\80\Tools\Books\trblsql.chm
.\80\Tools\Books\tsqlref.chi
.\80\Tools\Books\tsqlref.chm
.\80\Tools\Books\uiref.chi
.\80\Tools\Books\uiref.chm
.\80\Tools\Books\usetools.chi
.\80\Tools\Books\usetools.chm
.\80\Tools\Books\vdtsql.chi
.\80\Tools\Books\vdtsql.chm
.\80\Tools\Books\whatsnew.chi
.\80\Tools\Books\whatsnew.chm
.\80\Tools\Books\xmlref.chi
.\80\Tools\Books\xmlref.chm
.\80\Tools\Books\xmlsql.chi
.\80\Tools\Books\xmlsql.chm
.\80\Tools\DevTools\Include
.\80\Tools\DevTools\Lib
.\80\Tools\DevTools\Include\wn95scm.h
.\80\Tools\DevTools\Lib\w95scm.lib
.\80\Tools\HTML\alrtfdbk.htm
.\80\Tools\HTML\blutop.gif
.\80\Tools\HTML\clustindex.gif
.\80\Tools\HTML\database.css
.\80\Tools\HTML\database.htm
.\80\Tools\HTML\dbback.gif
.\80\Tools\HTML\dbcindex.gif
.\80\Tools\HTML\dbgeneral.html
.\80\Tools\HTML\dbicon.gif
.\80\Tools\HTML\dbindex.gif
.\80\Tools\HTML\dbsymb01.gif
.\80\Tools\HTML\dbsymb02.gif
.\80\Tools\HTML\dbsymb03.gif
.\80\Tools\HTML\dbtable.gif
.\80\Tools\HTML\first.gif
.\80\Tools\HTML\frontcap.gif
.\80\Tools\HTML\go1.gif
.\80\Tools\HTML\go2.gif
.\80\Tools\HTML\godown1.gif
.\80\Tools\HTML\godown2.gif
.\80\Tools\HTML\godownmiddle.gif
.\80\Tools\HTML\gomiddle.gif
.\80\Tools\HTML\grayspace.gif
.\80\Tools\HTML\img00007.gif
.\80\Tools\HTML\img00008.gif
.\80\Tools\HTML\index.gif
.\80\Tools\HTML\js00001.js
.\80\Tools\HTML\js00002.js
.\80\Tools\HTML\js00003.js
.\80\Tools\HTML\jsconst.js
.\80\Tools\HTML\jsmainmenu.js
.\80\Tools\HTML\last.gif
.\80\Tools\HTML\legend.html
.\80\Tools\HTML\ltbtncap.gif
.\80\Tools\HTML\menubottom.gif
.\80\Tools\HTML\menumiddle.gif
.\80\Tools\HTML\menutop.gif
.\80\Tools\HTML\next.gif
.\80\Tools\HTML\panly01.gif
.\80\Tools\HTML\panly02.gif
.\80\Tools\HTML\panly03.gif
.\80\Tools\HTML\previous.gif
.\80\Tools\HTML\redspace.gif
.\80\Tools\HTML\rtbtncap.gif
.\80\Tools\HTML\server.html
.\80\Tools\HTML\servernodeframe.htm
.\80\Tools\HTML\serversymb01.gif
.\80\Tools\HTML\serversymb02.gif
.\80\Tools\HTML\serversymb03.gif
.\80\Tools\HTML\servertabs.htm
.\80\Tools\HTML\sqlhtml.css
.\80\Tools\HTML\sqlmenus.js
.\80\Tools\HTML\sspat.htm
.\80\Tools\HTML\sspat0.htm
.\80\Tools\HTML\sstabs.htm
.\80\Tools\HTML\table.gif
.\80\Tools\HTML\tablego.gif
.\80\Tools\HTML\tableindexframe.html
.\80\Tools\HTML\tablesindex.html
.\80\Tools\HTML\tabs.html
.\80\Tools\HTML\whitecap.gif
.\80\Tools\HTML\wizardbullet.gif
.\80\Tools\HTML\wizards.html
.\80\Tools\HTML\wizbuttbottom.gif
.\80\Tools\HTML\wizbuttmiddle.gif
.\80\Tools\HTML\wizbutttop.gif
.\80\Tools\HTML\wttop.gif
.\80\Tools\Install\setup.iss
.\80\Tools\Scripts\sp_mshasdbaccess65.sql
.\80\Tools\Scripts\sp_mshasdbaccess70.sql
.\80\Tools\Scripts\sp_mshasdbaccess80.sql
.\80\Tools\Scripts\sp_msobjsearch70.sql
.\80\Tools\Scripts\sp_msobjsearch80.sql
.\80\Tools\Templates\DTS
.\80\Tools\Templates\SQL Profiler
.\80\Tools\Templates\SQL Query Analyzer
.\80\Tools\Templates\DTS\Template Demo.dtt
.\80\Tools\Templates\SQL Profiler\SQLProfilerSP_Counts.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerStandard.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTSQL.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTSQL_Duration.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTSQL_Grouped.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTSQL_Replay.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTSQL_SPs.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTuning.tdf
.\80\Tools\Templates\SQL Query Analyzer\Attach and Detach Database
.\80\Tools\Templates\SQL Query Analyzer\Create Database
.\80\Tools\Templates\SQL Query Analyzer\Create Function
.\80\Tools\Templates\SQL Query Analyzer\Create Index
.\80\Tools\Templates\SQL Query Analyzer\Create Procedure
.\80\Tools\Templates\SQL Query Analyzer\Create Statistics
.\80\Tools\Templates\SQL Query Analyzer\Create Table
.\80\Tools\Templates\SQL Query Analyzer\Create Trigger
.\80\Tools\Templates\SQL Query Analyzer\Create View
.\80\Tools\Templates\SQL Query Analyzer\Manage Extended Property
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User
.\80\Tools\Templates\SQL Query Analyzer\Using Cursor
.\80\Tools\Templates\SQL Query Analyzer\Attach and Detach
Database\Attach_Database_Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Attach and Detach
Database\Attach_Single_File_Database_Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Attach and Detach
Database\Detach_Database_Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Database\Create Database
Basic Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Database\Create Database
for ATTACH.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Database\Create Database
on Mulitple File Groups.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Database\Create Database
on Multiple Data and Transaction Log Files.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Database\Create Database
Specifying Collation.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Function\Create Inline
Function.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Function\Create Scalar
Function.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Function\Create Table
Function.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Index\Create Index
Basic.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Index\Create Index Full
Syntax.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Procedure\Create
Procedure Basic Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Procedure\Create
Procedure with CURSOR OUTPUT Parameter.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Procedure\Create
Procedure with OUTPUT Parameter.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Statistics\Create
Statistics Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table Basic
Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table
Specifying Constrains.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table
Specifying File Groups.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table with
Computed Column.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table with
IDENTITY Column.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table with
ROWGUIDCOL Column.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Temp
Table.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Trigger\Create INSTEAD
OF Trigger Basic Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Trigger\Create Trigger
Basic Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Trigger\Create Trigger
Contained IF COLUMNS_UPDATED.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Trigger\Create Trigger
Contained IF UPDATE.tql
.\80\Tools\Templates\SQL Query Analyzer\Create View\Create View Basic
Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create View\Create View with
CHECK OPTION.tql
.\80\Tools\Templates\SQL Query Analyzer\Create View\Create View with
SCHEMABINDING.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Extended Property\Add
Extended Property.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Extended Property\Drop
Extended Property.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Extended Property\List
Extented Property.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Extended Property\Update
Extended Property.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Add Linked
Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Add
non-Sql Server as Linked Server.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Add Sql
Server as Linked Server.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Configure
Linked Server.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Drop
Linked Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Drop
Linked Server.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Add
Login to Server Role.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Add Sql
Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Add User
to Database Role.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Deny Sql
Server Access to Windows User or Group.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Drop
Login from Server Role.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Drop Sql
Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Drop
User from Database Role.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Grant
Database Access to Windows User or Sql Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Grant
Sql Server Access to Windows User or Group.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Revoke
Database Access From Windows User or Sql Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Revoke
Sql Server Access from Windows User or Group.tql
.\80\Tools\Templates\SQL Query Analyzer\Using Cursor\Declare and Use
KEYSET Cursor.tql
.\80\Tools\Templates\SQL Query Analyzer\Using Cursor\Declare and Use
READ_ONLY Cursor.tql
.\80\Tools\Templates\SQL Query Analyzer\Using Cursor\Declare and Use
SCROLL Cursor with Various FETCH Options.tql
.\80\Tools\Templates\SQL Query Analyzer\Using Cursor\Declare and Use
UPDATE Cursor.tql|||Hi Liam
The files listed are not a full install, on the other drives you will have
copies of sqlserve.exe! As your Database engine is already on SP4 I am not
sure if your original question is an issue? The problem may occur if you have
two live instances running on the same server, failing over so you are only
upgrading the one live on that server would (hopefully) avoid this.
Installing AS SP 4 requires you to failover to the given node before the
upgrade see http://tinyurl.com/ycsjxc
John
"liam.caffrey@.gmail.com" wrote:
> Yes, you are right... SP4 and yes, that hotfix is important especially
> after we ordered extra RAM for the machine to bring it up to 8GB!!
> SS2000 SP4 simplifies the whole thing... the question now is can the
> installation of AS2000 affect in any way the installed SS2000 SP4 files
> that reside outside of the virtual servers , i.e. on the C:\ with the
> OS. I attach the directory listing?
> (BTW, I am assuming that any SS2000 files inside the virtual servers
> will not be affected. Is this correct? )
> >From this posting it looks like the answer might be yes... this person
> had a problem installing SP4 on a multi-instance 2003 server...
> http://groups.google.ie/group/microsoft.public.sqlserver.setup/browse_frm/thread/cc58d69e4ad1524/98ec03c19d001c99?lnk=st&q=msxmlsql.dll+-failed&rnum=4&hl=en#98ec03c19d001c99
> It wouldn't let him write to a shared file that is listed below
> (msxmlsql.rll) during the application of SP4 while the second instance
> was running. What was it trying to write? Would the same happen with
> AS2000 install or the hotfix? This is precisely what I am trying to
> figure out. What is the impact of whatever is written?
> This is the current directory for the listing:
> C:\Program Files\Microsoft SQL Server
> Do anything here stand out? (We don't use replication or log shipping -
> just backup log/copy/restore jobs)
> Thanks for your help...
> Liam
> ..\80
> ..\80\COM
> ..\80\Shared
> ..\80\Tools
> ..\80\COM\1033
> ..\80\COM\distrib.exe
> ..\80\COM\dw15.exe
> ..\80\COM\impprov.dll
> ..\80\COM\logread.exe
> ..\80\COM\mergetxt.dll
> ..\80\COM\msgprox.dll
> ..\80\COM\Other
> ..\80\COM\qrdrsvc.exe
> ..\80\COM\rdistcom.dll
> ..\80\COM\replagnt.dll
> ..\80\COM\repldist.dll
> ..\80\COM\repldp.dll
> ..\80\COM\repldsui.dll
> ..\80\COM\repldts.dll
> ..\80\COM\replerrx.dll
> ..\80\COM\replmerg.exe
> ..\80\COM\replprov.dll
> ..\80\COM\replprox.dll
> ..\80\COM\replrec.dll
> ..\80\COM\replsub.dll
> ..\80\COM\replsync.dll
> ..\80\COM\Resources
> ..\80\COM\rinitcom.dll
> ..\80\COM\snapshot.exe
> ..\80\COM\spresolv.dll
> ..\80\COM\sqldistx.dll
> ..\80\COM\sqldumper.exe
> ..\80\COM\sqlfth75.dll
> ..\80\COM\sqlinitx.dll
> ..\80\COM\sqlmergx.dll
> ..\80\COM\sqlresld.dll
> ..\80\COM\sqlvdi.dll
> ..\80\COM\ssradd.dll
> ..\80\COM\ssravg.dll
> ..\80\COM\ssrdown.dll
> ..\80\COM\ssrmax.dll
> ..\80\COM\ssrmin.dll
> ..\80\COM\ssrpub.dll
> ..\80\COM\ssrup.dll
> ..\80\COM\1033\dwintl.dll
> ..\80\COM\Other\dwintl.dll
> ..\80\COM\Resources\1033
> ..\80\COM\Resources\1033\replres.rll
> ..\80\Shared\msxmlsql.dll
> ..\80\Shared\Resources
> ..\80\Shared\Resources\1033
> ..\80\Shared\Resources\1033\msxmlsql.rll
> ..\80\Tools\Binn
> ..\80\Tools\Books
> ..\80\Tools\DevTools
> ..\80\Tools\HTML
> ..\80\Tools\Install
> ..\80\Tools\Scripts
> ..\80\Tools\sqlsun.dll
> ..\80\Tools\sqlsunin.ini
> ..\80\Tools\Templates
> ..\80\Tools\Uninst.isu
> ..\80\Tools\Binn\autoplt.dll
> ..\80\Tools\Binn\autowiz.dll
> ..\80\Tools\Binn\axscphst.dll
> ..\80\Tools\Binn\bcp.exe
> ..\80\Tools\Binn\cdw.exe
> ..\80\Tools\Binn\cdwtasks.dll
> ..\80\Tools\Binn\cdwtskui.dll
> ..\80\Tools\Binn\cnfgsvr.exe
> ..\80\Tools\Binn\cnfgsvr.ini
> ..\80\Tools\Binn\colctrl.dll
> ..\80\Tools\Binn\comnevnt.dll
> ..\80\Tools\Binn\ctasksui.dll
> ..\80\Tools\Binn\custtask.dll
> ..\80\Tools\Binn\dcomscm.exe
> ..\80\Tools\Binn\dtsffile.dll
> ..\80\Tools\Binn\dtspkg.dll
> ..\80\Tools\Binn\dtspump.dll
> ..\80\Tools\Binn\dtsrun.exe
> ..\80\Tools\Binn\dtsrunui.exe
> ..\80\Tools\Binn\dtsui.dll
> ..\80\Tools\Binn\dtswiz.dll
> ..\80\Tools\Binn\dtswiz.exe
> ..\80\Tools\Binn\hhsetup.dll
> ..\80\Tools\Binn\isql.exe
> ..\80\Tools\Binn\isqlw.exe
> ..\80\Tools\Binn\itwiz.exe
> ..\80\Tools\Binn\objmgr.dll
> ..\80\Tools\Binn\objmgr80.xml
> ..\80\Tools\Binn\odbccmpt.exe
> ..\80\Tools\Binn\osql.exe
> ..\80\Tools\Binn\pfclnt80.dll
> ..\80\Tools\Binn\pfutil80.dll
> ..\80\Tools\Binn\profiler.exe
> ..\80\Tools\Binn\psdcscm.dll
> ..\80\Tools\Binn\rebuildm.exe
> ..\80\Tools\Binn\replmon.pmc
> ..\80\Tools\Binn\Resources
> ..\80\Tools\Binn\scm.exe
> ..\80\Tools\Binn\sdiclnt.dll
> ..\80\Tools\Binn\semcomn.dll
> ..\80\Tools\Binn\semcros.dll
> ..\80\Tools\Binn\semdll.dll
> ..\80\Tools\Binn\semdts.dll
> ..\80\Tools\Binn\semexec.dll
> ..\80\Tools\Binn\semmap.dll
> ..\80\Tools\Binn\semnt.dll
> ..\80\Tools\Binn\semobj.dll
> ..\80\Tools\Binn\semrepl.dll
> ..\80\Tools\Binn\semsfc.dll
> ..\80\Tools\Binn\semsys.dll
> ..\80\Tools\Binn\semwebwz.dll
> ..\80\Tools\Binn\semwiz.dll
> ..\80\Tools\Binn\sqdedev.dll
> ..\80\Tools\Binn\sql iis admin.msc
> ..\80\Tools\Binn\SQL Server Enterprise Manager.MSC
> ..\80\Tools\Binn\sqladhlp.exe
> ..\80\Tools\Binn\sqlbrows.cnt
> ..\80\Tools\Binn\sqlbrows.hlp
> ..\80\Tools\Binn\sqldmo.dll
> ..\80\Tools\Binn\sqldmo80.cnt
> ..\80\Tools\Binn\sqldmo80.hlp
> ..\80\Tools\Binn\sqldts80.cnt
> ..\80\Tools\Binn\sqldts80.hlp
> ..\80\Tools\Binn\sqlftwiz.dll
> ..\80\Tools\Binn\sqlftwiz.exe
> ..\80\Tools\Binn\sqlgui.dll
> ..\80\Tools\Binn\sqllex.dll
> ..\80\Tools\Binn\sqlmangr.exe
> ..\80\Tools\Binn\sqlmmc.dll
> ..\80\Tools\Binn\sqlmmcem.chm
> ..\80\Tools\Binn\sqlmmcii.chm
> ..\80\Tools\Binn\sqlns.dll
> ..\80\Tools\Binn\sqlns80.cnt
> ..\80\Tools\Binn\sqlns80.hlp
> ..\80\Tools\Binn\sqlqry.dll
> ..\80\Tools\Binn\sqlresld.dll
> ..\80\Tools\Binn\sqlslic.cpl
> ..\80\Tools\Binn\sqlsui.dll
> ..\80\Tools\Binn\sqlsun.dll
> ..\80\Tools\Binn\sqlsvc.dll
> ..\80\Tools\Binn\sqlvdir.dll
> ..\80\Tools\Binn\stardds.dll
> ..\80\Tools\Binn\svrnetcn.dll
> ..\80\Tools\Binn\svrnetcn.exe
> ..\80\Tools\Binn\uncol.exe
> ..\80\Tools\Binn\w95scm.dll
> ..\80\Tools\Binn\wiztrace.exe
> ..\80\Tools\Binn\Resources\1033
> ..\80\Tools\Binn\Resources\1033\autoplt.rll
> ..\80\Tools\Binn\Resources\1033\autowiz.rll
> ..\80\Tools\Binn\Resources\1033\axscphst.rll
> ..\80\Tools\Binn\Resources\1033\bcp.rll
> ..\80\Tools\Binn\Resources\1033\cdw.rll
> ..\80\Tools\Binn\Resources\1033\cdwtasks.rll
> ..\80\Tools\Binn\Resources\1033\cdwtskui.rll
> ..\80\Tools\Binn\Resources\1033\ctasksui.rll
> ..\80\Tools\Binn\Resources\1033\custtask.rll
> ..\80\Tools\Binn\Resources\1033\dtsffile.rll
> ..\80\Tools\Binn\Resources\1033\dtspkg.rll
> ..\80\Tools\Binn\Resources\1033\dtspump.rll
> ..\80\Tools\Binn\Resources\1033\dtsrun.rll
> ..\80\Tools\Binn\Resources\1033\dtsrunui.rll
> ..\80\Tools\Binn\Resources\1033\dtsui.rll
> ..\80\Tools\Binn\Resources\1033\dtswiz.rll
> ..\80\Tools\Binn\Resources\1033\isqlw.rll
> ..\80\Tools\Binn\Resources\1033\itwiz.rll
> ..\80\Tools\Binn\Resources\1033\objmgr.rll
> ..\80\Tools\Binn\Resources\1033\pfclnt80.rll
> ..\80\Tools\Binn\Resources\1033\pfutil80.rll
> ..\80\Tools\Binn\Resources\1033\profiler.rll
> ..\80\Tools\Binn\Resources\1033\rebuildm.rll
> ..\80\Tools\Binn\Resources\1033\semcomn.rll
> ..\80\Tools\Binn\Resources\1033\semcros.rll
> ..\80\Tools\Binn\Resources\1033\semdll.rll
> ..\80\Tools\Binn\Resources\1033\semdts.rll
> ..\80\Tools\Binn\Resources\1033\semexec.rll
> ..\80\Tools\Binn\Resources\1033\semmap.rll
> ..\80\Tools\Binn\Resources\1033\semnt.rll
> ..\80\Tools\Binn\Resources\1033\semobj.rll
> ..\80\Tools\Binn\Resources\1033\semrepl.rll
> ..\80\Tools\Binn\Resources\1033\semsfc.rll
> ..\80\Tools\Binn\Resources\1033\semsys.rll
> ..\80\Tools\Binn\Resources\1033\semwebwz.rll
> ..\80\Tools\Binn\Resources\1033\semwiz.rll
> ..\80\Tools\Binn\Resources\1033\sqladevn.rll
> ..\80\Tools\Binn\Resources\1033\sqldmo.rll
> ..\80\Tools\Binn\Resources\1033\sqlftwiz.rll
> ..\80\Tools\Binn\Resources\1033\sqlgui.rll
> ..\80\Tools\Binn\Resources\1033\sqlmangr.rll
> ..\80\Tools\Binn\Resources\1033\sqlmmc.rll
> ..\80\Tools\Binn\Resources\1033\sqlns.rll
> ..\80\Tools\Binn\Resources\1033\sqlqry.rll
> ..\80\Tools\Binn\Resources\1033\sqlsui.rll
> ..\80\Tools\Binn\Resources\1033\sqlsvc.rll
> ..\80\Tools\Binn\Resources\1033\sqlvdir.rll
> ..\80\Tools\Binn\Resources\1033\svrnetcn.rll
> ..\80\Tools\Binn\Resources\1033\wiztrace.rll
> ..\80\Tools\Books\acdata.chi
> ..\80\Tools\Books\acdata.chm
> ..\80\Tools\Books\adminsql.chi
> ..\80\Tools\Books\adminsql.chm
> ..\80\Tools\Books\adosql.chi
> ..\80\Tools\Books\adosql.chm
> ..\80\Tools\Books\architec.chi
> ..\80\Tools\Books\architec.chm
> ..\80\Tools\Books\bldgapps.chi
> ..\80\Tools\Books\bldgapps.chm
> ..\80\Tools\Books\coprompt.chi
> ..\80\Tools\Books\coprompt.chm
> ..\80\Tools\Books\createdb.chi
> ..\80\Tools\Books\createdb.chm
> ..\80\Tools\Books\createdw.chi
> ..\80\Tools\Books\createdw.chm
> ..\80\Tools\Books\dblibc.chi
> ..\80\Tools\Books\dblibc.chm
> ..\80\Tools\Books\dbmigwiz.chi
> ..\80\Tools\Books\dbmigwiz.chm
> ..\80\Tools\Books\dbmntwiz.chi
> ..\80\Tools\Books\dbmntwiz.chm
> ..\80\Tools\Books\distsql.chi
> ..\80\Tools\Books\distsql.chm
> ..\80\Tools\Books\dtsdsgnr.chi
> ..\80\Tools\Books\dtsdsgnr.chm
> ..\80\Tools\Books\dtsprog.chi
> ..\80\Tools\Books\dtsprog.chm
> ..\80\Tools\Books\dtsrunui.chi
> ..\80\Tools\Books\dtsrunui.chm
> ..\80\Tools\Books\dtssql.chi
> ..\80\Tools\Books\dtssql.chm
> ..\80\Tools\Books\dtswizrd.chi
> ..\80\Tools\Books\dtswizrd.chm
> ..\80\Tools\Books\entrmgr.chi
> ..\80\Tools\Books\entrmgr.chm
> ..\80\Tools\Books\eqbol.chi
> ..\80\Tools\Books\eqbol.chm
> ..\80\Tools\Books\esqlforc.chi
> ..\80\Tools\Books\esqlforc.chm
> ..\80\Tools\Books\fulltxt.chi
> ..\80\Tools\Books\fulltxt.chm
> ..\80\Tools\Books\glossary.chi
> ..\80\Tools\Books\glossary.chm
> ..\80\Tools\Books\hlpview.chi
> ..\80\Tools\Books\hlpview.chm
> ..\80\Tools\Books\howtosql.chi
> ..\80\Tools\Books\howtosql.chm
> ..\80\Tools\Books\iisadmin.chi
> ..\80\Tools\Books\iisadmin.chm
> ..\80\Tools\Books\indextun.chi
> ..\80\Tools\Books\indextun.chm
> ..\80\Tools\Books\instsql.chi
> ..\80\Tools\Books\instsql.chm
> ..\80\Tools\Books\mdacxml.chi
> ..\80\Tools\Books\mdacxml.chm
> ..\80\Tools\Books\netconf.chi
> ..\80\Tools\Books\netconf.chm
> ..\80\Tools\Books\odbcsql.chi
> ..\80\Tools\Books\odbcsql.chm
> ..\80\Tools\Books\odssql.chi
> ..\80\Tools\Books\odssql.chm
> ..\80\Tools\Books\olapdmad.chi
> ..\80\Tools\Books\olapdmad.chm
> ..\80\Tools\Books\olapdmpr.chi
> ..\80\Tools\Books\olapdmpr.chm
> ..\80\Tools\Books\oledbsql.chi
> ..\80\Tools\Books\oledbsql.chm
> ..\80\Tools\Books\optimsql.chi
> ..\80\Tools\Books\optimsql.chm
> ..\80\Tools\Books\profiler.chi|||Hi John,
Yes the full installs are on another drive and are ringfenced by the
virtual server. I am not really worried about them. It is the shared
files listed previously that I am concerned about.
Why should 2 live instances running on the server interfere with each
other when installing service packs or AS or whatever?
Is this related to http://tinyurl.com/y5attu
Why is the upgrade trying to access the file C:\Program Files\Sql
Server\80\Shared\msxmlsql.dll? What is it writing to that file?
Regards
Liam
John Bell wrote:
> Hi Liam
> The files listed are not a full install, on the other drives you will have
> copies of sqlserve.exe! As your Database engine is already on SP4 I am not
> sure if your original question is an issue? The problem may occur if you have
> two live instances running on the same server, failing over so you are only
> upgrading the one live on that server would (hopefully) avoid this.
> Installing AS SP 4 requires you to failover to the given node before the
> upgrade see http://tinyurl.com/ycsjxc
> John
>|||Hi Liam
I don't know the exactly what the file is used for, but it is mostly likely
SQLXML. There are some enhancements to XML in SP4. If you don't use this then
I would think it would not be a problem. According to
http://download.microsoft.com/download/1/b/d/1bdf5b78-584e-4de0-b36f-c44e06b0d2a3/ReadmeSql2k32sp4.htm#_installing_on_a_failover_cluster
you may need to failover to replace in use files.
The posters issue does not seem to be a common problem, but then running
multiple instances on a cluster is probably not that common!
John
"liam.caffrey@.gmail.com" wrote:
> Hi John,
> Yes the full installs are on another drive and are ringfenced by the
> virtual server. I am not really worried about them. It is the shared
> files listed previously that I am concerned about.
> Why should 2 live instances running on the server interfere with each
> other when installing service packs or AS or whatever?
> Is this related to http://tinyurl.com/y5attu
> Why is the upgrade trying to access the file C:\Program Files\Sql
> Server\80\Shared\msxmlsql.dll? What is it writing to that file?
> Regards
> Liam
>
> John Bell wrote:
> > Hi Liam
> >
> > The files listed are not a full install, on the other drives you will have
> > copies of sqlserve.exe! As your Database engine is already on SP4 I am not
> > sure if your original question is an issue? The problem may occur if you have
> > two live instances running on the same server, failing over so you are only
> > upgrading the one live on that server would (hopefully) avoid this.
> >
> > Installing AS SP 4 requires you to failover to the given node before the
> > upgrade see http://tinyurl.com/ycsjxc
> >
> > John
> >
>sql

Wednesday, March 21, 2012

POSTing report parameters

We are having an issue POSTing report parameters to reporting services. One
of our report parameters can be very long (hundreds or even thousands of
characters) and is far to long to pass on a URL. Our solution has been to
POST the parameter, which does work, but not quite as we want it to. We only
need to provide a single parameter to the reprt as all the others have
default values.
The report generates and displays results as expected, however the parameter
selection and report navigation section is not visible on the report that is
rendered.
If we POST the parameters, is it possible to get the parameter selection and
report navigation sections to show? and, if so, how? The report is being
called from a custom app which passes the parameter to the report.
This is how we call our report:
http://sidev/ReportServer?/tbi/development/Report200_GIS
The POST data is:
XMLFarmIDs=<TbI>....</TbI>I've done this in the past by putting a hidden element in the form I'm
posting equivalent to the HTML Viewer command.
In my post form, I'll put this:
<input type=hidden name="rc:Parameters" value="false">
Andy Potter

Posting Multi-Value Parameter

Hi,

I tried Posting the values for a multi value parameter from my application to the reporting services, But the query string is not being hidden. Why is that ? since the the data is sent through the browser address bar, I am not able to send values more than the allowed lenght. Is there any work around ?

Thanks In Advance

Regards

Raja Annamalai S

Hi Raja-

Yes, you will be limited to the URL length restriction. If possible I might suggest using the Web Service to render reports rather than crafting the URL. This will not be limited by URL length.

Otherwise you can perform a POST instead of a GET on the http call. The post will send the parameter values in the body rather than appended to the URL. However, all parameters need to be in the body if you perform a POST.

Thanks, Jon

PostgreSQL Database and Reporting Service?

Hello all -
I have reporting services installed on SQL server 2000 database and have
developed many many great reporrts on it.
However, I have the need now to address datasources from PostgreSQLdatabase
open-source database and I wonder if RS would work with PostgreSQL ODBC and
if the only thing I need is to establish an ODBC connection to the database?
Thanks for the info in advance.
wise -
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1you can always make linked servers to the postgres database; and then
setup some queries as views on the SQL Server side..
then you're doing RS against SQL 2000 which is calling queries on
postgres
-Aaron
wiseteufel via SQLMonster.com wrote:
> Hello all -
> I have reporting services installed on SQL server 2000 database and have
> developed many many great reporrts on it.
> However, I have the need now to address datasources from PostgreSQLdatabase
> open-source database and I wonder if RS would work with PostgreSQL ODBC and
> if the only thing I need is to establish an ODBC connection to the database?
> Thanks for the info in advance.
> wise -
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1|||thanks dbaHooker .. i will try that. will see what drivers postgres has!!
dbahooker@.hotmail.com wrote:
>you can always make linked servers to the postgres database; and then
>setup some queries as views on the SQL Server side..
>then you're doing RS against SQL 2000 which is calling queries on
>postgres
>-Aaron
>> Hello all -
>[quoted text clipped - 12 lines]
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1

Tuesday, March 20, 2012

POST SP3 Problems

Fresh install of Win2K Server with all the latest Services Packs and Patches.

Fresh Install of SQL Servers 2000

Everything works OK

Install SP3

SQL Services Manager runs for 1 second and closes

Running New SQL Server Registration Wizard in Enterprise Manger, after hitting Next on the first screen Enterprise Manager goes poof and closes

DR. Watson Error:

Event Type: Information
Event Source: DrWatson
Event Category: None
Event ID: 4097
Date: 2/14/2003
Time: 8:38:37 AM
User: N/A
Computer: CRUISE03
Description:
The application, mmc.exe, generated an application error The error occurred on 02/14/2003 @. 08:38:37.458 The exception generated was c0000005 at address 780011CD (wcslen)

Has anyone else experienced this error, or know how I can correct it?I have experienced a different error (possibly related)

Windows 2K box
SQL 2K sp2

Add SQL SP3

SQL Server process crashes on any extended stored procedure execution. Some DBCC commands (checkdb but not showcontig) also crash the server process.

I talked to Microsoft about it, and it seems that there is one MDAC hotfix that will report a successful installation no matter what. Out of 4 machines, I only had one go bad, but I still have 30 to go...

The fix in my case was as follows:
1) run C:\SQL2KSP3\x86\other\sqlredis.exe /t:C:\Extract /c

2) run C:\Extract\mdac_qfe.exe
2a) reboot.
3) Re-run SQL SP3 setup

It fixed my particular problem, but I don't know if it will do anything to yours. Can you run extended stored procs in Query Analyzer?
~Matt|||Unfortunately this fix didn't work for me.

I don't having any stored procedures to test, this is a very simple setup for my new web server.

POST Method

We've run into a rather sizable problem here.

When passing querystring values using GET, to our SQL Server Reporting Services Reports, we've discovered that we've exceeded the maximum URL length,.

We are thinking that we need to change how we're passing this data to our reports.

Can we use POST and transfer the data throught hte HTTP header and bypass this limitation?

Thanks.

Doug

Yes you can use a Post method. The following link is an example:

http://blogs.msdn.com/bryanke/articles/73153.aspx

Possibly similar issue with launching Report Builder from client PC's

Hi,

I got a working installation of reporting services 2005 up and running, Im able to create models and launch the Report Builder on the machine on which the server is installed, however if I try and run it from another machine on the network I get an error and Im able to view the following exception.

Following errors were detected during this operation.
* [04 Jul 2005 10:39:34 +01:00] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Failed while downloading http://testserver/ReportServer/ReportBuilder/ReportBuilder.application
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifest(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ManifestType manifestType, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirect(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifest(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

Anyone able to help ?The error means that the client does not have the Whidbey CLR installed. You will need to install the Whidbey CLR on each client machine where you want to use report builder.

-Lukasz|||Hi,
I was facing similar problem while accessing Report Manager installed on different system on the network, I was able to get Report Manager menu but can not see contents on Report Server. It was displayed Blank without any exception.

Report Server is installed on http://testsrv/Reports$sql2005.

I changed configuration of Reporting Service on Server , Report Server Configuration Manager > Windows Service Identity> Service account from "Local System" to "Local Services".

I can access Report Manager with contents.

Meanwhile I noticed that Report Builder is not launching on the system which is a different system from the Report Server. As per my understanding, Report Builder is a "End user tool" and will be launched without any upgradation of the system (Different system from server). I am getting prompt for "Open/Save document".
Where as Report Builder is working fine on Server itself.

While opening document, I can see XML contents to access Report Builder.
I am pasting part of that XML file in orange colour,

<?xml version="1.0" encoding="utf-8" ?>

- <asmv1:assembly xsi:schemaLocation="urn:schemas-microsoft-com:asm.v1 assembly.adaptive.xsd" manifestVersion="1.0" xmlns:dsig="http://www.w3.org/2000/09/xmldsig#" xmlns="urn:schemas-microsoft-com:asm.v2" xmlns:asmv1="urn:schemas-microsoft-com:asm.v1" xmlns:asmv2="urn:schemas-microsoft-com:asm.v2" xmlns:xrml="urn:mpeg:mpeg21:2003:01-REL-R-NS" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

- <dependency>

- <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="ReportBuilder.exe.manifest" size="7148">

- <hash>

- <dsig:Transforms>

<dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />

</dsig:Transforms>

<dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />

<dsig:DigestValue>aAi7VtRySyyvYXiAs4FuFXSiqLA=</dsig:DigestValue>

</hash>

</dependentAssembly>

Anyone knows how to fix this, It is required to upgrade my system, what are the upgrades require on the system to access Report Builder?

|||Your two issues are unrelated. Specifically for the Report Builder issue - the client machine (the one on which you want to run Report Builder) needs to have The .Net Framework 2.0 (CLR 2.0) installed on it.

The reason is that the Report Builder leverages the ClickOnce technology that is new in the .Net Framework 2.0.

Regarding your other issue - the Report Manager shows the top menu with a blank contents when your login does not have permissions on the root of the report server. You will need a role that has Read Properties (Browser roles has this) assigned to your login on the root of the report server namespace. Changing the account from Local System to Local Service should not affect this.

-Lukasz|||Thanks Lukasz, I have installed .NET Framework 2.0 on Client machine and able to launch Report Builder successfully.

I created a new user with sufficient permission and access to HOME directory on Report Server and able to access Reports/Data Sources/Models using Client Machine.

Thanks again!|||

I have what may be a similar problem. I try to click on the "Report Builder" button from a client machine and nothing happens, however I have tried things mentioned in the suggestions above and it did not seem to help. From a client PC, I logged in as myself and am not able to run "Report Builder", but when I login as a local admin I am able to run "Report Builder".

Our server has SQL Server 2005 Enterprise Edition and Visual Studio 2005 installed. I am able to run "Report Builder" from my PC where I had Visual Studio 2005 installed, but not SQL Server 2005 installed. I have local admin priviledges to my PC.

From a client PC, I logged in as myself and am not able to run "Report Builder". When I click on it nothing happens. I gave my Windows login "Content Manger" permissions under the SSRS Home -> Properties tab, and I also added my login and gave myself "System Administrator" and "System User" Roles under the SSRS ->Site Settings->Configure site-wide security option. This seems to be configured correctly, as "Report Builder" launches when I am on my PC. However, it does not launch on the client PC when logged in under my login.

Further, when I login as a local admin on the client PC, I am able to run "Report Builder", so I think the .net framework 2.0 is correctly installed and working properly. However, it is our policy not to give the user of the client PC local admin rights. My windows login does not have local admin rights to this particular PC.

Q1. Is local admin rights required on the client PC where "Report Builder" is ran? If so, is it only required for the first time it is loaded? It seems like it should not be required, however this would explain the symptoms detailed above.

Q2. Is there an error log that may help debug what this problem is? It is strange to me, that nothing happens, but no error is displayed on the http://.../reportserver/Pages page

Q3. When logged in as local admin, report builder installed to something like:

C:\Documents and Settings\Administrator.8ZR5551\Local Settings\Apps\2.0\VVJ0004J.B0N\H3KE16BP.Y07\repo..lder_89845dcd8080cc91_0009.0000_none_7ecce75e919dcccd

I am not sure if I can copy this install to another directory which the client has permission to run from. Is this a valid thing to do? I am guessing probably not since I tried this and it did not seem to work.I tried this and it did not seem to work..

Q4. I saw this posting talking about the need to run under PartialTrust mode, instead of FullTrust mode. So I reconfigured the RSWebApplication.config file to do that, and it still does not work.:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=280387&SiteID=1 which refers to the following link.

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

I changed the C:\Program Files\MSSQL2005\MSSQL.3\Reporting Services\ReportManager\ RSWebApplication.config

From

<Configuration><UI> …

<ReportBuilderTrustLevel> FullTrust </ReportBuilderTrustLevel>

</UI>…</Configuration>

<Configuration><UI> …

<ReportBuilderTrustLevel>PartialTrust</ReportBuilderTrustLevel>

</UI>…</Configuration>

Stopped and restarted report server through reporting services configuration (not sure if I needed to do this) The problem still occurred, however.

|||

Well scratch that idea on local admin rights. Our IT department gave login admin to my windows login (My computer->Manage->System Tools: Local Users and Groups->Administrators) and it still did not work. When I click on "Report Builder" it still does not do anything. I also tried to use it directly at the following URL's and it still did not work, same result of not displaying anything:

http://.../reportserver/ReportBuilder/ReportBuilder.application

http://.../reportserver/ReportBuilder/ReportBuilderLocalIntranet.application

Q5. Is there any Internet Explorer settings that would cause this behavior? I tried disabling popup blocker, but this did not seem to help.

Q6. In the above posting, giving permission on the server HOME directory was required. What directory does this refer to? Does this mean each user of Report Builder needs Windows Directory level security to some directories like C:\Program Files\MSSQL2005\MSSQL.3\Reporting Services\ReportManager\ or others? This does not seem to make sense, but I was unsure which HOME directory was mentioned in the previous posting by Nilesh Trivedi.
.

|||Well this is almost a year old but I am facing the exact same problem as Chad Buher. Clicking on the Report Builder button does nothing, no error, nothing. Can this be caused by some network policy setting?

Monday, March 12, 2012

Possibly similar issue with launching Report Builder from client PC's

Hi,

Anyone able to help ?The error means that the client does not have the Whidbey CLR installed. You will need to install the Whidbey CLR on each client machine where you want to use report builder.

Report Server is installed on http://testsrv/Reports$sql2005.

I changed configuration of Reporting Service on Server , Report Server Configuration Manager > Windows Service Identity> Service account from "Local System" to "Local Services".

I can access Report Manager with contents.

While opening document, I can see XML contents to access Report Builder.
I am pasting part of that XML file in orange colour,

<?xml version="1.0" encoding="utf-8" ?>

- <dependency>

- <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="ReportBuilder.exe.manifest" size="7148">

- <hash>

- <dsig:Transforms>

<dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />

</dsig:Transforms>

<dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />

<dsig:DigestValue>aAi7VtRySyyvYXiAs4FuFXSiqLA=</dsig:DigestValue>

</hash>

</dependentAssembly>

Anyone knows how to fix this, It is required to upgrade my system, what are the upgrades require on the system to access Report Builder?

The reason is that the Report Builder leverages the ClickOnce technology that is new in the .Net Framework 2.0.

-Lukasz|||Thanks Lukasz, I have installed .NET Framework 2.0 on Client machine and able to launch Report Builder successfully.

I created a new user with sufficient permission and access to HOME directory on Report Server and able to access Reports/Data Sources/Models using Client Machine.

Thanks again!|||

Q2. Is there an error log that may help debug what this problem is? It is strange to me, that nothing happens, but no error is displayed on the http://.../reportserver/Pages page

Q3. When logged in as local admin, report builder installed to something like:

C:\Documents and Settings\Administrator.8ZR5551\Local Settings\Apps\2.0\VVJ0004J.B0N\H3KE16BP.Y07\repo..lder_89845dcd8080cc91_0009.0000_none_7ecce75e919dcccd

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=280387&SiteID=1 which refers to the following link.

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

I changed the C:\Program Files\MSSQL2005\MSSQL.3\Reporting Services\ReportManager\ RSWebApplication.config

From

<Configuration><UI> …

<ReportBuilderTrustLevel> FullTrust </ReportBuilderTrustLevel>

</UI>…</Configuration>

<Configuration><UI> …

<ReportBuilderTrustLevel>PartialTrust</ReportBuilderTrustLevel>

</UI>…</Configuration>

Stopped and restarted report server through reporting services configuration (not sure if I needed to do this) The problem still occurred, however.

|||

http://.../reportserver/ReportBuilder/ReportBuilder.application

http://.../reportserver/ReportBuilder/ReportBuilderLocalIntranet.application

Q5. Is there any Internet Explorer settings that would cause this behavior? I tried disabling popup blocker, but this did not seem to help.

Possible to use Reporting Services w/o Sql Server?

This is a very simple question which very probably has an obvious answer.

Is there any way to make use of the rendering facilities that Reporting Services offers without having to install SQL Server? The way that I'm planning to use RS is by supplying an XML Data file and reporting from that. I never plan to report from a database of any kind.

I haven't been able to find any evidence that I will be able to do what I'm asking for, but it seems reasonable that if Microsoft supports XML files as a datasource, that maybe the meta-data and configuration data that RS uses could also be stored in XML files.

Thanks,
Ken

Simple answer: Yes.

Check out this episode of MSDN.TV: http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050616SQLServerBW/manifest.xml|||Daniel --

Thank you for that information. That may very well be the best answer to my problem.

The only thing that could make this situation better is if there were some classes (instead of a windows forms control per se) that I could use to do all of the functions of the report viewer control. I am constructing a COM object which is to take an RDL file, XML file (housing the report data), export format, and destination of export file. The COM object is to then programatically process the report, apply the data to the reprot, export the report to the specified format, and finally dump the file to its final destination. Ultimately I am hoping that I can use a Microsoft class that will process the report and give me a stream of bytes representing the report in the export format of my choosing.

If I could do all of that -- preferably without connecting to Reporting Services or the report viewer controls -- I think that I could craft a very fitting solution.

Thanks,
Ken

Possible to use a Sharepoint List as a Datasource?

In Reporting Services 2005, is it possible to create a data connection to a sharepoint list? If so, what connection type and connection string do i use for this?It is possible using the Xml Data processing extension. Sharepoint exposes a Lists.asmx webservice, which can be queried using the Xml data processing extension.

Connection String:
http://<YourServerName>/sites/sitename/_vti_bin/Lists.asmx

Xml Query:

<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetList</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetList">
</Method>
<ElementPath IgnoreNamspaces="true">GetListResponse{}/GetListResult{}/List/Fields/Field</ElementPath>
</Query>

Dataset Parameter:
Name: listName, Value: The name of the list you want from the site.

Notes:
You may need to play with the ElementPath to get what you need. See this page for more information: http://msdn2.microsoft.com/en-us/library/ms365158.aspx|||

This is good as I have this exact requirement, but get

TITLE: Microsoft Report Designer

An error occurred while executing the query.
Failed to execute web request for the specified URL.

ADDITIONAL INFORMATION:

Failed to execute web request for the specified URL. (Microsoft.ReportingServices.DataExtensions)

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<soap:Fault>
<faultcode>soap:Server</faultcode>
<faultstring>Exception of type Microsoft.SharePoint.SoapServer.SoapServerException was thrown.</faultstring>
<detail>
<errorstring xmlns="http://schemas.microsoft.com/sharepoint/soap/">Value cannot be null.</errorstring>
</detail>
</soap:Fault>
</soap:Body>
</soap:Envelope>

BUTTONS:

Any ideas

|||

I would suggest that you use the informations provided by Teun Duynstee in this link:

http://www.teuntostring.net/blog/2005/09/reporting-over-sharepoint-lists-with.html

Cheers
Markus

|||The error that you are getting for the GetList method is most likely caused by not using the correct name of the list. The listName must be either the title or the GUID for the list.

For more info on this method http://msdn.microsoft.com/library/default.asp?url=/library/en-us/spptsdk/html/soapmListsGetList_SV01034346.asp

|||

Hi,

In case you are interested we are selling a reporting services (both 2000 and 2005 version) data extension for sharepoint.

This extension makes it possible to build report using sharepoint lists (including libraries).

Several lists may be joined using SQL-like operators.

Reports parameters may be used with the query string.

An evaluation version is available on our site at http://www.enesyssoftware.com/Default.aspx?tabid=56

If you prefer to do it by yourself, the article from Teun Duynstee is the way to go.

Frdric LATOUR

http://www.enesyssoftware.com

|||

Hi,

I have the same requirement of getting the data from List in SharePoint 2007. It exposed the method GetList(). I am using the same code which you have mentioned. But is not working.

Reporting Service SP 2 provide XML DataSource

Can you please rectify where i am going wrong. I have a List by name say: Announcements

How to Specify List Name and Where? I am unable to undertand your Dataset Parameter.

Dataset Parameter:
Name: listName, Value: The name of the list you want from the site.

I tried few combinations.

<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetList</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap" Name="GetList">
</Method>
<ElementPath IgnoreNamespaces="True">GetListResponse{}/GetListResult{}/List/Fields/Field</ElementPath>
</Query>

Please help. As this will save me from writing DATA Extensions for my reports integration with sharepoint 2007

|||There are two ways to specify parameters for an Xml Data Processing Extension query.

1. Use the Reporting Services Dataset query parameters collection.

Add a query parameter to the dataset with the name 'listName' and value 'Announcements'.

2. Add the parameters directly to the Xmlk query, using the Parameters Xml element, which is a child of the Method element.

Add the following Xml as the child element to the Method element in the query above.

<Parameters>
<Parameter Name="listName">
<DefaultValue>Announcements</DefaultValue>
</Parameter>
</Parameters>

Ian|||

Hi,

I tried as you said now my query is. Previoisly i was not in sharepoint integration mode. so i was giving another error. Now i am getting the error as "Error While reading XML reponse"

My Data Source is:
http://localhost/Docs/vti_bin/Lists.asmx

My Query is :
<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetList</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap" Name="GetList">
<Parameters>
<Parameter Name="listName" Type="String">
<DefaultValue>Announcements</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath>GetListResponse{}/GetListResult{}/List/Fields/Field</ElementPath>
</Query>

My Web Service is :

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
<soap12:Body>
<GetListResponse xmlns="http://schemas.microsoft.com/sharepoint/soap/">
<GetListResult>
<xsd:schema>schema</xsd:schema>xml</GetListResult>
</GetListResponse>
</soap12:Body>
</soap12:Envelope>

I have tried all combinations. 1) Isn't there any tool where i can construct this query 2) I am not able to view the dataset result in XML, so that i can map it with <ElementPath>. I am not able to test webservice with this "http://localhost/Docs/_vti_bin/Lists.asmx?op=GetList" URL, to view the dataset result.

|||
The exception you see being thrown is usually a wrapped exception that occurs in the call in the request/response phase, most likely a permissions issue. Check the log files for more information about this exception.

Also, regarding the ElementPath:

Try setting the IgnoreNamespaces attribute to true on the ElementPath element:

Answers to your questions:

1. Unfortunately, no, there is no tool at this time.
2. After you set the attribute mentioned above, try making the ElementPath less restrictive and to return the Xml as is. For example, this will return one field containing the raw Xml of the GetListResult element. You can use this to information see what the elements are in the GetListResult.

<ElementPath IgnoreNamespaces="true">GetListResponse{GetListResult(XML)}</ElementPath>

Ian|||

Hi,

This time i tried all below combionations bit its still not working. I have wasted lot of effots on this and this is very important for me to get it solved.

ERROR its Gives in Log is
<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.</faultstring><detail><errorstring xmlns="http://schemas.microsoft.com/sharepoint/soap/">Value cannot be null.</errorstring></detail></soap:Fault></soap:Body></soap:Envelope>

http://localhost/_vti_bin/Lists.asmx

GUID
<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetList</SoapAction>
<Method Name="GetList" Namespace= "http://schemas.microsoft.com/sharepoint/soap">
<Parameters>
<Parameter Name="listName">
<DefaultValue>21CF03AF-3A7E-479C-98E0-CBE0F16A594A</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">GetListResponse{GetListResult(XML)}</ElementPath>
</Query>

WithOut GUID
<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetList</SoapAction>
<Method Name="GetList" Namespace= "http://schemas.microsoft.com/sharepoint/soap">
<Parameters>
<Parameter Name="listName">
<DefaultValue>Contacts</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">GetListResponse{GetListResult(XML)}</ElementPath>
</Query>

GUID
<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetList</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap" Name="GetList">
<Parameters>
<Parameter Name="listName">
<DefaultValue>21CF03AF-3A7E-479C-98E0-CBE0F16A594A</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="True">GetListResponse{}/GetListResult{}/List/Fields/Field</ElementPath>
</Query>

WithOut GUID
<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetList</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap" Name="GetList">
<Parameters>
<Parameter Name="listName">
<DefaultValue>Contacts</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="True">GetListResponse{}/GetListResult{}/List/Fields/Field</ElementPath>
</Query>

Please Help!!!

|||Ok, I tracked down the culprit. The Method element in your tests and the example I provided above differ very slightly. The namespace for the web service ends with a '/', which was mssing from in your query. This caused the method portion of the soap request sent to the server to exist in a different namespace than was expected, which caused it to be interpreted as null.

To reslove this issue, append a '/' to end of the Namespace attribute value in the Method element.

Ian|||

Thanks a lot it worked.

Working Query is

<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetList</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetList">
<Parameters>
<Parameter Name="listName">
<DefaultValue>Announcements</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="True">GetListResponse{}/GetListResult{}/List/Fields/Field</ElementPath>
</Query>

Monday, March 26, 2012

Pre Printed Forms in Reporting Services 2005

Powerpoint-Reporting with SQL2005 Reporting Services

PowerPoint format possible?

Friday, March 23, 2012

Potential conflicts during cluster installs of SS2000 and AS2000

Wednesday, March 21, 2012

POSTing report parameters

Posting Multi-Value Parameter

PostgreSQL Database and Reporting Service?

Tuesday, March 20, 2012

POST SP3 Problems

POST Method

Possibly similar issue with launching Report Builder from client PC's

Monday, March 12, 2012

Possibly similar issue with launching Report Builder from client PC's

Possible to use Reporting Services w/o Sql Server?

Possible to use a Sharepoint List as a Datasource?

PORTS USED

Blog Archive

About Me