Re Dist

redistributable components the following files are redistributable: pivottable service ---------------------------------------------file name description ---------------------------------------------msolap80.dll ole db provider for analysis services msolap80.rll analysis services resources msmdcb80.dll pivottable service msmdgd80.dll analysis services driver msolui80.dll analysis services connection dialog olapuir.rll analysis services connection dialog resources msdmine.dll ole db for data mining provider msdmine.rll ole db for data mining resources msdmeng.dll data mining learning algorithm msmdun80.dll sql server unicode/ansi translation layer ptsfull.exe installs pivot table services ptslite.exe installs pivot table services without mdac msolap.dll msolapr.dll msmdcube.dll msmdgdrv.dll msolapui.dll

ole db provider for analysis services (version 7.0) olap services resources (version 7.0) pivottable service (version 7.0) olap services driver (version 7.0) olap services connection dialog (version 7.0)

decision support objects (dso) ---------------------------------------------file name description ---------------------------------------------msmdnet.dll analysis services network interface msmdlock.dll analysis services lock manager msmddo.dll analysis services decision support objects, version 7.0 msmddo80.dll analysis services decision support objects, version 8.0 msmdso.rll analysis services decision support objects resource file, version 8.0 english query ---------------------------------------------file name description ---------------------------------------------mseqole.dll english query server object model mseqbase.dll english query supplemental file mseqsql.dll english query supplemental file mseqmsg.dll english query supplemental file mseqconn.dll english query supplemental file mseqcore.eqd english query supplemental file mseqgrqb.ocx question builder control eqqbhlp.chm question builder help repository ---------------------------------------------file name description

---------------------------------------------dbscan.dll database scanner insrepim.dll information model installer insrepim.exe information model installer msmdcxml.dll mdc xml import/export repbr.dll repository browser repbrui.dll repository browser ui repodbc.dll meta data services repository engine reprc.rll repository engine resource msmdcxml.rll mdc xml import/export resource msrmirc.rll information model installer resource repbrui.rll repository browser ui resource repbrmdc.rll repository browser icon resource db2.rdm model installation script dbm.rdm model installation script dtm.rdm model installation script dts.rdm model installation script eqm.rdm model installation script gen.rdm model installation script ifx.rdm model installation script mds.rdm model installation script ocl.rdm model installation script olp.rdm model installation script sim.rdm model installation script sql.rdm model installation script tfm.rdm model installation script uml.rdm model installation script umx.rdm model installation script replication ---------------------------------------------file name description ---------------------------------------------atl.dll active template libraries rdistcom.dll replication distribution agent interface replerrx.dll replication activex control error handling replprov.dll merge replication provider interface replrec.dll merge replication reconciler interface replres.rll replication resources sqldistx.dll replication distribution activex control sqlmergx.dll replication merge activex control wzcnf.dll replication conflict viewer and interactive resolver wzcnflct.exe replication conflict viewer executable wzcnfrc.rll replication conflict viewer and interactive resolver resources data transformation services (dts) ---------------------------------------------file name description ---------------------------------------------sqlresld.dll satellite resource dll loader dtsffile.dll dts flat file ole db provider dtsffile.rll dts resource file dtspkg.dll dts package dtspkg.rll dts resource file dtspump.dll dts datapump dtspump.rll dts resource file

axscphst.dll axscphst.rll dtsrun.exe dtsrun.rll sqlunirl.dll custtask.dll custtask.rll

dts activex script host dts resource file command line utility to execute a dts package dts resource file sql server unicode/ansi translation layer dts custom tasks file dts custom tasks resource file

distributed management objects (dmo) ---------------------------------------------file name description ---------------------------------------------sqldmo.dll distributed management objects com sqldmo.rll distributed management objects resource file sqlresld.dll sql enterprise manager resource dll loader sqlsvc.dll database service layer sqlsvc.rll database service layer resource dll sqlunirl.dll sql server unicode/ansi translation layer w95scm.dll sql service control manager abstraction layer sql namespace (sqlns) ---------------------------------------------file name description ---------------------------------------------sqlns.dll sql namespace sqlns.rll sql namespace resource file sqlgui.dll sql server gui support sqlgui.rll sql server gui resource file sfc.dll foundation classes sfc.rll foundation classes resource file semcomn.dll common objects semcomn.rll common objects resource file semcros.dll user interface semcros.rll user interface resource file semexec.dll user interface semexec.rll user interface resource file semwiz.dll user interface for wizards semwiz.rll user interface resource file for wizards semsys.dll user interface semsys.rll user interface resource file semobj.dll user interface semobj.rll user interface resource file semrepl.dll user interface semrepl.rll user interface resource file semmap.dll sql enterprise manager mapi support semmap.rll sql enterprise manager mapi support resource file semwebwz.dll sql server web assistant wizard semwebwz.rll sql server web assistant wizard resource file semdll.dll sql enterprise components semdll.rll sql enterprise components resource file semnt.dll sql enterprise components (windows nt specific) semnt.rll sql enterprise components resource file (windows nt specific) sqllex.dll transact-sql color lexer osql

---------------------------------------------file name description ---------------------------------------------osql.exe sql command line query tool db-library ---------------------------------------------file name description ---------------------------------------------ntwdblib.dll db-library dll sqlredis.exe ---------------------------------------------------------------------this package contains the following redistributable components: ---------------------------------------------------------------------jet 4.0 jet ole db 4.0 odbc driver for desktop databases sql server 2000 network libraries sql odbc drivers sql oledb provider sql xml provider microsoft data access components (mdac) version 2.6 distribution terms: microsoft grants you the non-exclusive, royalty-free right to reproduce and distribute the redistributable components provided that: (a) you reproduce and/or distribute the redistributable components only in object code and only in conjunction with and as part of your application that works in conjunction with microsoft sql server ("application"); (b) your application adds significant and primary functionality to the redistributable components; (c) in the application, the redistributable components only operate in conjunction with microsoft sql server and any other microsoft products; (d) if you elect to reproduce and/or distribute the files that are identified above as pivottable service files ("pts files") in your application, you permit the end-users of your application to use such pts files to create data cubes that contain only data extracted from a microsoft sql server, and you enforce such limitation by, at a minimum, including this limitation in the license agreement for your application; (e) you do not use microsoft's name, logo or trademarks to market your application; (f) you include a valid copyright notice on your application; (g) you include all copyright and trademark notices contained in the redistributable components; and (h) you indemnify, hold harmless and defend microsoft from and against any claims or lawsuits, including attorneys' fees, that arise or result from the use or distribution of your application; and (i) you do not permit further redistribution of the redistributable components by your end-user customers. the following exception applies: you may permit further redistribution of the redistributables by your distributors to your end-user customers if your distributors only distribute the redistributable components in conjunction with, and as part of, your application. if your application uses the "jet files" (as defined below) you agree to the following additional requirements: (a) that your application does not substantially duplicate the capabilities of microsoft access or, in the reasonable

opinion of microsoft, compete with same; and (b) unless your application requires your customers to license microsoft access in order to operate, you may not reproduce or use any of the jet files for commercial distribution in conjunction with a general purpose word processing, spreadsheet or database management software product, or an integrated work or product suite whose components include a general purpose word processing, spreadsheet, or database management software product except for the exclusive use of importing data to the various formats supported by microsoft access. note: a product that includes limited word processing, spreadsheet or database components along with other components which provide significant and primary value, such as an accounting product with limited spreadsheet capability, is not considered to be a "general purpose" product. for purposes of the foregoing the "jet files" shall mean the following files: vbajet32.dll, expsrv.dll, msexch40.dll, msjint40.dll, msexcl40.dll, msjet40.dll, msjetoledb40.dll, msjter40.dll, msjtes40.dll, msltus40.dll, mspbde40.dll, msrclr40.dll, msrd2x40.dll, msrd3x40.dll, msrecr40.dll, msrepl40.dll, msrpfs40.dll, msrpjt40.dll, mstext40.dll, mswdat10.dll, mswstr10.dll, msxbde40.dll. if you redistribute the sql server client connectivity components, you agree to redistribute them in their entirety, in object code only, in a single executable file as provided by microsoft (sqlredis.exe). you may not separate the components contained within the sqlredis.exe. contact microsoft for the applicable royalties due and other licensing terms for all other uses and/or distribution of the redistributable components. disclaimer of warranties. to the maximum extent permitted by applicable law, microsoft and its suppliers provide the redistributable components and any (if any) support services related to the redistributable components ("support services") as is and with all faults, and hereby disclaim all warranties and conditions, either express, implied or statutory, including, but not limited to, any (if any) implied warranties or conditions of merchantability, of fitness for a particular purpose, of lack of viruses, of accuracy or completeness of responses, of results, and of lack of negligence or lack of workmanlike effort, all with regard to the redistributable components, and the provision of or failure to provide support services. also, there is no warranty or condition of title, quiet enjoyment, quiet possession, correspondence to description or non-infringement, with regard to the redistributable components. the entire risk as to the quality of or arising out of use or performance of the redistributable components and support services, if any, remains with you. exclusion of incidental, consequential and certain other damages. to the maximum extent permitted by applicable law, in no event shall microsoft or its suppliers be liable for any special, incidental, indirect, or consequential damages whatsoever (including, but not limited to, damages for loss of profits or confidential or other information, for business interruption, for personal injury, for loss of privacy, for failure to meet any duty including of good faith or of reasonable care, for negligence, and for any other pecuniary or other loss whatsoever) arising out of or in any way related to the use of or inability to use the redistributable components, the provision of or failure to provide support services, or otherwise under or in connection with any provision of this eula, even in the event of the fault, tort (including negligence), strict liability, breach of contract or breach of warranty of microsoft or any supplier, and even if microsoft or any supplier has been advised of the possibility of such damages. limitation of liability and remedies. notwithstanding any damages that you might incur for any reason whatsoever (including, without limitation, all damages referenced above and all direct or general damages), the entire liability of

microsoft and any of its suppliers under any provision of this eula and your exclusive remedy for all of the foregoing shall be limited to the greater of the amount actually paid by you for the redistributable components or u.s.$5.00. the foregoing limitations, exclusions and disclaimers shall apply to the maximum extent permitted by applicable law, even if any remedy fails its essential purpose. ---------------------------------------------installation notes for pivottable service ----------------------------------------pivottable service includes a number of dlls that you may need to ship with a client application. any individual client application may need a combination of these components, depending on the pivottable service features it uses. file set 1: msolap80.dll, msolui80.dll, olapuir.rll, msolap80.rll, and microsoft data access components (mdac) file set 2: file set 1 plus msmdcb80.dll, msmdgd80.dll, and an appropriate ole db tabular data provider file set 3: file set 1 plus msdmine.dll, msdmine.rll, and msdmeng.dll the following task-fileset pairs show which file set to use based on which tasks you want your client application to perform: task: communicate with the analysis server using tcp/ip or http file set: 1 task: read multidimensional olap (molap) local cube files file set: 1 task: read relational olap (rolap) local cube files file set: 1 task: create and refresh local cubes file set: 2 task: read olap and relational data mining models file set: 3 you must install mdac before you install pivottable service. file sets 2 and 3 can be combined if the entire suite of components is desired. if you install pivottable service with microsoft windows 95, you must install distributed com (dcom) before you install mdac. for more information about distributing and

installing mdac, see the msdn library at http://msdn.microsoft.com/. the pivottable(r) service files, with the exception of the resource files (files with an extension of .rll) must be installed to the following location: "system drive"\program files\common files\system\ole db after the required components have been installed, the following components must also be registered using regsvr32.exe or their own dllselfregister functions: msolap80.dll msolui80.dll msmdgd80.dll msmdcb80.dll msdmine.dll msdmeng.dll the resource files, msolap80.rll, olapuir.rll, and msdmine.rll, must be installed to the following location: "system drive"\program files\common files\system\ole db\resources\1033 when registering dlls, observe the following dependencies: (a) msolap80.dll depends on msolap80.rll, wininet.dll, and oleaut32.dll version 2.3.0 or later; (b) msolap80.rll is the resource file for msolap80.dll. oleaut32 is the ole automation run-time library, and is also installed in either the c:\windows\system or c:\winnt\system32 directories (c) msolui80.dll depends on msolap80.dll, olapuir.rll, msvbvm60.dll, and oleaut32.dll version 2.3.0 or later. msvbvm60.dll is a microsoft visual basic run-time library, and wininet.dll contains the internet automation run-time library. both are installed in the c:\windows\system or c:\winnt\system32 directory. note you can use the depends.exe utility, which is available in the windows nt(r) resource kit, to see the full set of external dependencies for these dlls. installation registry settings for the purposes of installing and uninstalling, all pivottable(r) service files should be considered shared files. create a registry value for each pivottable service file under the following registry key: hkey_local_machine\software\microsoft\windows\currentversion\shareddlls if this registry value (known as the reference counter) already exists, it should be incremented by one during installation of the pivottable service files. during removal of the pivottable service files, the reference counter should be decremented by one. the pivottable service files should not be deleted if the corresponding reference counter is greater than zero. two setup programs, ptslite.exe and ptsfull.exe, are provided on the sql server 2000 cd-rom, in the folder \msolap\install\pts. ptslite.exe installs the pivottable service files only; ptsfull.exe installs the pivottable service files and microsoft data access components (mdac).

in addition to two required parameters, both ptslite.exe and ptsfull.exe use the same optional command line parameters as the analysis services setup program. the required parameters, which must be the first parameters on the command line, are -s and -a. optional parameters follow these required parameters. for example, to use ptslite.exe to perform a silent installation of the pivottable service files, the command is: ptslite -s -a -s -f1setup.iss ... the pts files listed as "version 7.0" are included for backwards compatibility only. installation notes for decision support objects (dso) ----------------------------------------------------unlike microsoft pivottable service files that are required by clients that connect to microsoft sql server analysis services, dso files are optional. dso is only required for running programs that need to manage olap service objects, such as dimension maintenance, cube processing, and virtual dimension creation. before installing dso, ensure that microsoft data access components (mdac) and pivottable service have been installed. dso is only supported on microsoft windows nt 4.0 and windows 2000. it is not supported on windows 95 or windows 98. microsoft pivottable service must be installed before you install dso. the dso files should be installed in the following sequence. must be registered. msmdnet.dll msmdlock.dll msmddo.dll

each of these files

these files must reside in the following folder: "system drive"\program files\common files\microsoft shared\dso the resource file, msmdso.rll, does not need to be registered and is installed by default in the following location: "system drive"\program files\common files\microsoft shared\dso\resources\1033 when registering dlls, the following dependency should be observed: msmddo80.dll depends on msvbvm60.dll. msvbvm60.dll is a visual basic run-time library installed in the \winnt\system32 folder. the depends.exe utility, available in the windows nt resource kit, can be used to see the full set of external dependencies. to register the dll files, you should use regsvr32.exe or their own dllselfregister() functions. additionally, registry entries for each file should be made under the following registry key: hkey_local_machine\software\microsoft\windows\currentversion\shareddlls if this registry value (known as the reference counter) already exists, it should

be incremented by one during installation of the dso files. when uninstalling the dso files, the reference counter should be decremented by one. the dso files should not be deleted if the corresponding reference counter is greater than 0. for more information about setup design specifications, refer to http://www.microsoft.com/win32dev/uiguide/. maintaining backward compatibility: the backward compatibility files that are included with analysis services (that is, msmddo.dll and msmdsgn.dll) are not compatible with the files of the same name that were included with sql server 7.0 olap services (that is, the 7.0 versions of these files). use the following rules to assist you in determining which files to install: if the application will only be used with sql server 2000 analysis services, msmddo80.dll, msmdnet.dll, msmdlock.dll, and msmdso.rll must be installed on the target computer. if the application will also be used with sql server 7.0 olap services, msmddo.dll must be installed. if the 7.0 version of this file already exists on the target computer, it must be replaced with the newer version. installation notes for english query -----------------------------------when including english query capability in an application, the english query runtime dlls accompany the application. the exception to redistributing the english query dlls occurs when the english query application is deployed on a web server. in this case, the english query runtime only needs to be installed on the web server. mseqgrqb.ocx and mseqgrqb.cab are microsoft(r) activex(r) controls used to enhance the use of english query models. for applications deployed to a web site, end users can download these files from the site. it is neither necessary nor permissible to allow end users to download the english query system dlls from the web. redistributing the english query runtime involves copying all of the english query dlls and registering the necessary dlls when the application is installed. if you need to redistribute the english query dlls, all users of english query must be licensed microsoft(r) sql server(tm) users. because the application usually accesses sql server data, each english query user must have a sql server client access license. you can redistribute the files shown in this table with an english query application. file name

description

mseqole.dll english query mseqbase.dll english mseqsql.dll english query mseqmsg.dll english query mseqconn.dll english mseqcore.eqd english mseqgrqb.ocx english mseqgrqb.cab english

server object model query supplemental file supplemental file supplemental file query supplemental file query supplemental file query question builder microsoft activex(r) control query cabinet file containing:

mseqgrqb.ocx, the help file (.chm); and the .inf file that tells microsoft internet explorer: where to copy the files, how to register the .ocx file, and how to uninstall the control. when english query is installed, these files are installed by default in the \program files\common files\system\eq80 directory. the english query application or setup installs these files to this common directory, or creates it if it does not exist, before registering them. the compiled english query application (.eqd), for example northwind.eqd, is copied to the end user's computer. by default, the .eqd file is located in the same directory that is used by the rest of the application. registering the necessary english query files: both mseqole.dll and mseqgrqb.ocx must be registered using the regsvr32.exe utility. the following english query files must be registered using the regsvr32.exe utility: to register mseqole.dll, use "\path to the dll\mseqole.dll", for example: regsvr32 "\program files\common files\system\eq80\mseqole.dll" to register mseqgrqb.ocx, use "\path to the location of the activex controls\mseqgrqb.ocx", for example: regsvr32 "\program files\common files\system\eq80\mseqgrqb.ocx" if you do not want the end users to see the dialog box that confirms successful registration, use the /s (silent) switch: regsvr32 "\program files\common files\system\eq80\mseqole.dll" /s if you want to clean up the end users' registries when english query is uninstalled, use the /u (uninstall) switch: regsvr32 "\program files\common files\system\eq80\mseqole.dll" /u installation notes for repository --------------------------------install the following repository files in the program files\common files\microsoft shared\repostry directory: dbscan.dll insrepim.dll insrepim.exe msmdcxml.dll repbr.dll repbrui.dll repodbc.dll install the following repository files in the program files\common files\microsoft shared\repostry\resources\1033 directory: reprc.rll msmdcxml.rll msrmirc.rll

repbrui.rll repbrmdc.rll install the following repository files in the program files\common files\microsoft shared\repostry\oim\install directory: db2.rdm dbm.rdm dtm.rdm dts.rdm eqm.rdm gen.rdm ifx.rdm mds.rdm ocl.rdm olp.rdm sim.rdm sql.rdm tfm.rdm uml.rdm umx.rdm the following files must be registered using the regsvr32.exe utility: dbscan.dll insrepim.dll msmdcxml.dll repbr.dll repbrui.dll repodbc.dll example: regsvr32 "program files\common files\microsoft shared\repostry\dbscan.dll" installation notes for replication files ---------------------------------------the atl.dll file should only be redistributed on windows nt, windows 98, and windows 95. the following file(s) should be installed in the system folder (i.e., \winnt\system32 or \windows\system): atl.dll the following file(s) should be installed in \program files\microsoft sql server\80\com: rdistcom.dll replerrx.dll replprov.dll replrec.dll sqldistx.dll sqlmergx.dll the following resource file(s) should be installed in \program files\microsoft sql server\80\com\resources\: replres.rll the following file(s) should be installed in \program files\common files\microsoft shared\database replication\conflict viewer:

wzcnf.dll wzcnfclt.exe the following resource file(s) should be installed in a language specific directory \program files\common files\microsoft shared\database replication\ conflict viewer\resources\: wzcnfrc.rll the following file(s) must be registered using the regsvr32.exe utility: rdistcom.dll replerrx.dll replprov.dll replrec.dll sqldistx.dll sqlmergx.dll example:

regsvr32 \program files\microsoft sql server\80\com\rdistcom.dll

the following file(s) must be registered or unregistered using the specified syntax: wzcnflct.exe /regserver wzcnflct.exe /unregserver all of these files should be considered "shared files". therefore, you should create the following registry value for each of the above files: hkey_local_machine\software\microsoft\windows\currentversion\shareddlls further, if this registry value (known as the reference counter) already it should be incremented by one during installation of the these files. uninstalling these files, the reference counter should be decremented by these files should not be deleted if the corresponding reference counter greater than 1.

exists, when one. is

for more information about setup design specifications, refer to http://www.microsoft.com/win32dev/uiguide/. installation notes for data transformation services (dts) --------------------------------------------------------the following files must be registered using the regsvr32.exe utility: dtsffile.dll dtspkg.dll dtspump.dll axscphst.dll example:

regsvr32 80\tools\binn\dtsffile.dll

the sqlunirl.dll file should reside in the system folder (i.e., \winnt\system32 or \windows\system). installation notes for distributed management objects (dmo) ----------------------------------------------------------the sqldmo.dll file must be registered using the regsvr32.exe utility. example: regsvr32 80\tools\binn\sqldmo.dll) the sqlunirl.dll file should reside in the system folder (i.e., \winnt\system32 or

\windows\system). installation notes for sql namespace (sqlns) files -------------------------------------------------the following files must be registered using the regsvr32.exe utility: sqlns.dll sqllex.dll example:

regsvr32 80\tools\binn\sqlns.dll

installation notes for osql file -------------------------------the osql file should be in the application directory or on the path.