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

Hi

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:

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? )

http://groups.google.ie/group/micros...ec03c19d001c99

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 (AT) gmail (DOT) 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

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/downlo...over_clu ster
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 (AT) gmail (DOT) com" wrote: