PORTS USED: installed

Showing posts with label installed. Show all posts

Friday, March 30, 2012

Predict Probability in Decision Trees

Hello,

I installed the bike buyer example and i am learning the DMX language. Now i wrote the following query (using MS decision trees):

SELECT
T.[Last Name],
[Bike Buyer],
PredictProbability(Predict([Bike Buyer])) AS [Probability]
From
[v Target Mail]
PREDICTION JOIN
OPENQUERY
(....... And so on..)

Now the result is surprising to me. In the resulttabel all the probabilities are equal.

Bike Buyer Probability
1 0.99994590500919611
0 0.99994590500919611
0 0.99994590500919611
0 0.99994590500919611
0 0.99994590500919611
1 0.99994590500919611

and so on.

Now i am wondering what predictProbability means. I thought that PredictProbability meant the probability that the prediction is correct. Now all the probabilities are the same and the input is different. Can somebody tell me what PredictProbability means or am I using it wrong?

Thanx in advance,

Joris Valkonet

This is an interesting query - I would write it as "PredictProbability([Bike Buyer])" however, the syntax is semantically the same. Another thing to try is PredictNodeId([Bike Buyer]) to see exactly the node used for the prediction and then check that node to see the distribution.

It's possible that PredictProbability(Predict([Bike Buyer])) is exposing a bug and you should use the simpler syntax above.

HTH

-Jamie

|||

Thank you for your reply.
I modified my query to PredictProbability([bike buyer]) and this made no difference. The result is the same.

Then I checked the PredictNodeId([Bike Buyer]) and this is the result:

FirstName

LastName

bike buyer

Expression

Abby

Malhotra

000000003

Abby

Prasad

000000003

Abby

Rodriguez

000000003

Abby

Srini

000000003

Abigail

Brown

000000003

Abigail

Bryant

000000003

Abigail

Davis

000000003

Abigail

Flores

000000003

Now the nodeId is the rootnode of the tree and the probability of the root node is indeed the value 0.99994590500919611. So if I understand this correct, the rootnode of the decision tree is used for all probability predictions. Is this correct?

(Maybe my query is incorrect and therefore the whole DMX query below)

SELECT
t.[FirstName],
t.[LastName],
[bike buyer],
PredictNodeId([bike buyer]) AS [Predicted NodeId]
From
[v Target Mail]
PREDICTION JOIN
OPENQUERY([Adventure Works DW],
'SELECT
[Gender],
[FirstName],
[MiddleName],
[LastName],
[BirthDate],
[MaritalStatus],
[EmailAddress],
[YearlyIncome],
[TotalChildren],
[NumberChildrenAtHome],
[HouseOwnerFlag],
[NumberCarsOwned],
[AddressLine1],
[AddressLine2],
[Phone]
FROM
[dbo].[ProspectiveBuyer]
') AS t
ON
[v Target Mail].[First Name] = t.[FirstName] AND
[v Target Mail].[Middle Name] = t.[MiddleName] AND
[v Target Mail].[Last Name] = t.[LastName] AND
[v Target Mail].[Birth Date] = t.[BirthDate] AND
[v Target Mail].[Marital Status] = t.[MaritalStatus] AND
[v Target Mail].[Gender] = t.[Gender] AND
[v Target Mail].[Email Address] = t.[EmailAddress] AND
[v Target Mail].[Yearly Income] = t.[YearlyIncome] AND
[v Target Mail].[Total Children] = t.[TotalChildren] AND
[v Target Mail].[Number Children At Home] = t.[NumberChildrenAtHome] AND
[v Target Mail].[House Owner Flag] = t.[HouseOwnerFlag] AND
[v Target Mail].[Number Cars Owned] = t.[NumberCarsOwned] AND
[v Target Mail].[Address Line1] = t.[AddressLine1] AND
[v Target Mail].[Address Line2] = t.[AddressLine2] AND
[v Target Mail].[Phone] = t.[Phone]

|||

Something wierd is happening here - Predict([Bike Buyer]), which is equivalent to saying just [Bike Buyer], returns the highest probability value for the prediction. That means that whatever node the tree goes to, it will return the highest probability state for that node. I can't see how you are getting different prediction results from the same node.

However, something else struck me as odd. The predict probability of 0.999... doesn't seem right. In fact the only time I have ever seen anything like this is when all the data at the node was missing, and the actual non-missing values only recieved the bayesian prior. By default prediction never returns missing (if you are asking for a value, it assumes you want an actual value). If you do a Predict([Bike Buyer], INCLUDE_MISSING) you will get predictions that include the missing value. If there were no observations in the training data of the states 1 and 0 then they would only have their prior probabilities which would be equal and then the choice of a state would be arbitrary.

What confuses me is that PredictProbabililty should behave the same way.

Can you do a SELECT FLATTENED NODE_DISTRIBUTION FROM [v Target Mail].CONTENT and post the results?

Thanks

|||

Thanks for your analysis. I tried to post the whole result of the query "SELECT FLATTENED NODE_DISTRIBUTION FROM [v Target Mail].CONTENT ", but then an unknown error occurs. I think because the resulttable is to big. So... i will give the first top rows of the result.

Thanks....

ATTRIBUTE_NAME

ATTRIBUTE_VALUE

SUPPORT

PROBABILITY

VARIANCE

.VALUETYPE

Bike Buyer

Missing

0.000432432

Bike Buyer

0.494048907

18484

0.999567568

0.249964584

Birth Date

5.45E-06

16892175

Birth Date

0.080783333

Birth Date

22673.85945

16892175

Date First Purchase

-0.000941648

76769.40019

Date First Purchase

3242.190525

Date First Purchase

37852.25763

76769.40019

Number Cars Owned

-0.079859089

1.295870198

Number Cars Owned

301.5988757

Number Cars Owned

1.502705042

1.295870198

Number Children At Home

-0.015796323

2.318367003

Number Children At Home

9.530872281

Number Children At Home

1.004057563

2.318367003

Total Children

-0.003992138

2.599718694

Total Children

2.60E+01

Total Children

1.844351872

2.599718694

Yearly Income

2.02E-06

1042319181

Yearly Income

116.9361238

Yearly Income

57305.77797

1042319181

36.04143269

0.166743652

Bike Buyer

Missing

0.000205761

0.00E+00

Bike Buyer

4858

0.999794239

5.14E-07

Bike Buyer

Missing

0.000536481

Bike Buyer

0.507518797

1862

0.999463519

0.249943468

Date First Purchase

-0.010374704

1160.841795

Date First Purchase

679.5475673

Date First Purchase

37822.50644

1160.841795

Geography Key

0.000170418

36083.71548

Geography Key

1.990727272

Geography Key

236.4581096

36083.71548

Number Cars Owned

-0.072103841

1.254812169

Number Cars Owned

2.37E+01

Number Cars Owned

1.523630505

1.254812169

Yearly Income

1.29E-06

1131929217

Yearly Income

7.102048444

Yearly Income

60633.72718

1131929217

392.8960717

0.113511443

Bike Buyer

Missing

0.000123274

Bike Buyer

0.256103576

8110

0.999876726

0.190514534

|||

I see the problem - you have Bike Buyer modeled as continuous where it should be discrete. PredictProbability was giving you the probability that BikeBuyer exists in this case. To get the confidence of the prediction for continuous predictions, you want to use PredictStdev.

Essentially what was happening was that the model was creating a linear regression to predict bike buyer rather than a classification model. Changing the content type to "Discrete" will fix your issue. If you are creating the model from the source table (rather than a cube), you can click on "Detect" on the data types page of the wizard and it will automatically determing that Bike Buyer should be discrete.

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

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 SP2 GDR

I have a question about the post SP2 GDR that just came out in the last day or two. My laptop only has the client tools installed, not the server components (except for the SSIS server component). Is there any need for me to install this GDR? Does it impact the Management Studio code which views maintenance plans on remote SQL Servers or anything?

The information about the reason for the update of SQL Server SP2 is contained here:

http://support.microsoft.com/kb/933508/en-us

The basic summary is that if you use SQL Server 2005 Database Maintenance plans (not legacy plans from a migration) which use cleanup intervals, and you have edited those plans with the original SP2 tools, then these intervals may have been "corrupted".

You should install the GDR patch if you have the admin tools, and if you have updated such plans on your server with the original SP2 patch you should, once the GDR is installed, edit those plans and check/correct the cleanup intervals.

|||

Thanks for the reply. I wasn't asking what the patch did, I was wondering whether it was necessary to install on my laptop which only had the management tools and not an instance of SQL Server.

This discussion is unimportant now as Windows Update, just this morning, had me install an 18MB update to fix this very issue.

post SP2 GDR

The information about the reason for the update of SQL Server SP2 is contained here:

http://support.microsoft.com/kb/933508/en-us

|||

Thanks for the reply. I wasn't asking what the patch did, I was wondering whether it was necessary to install on my laptop which only had the management tools and not an instance of SQL Server.

This discussion is unimportant now as Windows Update, just this morning, had me install an 18MB update to fix this very issue.

Post Installation error with RS2000 on Win2000 Server

Hello,

I have installed RS2000 with no errors, but when i browse to localhost/Reports i get an RS error page that reads:

"An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

The profile for the user is a temporary profile.

I have checked the LogFiles (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles) and the error message reads as follows:

aspnet_wp!ui!1608!22/03/2006-14:22:27:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Runtime.InteropServices.COMException (0x80090024): The profile for the user is a temporary profile.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
aspnet_wp!ui!1608!22/03/2006-14:22:27:: e ERROR: HTTP status code --> 200
-Details--
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Runtime.InteropServices.COMException (0x80090024): The profile for the user is a temporary profile.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String Item) at Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item) at Microsoft.ReportingServices.UI.Permissions.GetPermissions() at Microsoft.ReportingServices.UI.Permissions..ctor(String path) at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath) at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser() at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain()
aspnet_wp!ui!1608!22/03/2006-14:22:28:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Seen as how the only thing in this that makes any sense to me at all is the phrase "The profile for the user is a temporary profile", i assume that this has something significant to do with the problem. However, Knowing this, i'm still not sure what to do to fix it as i'm not a newtowork/server admin.

Also, this server is a domain controller on windows 2000 server with sp4

Can someone please help.

Robbie,

I'm running into the exact same error with the exact same scenario. Did you ever resolve this issue?

Thanks,

Beau Lynch

Post Installation error with RS2000 on Win2000 Server

Hello,

I have installed RS2000 with no errors, but when i browse to localhost/Reports i get an RS error page that reads:

"An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

The profile for the user is a temporary profile.

I have checked the LogFiles (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles) and the error message reads as follows:

Also, this server is a domain controller on windows 2000 server with sp4

Can someone please help.

Robbie,

I'm running into the exact same error with the exact same scenario. Did you ever resolve this issue?

Thanks,

Beau Lynch

Monday, March 12, 2012

Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> > I just installed Windows 2003 Server and SQL Server 2000. I would like
to
> > use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a
mail
> > profile in Outlook.
> >
> > Is it possible to setup SQL Server Mail services without installing
> Outlook?
> > I remember in NT there was a mail icon in the Control Panel, this isn't
> > there anymore in 2003.
> >
> > Thanks
> > ckaneko
> >
> >
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckaneko
You don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default...b;en-us;263556
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm
|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default...;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.[vbcol=seagreen]
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
mail
> Outlook?
>
|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/defaul...kb;en-us;263556
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to u
se a MAPI client and you only need to send mail take a look at xpsmtp. dev.net/xp/xpsmtp.htm" target="_blank">http://sql
dev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/defaul...b;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
mail[vbcol=seagreen]
> Outlook?
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl..
.
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outloo
k?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Friday, March 30, 2012

Predict Probability in Decision Trees

Friday, March 23, 2012

Potential conflicts during cluster installs of SS2000 and AS2000

Wednesday, March 21, 2012

PostgreSQL Database and Reporting Service?

Tuesday, March 20, 2012

post SP2 GDR

post SP2 GDR

Post Installation error with RS2000 on Win2000 Server

Post Installation error with RS2000 on Win2000 Server

Monday, March 12, 2012

Possible to setup SQL Mail w/o installing Outlook?

Possible to setup SQL Mail w/o installing Outlook?

Possible to setup SQL Mail w/o installing Outlook?

PORTS USED

Blog Archive

About Me