here's the problems I'm having with MSDE:
I install MSDE SP3a with my application using InstallShield. The problem is that not everything is installed, because after I'm prompted for reboot, the database starts up, everything ok, right?
No, because when I run some scripts we have created to access the database, this dialog pops up like it needs to install more stuff for MSDE. It starts "configuring MSDE" and looks for the installer package and begins installing more stuff. What is it i
nstalling?
I'm guessing it has to do with some lines in the scripts that aren't quite supported or that require something that the standard distro doesn't install by default. Any ideas on tracking this down? Will this "installer" start when the line is executed in
my vb.net code or will it start when the vb.net code is started and it realizes it needs more stuff? Is there a way to install everything by default to avoid this?
Thanks,
Jacob
Here's some more information, I extracted this from the log, btw this is on a windows server 2k3:
Event Type:Warning
Event Source:MsiInstaller
Event Category:None
Event ID:1004
Date:6/18/2004
Time:11:42:16 AM
User:N/A
Computer:FUNKMACHINE
Description:
Detection of product '{E09B48B5-E141-427A-AB0C-D3605127224A}', feature 'SqlRun', component '{072BBB16-FE7A-405F-BBCC-54622D21CE3A}' failed. The resource 'HKEY_CURRENT_USER\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\Service Manager\' does not exist.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type:Warning
Event Source:MsiInstaller
Event Category:None
Event ID:1001
Date:6/18/2004
Time:11:42:16 AM
User:N/A
Computer:FUNKMACHINE
Description:
Detection of product '{E09B48B5-E141-427A-AB0C-D3605127224A}', feature 'SqlRun' failed during request for component '{436D7A23-36BE-11D2-ACBB-0080C7FCBB84}'
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type:Information
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:6/18/2004
Time:11:42:26 AM
User:N/A
Computer:FUNKMACHINE
Description:
8128 :
Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'xp_instance_regread'.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: c0 1f 00 00 0a 00 00 00 à......
0008: 0c 00 00 00 46 00 55 00 ...F.U.
0010: 4e 00 4b 00 4d 00 41 00 N.K.M.A.
0018: 43 00 48 00 49 00 4e 00 C.H.I.N.
0020: 45 00 00 00 07 00 00 00 E......
0028: 6d 00 61 00 73 00 74 00 m.a.s.t.
0030: 65 00 72 00 00 00 e.r...
Event Type:Information
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:6/18/2004
Time:11:42:55 AM
User:N/A
Computer:FUNKMACHINE
Description:
17148 :
SQL Server is terminating due to 'stop' request from Service Control Manager.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: fc 42 00 00 0a 00 00 00 üB.....
0008: 0c 00 00 00 46 00 55 00 ...F.U.
0010: 4e 00 4b 00 4d 00 41 00 N.K.M.A.
0018: 43 00 48 00 49 00 4e 00 C.H.I.N.
0020: 45 00 00 00 07 00 00 00 E......
0028: 6d 00 61 00 73 00 74 00 m.a.s.t.
0030: 65 00 72 00 00 00 e.r...
Event Type:Information
Event Source:MsiInstaller
Event Category:None
Event ID:11728
Date:6/18/2004
Time:11:43:11 AM
User:N/A
Computer:FUNKMACHINE
Description:
Product: Microsoft SQL Server Desktop Engine -- Configuration completed successfully.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 45 30 39 42 34 38 42 {E09B48B
0008: 35 2d 45 31 34 31 2d 34 5-E141-4
0010: 32 37 41 2d 41 42 30 43 27A-AB0C
0018: 2d 44 33 36 30 35 31 32 -D360512
0020: 37 32 32 34 41 7d 7224A}
What is triggering the MSI installer? How can I prevent this from interrupting my code?
Thanks,
Jacob
"Jacob438" wrote:
> here's the problems I'm having with MSDE:
> I install MSDE SP3a with my application using InstallShield. The problem is that not everything is installed, because after I'm prompted for reboot, the database starts up, everything ok, right?
> No, because when I run some scripts we have created to access the database, this dialog pops up like it needs to install more stuff for MSDE. It starts "configuring MSDE" and looks for the installer package and begins installing more stuff. What is it
installing?
> I'm guessing it has to do with some lines in the scripts that aren't quite supported or that require something that the standard distro doesn't install by default. Any ideas on tracking this down? Will this "installer" start when the line is executed
in my vb.net code or will it start when the vb.net code is started and it realizes it needs more stuff? Is there a way to install everything by default to avoid this?
> Thanks,
> Jacob
Showing posts with label sp3a. Show all posts
Showing posts with label sp3a. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
Installing A Default Instance AFTER a Named Instance??
I have SQL Server 2000 Standard Edition (sp3a) running on a windows 2003 (sp4) Server.
It is a Production Server with 3 NAMED Instances and NO Default Instance.
Does anyone know if I can rerun the SQL Server Install and add a DEFAULT Instance to this box without disrupting the other Named Instances?Except for a reboot after the install, you should have no problems installing a default instance.|||Thank you : )|||Will the default instance automatically have the name of the Server - or is there a way to give it name - like you would a named instance.. sorry if the question sounds stupid.. : )|||The default instance will have the name of the server. The only way around this that I can think of off the top of my head is to give the machine a DNS alias.|||Thanks !!! I'm not so much worried about the name as I am Blowing up the Server by installing a Default Instance AFTER it has already been populated with Named Instances.
It is a Production Server with 3 NAMED Instances and NO Default Instance.
Does anyone know if I can rerun the SQL Server Install and add a DEFAULT Instance to this box without disrupting the other Named Instances?Except for a reboot after the install, you should have no problems installing a default instance.|||Thank you : )|||Will the default instance automatically have the name of the Server - or is there a way to give it name - like you would a named instance.. sorry if the question sounds stupid.. : )|||The default instance will have the name of the server. The only way around this that I can think of off the top of my head is to give the machine a DNS alias.|||Thanks !!! I'm not so much worried about the name as I am Blowing up the Server by installing a Default Instance AFTER it has already been populated with Named Instances.
Installing a cluster on an existing instance of SQL 2000 SP3A
I have been "tapped" to install a passive node on an instance of SQL
that is not currently configured for clustering on a W2003. Can I
simply install clustering services on the current production instance,
then install a new instance on what would be the passive node? Then add
it via cluster admin?
Can I run cluster communications, heartbeat, etc on the public NICs..I
do not have two interfaces on each server.
Any information would be greatly appreciated as I have only done new
deployments and this being a prod server I do not want to try the trial
and error approach.
Thanks,
Hulicat
You can use the current active node as a cluster member. You can then
install a clustered instance of SQL and migrate the databases. The final
step is to turn off the original instance. Possible, Yes. Recommended, NO.
This entire project sounds like a low-availability solution. You are
reusing equipment instead of purchasing a certified cluster configuration.
The one-NIC cluster is possible but falls into the "worst practices"
category. Not having a test platform, even a virtual one, is asking for
even more trouble.
Clustering is a hardware and systems tool to help achieve increased system
availability. Shortcutting the hardware and the procedures will result in
lower availability rather than higher availability.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1162242129.910915.61910@.e3g2000cwe.googlegrou ps.com...
>I have been "tapped" to install a passive node on an instance of SQL
> that is not currently configured for clustering on a W2003. Can I
> simply install clustering services on the current production instance,
> then install a new instance on what would be the passive node? Then add
> it via cluster admin?
> Can I run cluster communications, heartbeat, etc on the public NICs..I
> do not have two interfaces on each server.
> Any information would be greatly appreciated as I have only done new
> deployments and this being a prod server I do not want to try the trial
> and error approach.
> Thanks,
> Hulicat
>
|||Thanks for that!
I am going tp lobby for new hardware or scratch the idea.
It's a small SPS portal.
Regards~~~
Geoff N. Hiten wrote:[vbcol=seagreen]
> You can use the current active node as a cluster member. You can then
> install a clustered instance of SQL and migrate the databases. The final
> step is to turn off the original instance. Possible, Yes. Recommended, NO.
> This entire project sounds like a low-availability solution. You are
> reusing equipment instead of purchasing a certified cluster configuration.
> The one-NIC cluster is possible but falls into the "worst practices"
> category. Not having a test platform, even a virtual one, is asking for
> even more trouble.
> Clustering is a hardware and systems tool to help achieve increased system
> availability. Shortcutting the hardware and the procedures will result in
> lower availability rather than higher availability.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Hulicat" <dennis_A_white@.yahoo.com> wrote in message
> news:1162242129.910915.61910@.e3g2000cwe.googlegrou ps.com...
that is not currently configured for clustering on a W2003. Can I
simply install clustering services on the current production instance,
then install a new instance on what would be the passive node? Then add
it via cluster admin?
Can I run cluster communications, heartbeat, etc on the public NICs..I
do not have two interfaces on each server.
Any information would be greatly appreciated as I have only done new
deployments and this being a prod server I do not want to try the trial
and error approach.
Thanks,
Hulicat
You can use the current active node as a cluster member. You can then
install a clustered instance of SQL and migrate the databases. The final
step is to turn off the original instance. Possible, Yes. Recommended, NO.
This entire project sounds like a low-availability solution. You are
reusing equipment instead of purchasing a certified cluster configuration.
The one-NIC cluster is possible but falls into the "worst practices"
category. Not having a test platform, even a virtual one, is asking for
even more trouble.
Clustering is a hardware and systems tool to help achieve increased system
availability. Shortcutting the hardware and the procedures will result in
lower availability rather than higher availability.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1162242129.910915.61910@.e3g2000cwe.googlegrou ps.com...
>I have been "tapped" to install a passive node on an instance of SQL
> that is not currently configured for clustering on a W2003. Can I
> simply install clustering services on the current production instance,
> then install a new instance on what would be the passive node? Then add
> it via cluster admin?
> Can I run cluster communications, heartbeat, etc on the public NICs..I
> do not have two interfaces on each server.
> Any information would be greatly appreciated as I have only done new
> deployments and this being a prod server I do not want to try the trial
> and error approach.
> Thanks,
> Hulicat
>
|||Thanks for that!
I am going tp lobby for new hardware or scratch the idea.
It's a small SPS portal.
Regards~~~
Geoff N. Hiten wrote:[vbcol=seagreen]
> You can use the current active node as a cluster member. You can then
> install a clustered instance of SQL and migrate the databases. The final
> step is to turn off the original instance. Possible, Yes. Recommended, NO.
> This entire project sounds like a low-availability solution. You are
> reusing equipment instead of purchasing a certified cluster configuration.
> The one-NIC cluster is possible but falls into the "worst practices"
> category. Not having a test platform, even a virtual one, is asking for
> even more trouble.
> Clustering is a hardware and systems tool to help achieve increased system
> availability. Shortcutting the hardware and the procedures will result in
> lower availability rather than higher availability.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Hulicat" <dennis_A_white@.yahoo.com> wrote in message
> news:1162242129.910915.61910@.e3g2000cwe.googlegrou ps.com...
Installatuin Problems
Hi
I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
(pending CD from retailer)
During the installation it tested for prerequisites and has thrown message
saying IIS is not installed or neither configured for rs.
But when I open .net report wizard etc are working fine. I can preview
report in .net
again Problem is when i tried to deploy it , it is saying reporting server
is not available.
I unistalled it and again checked while installing
I found the following:
again same problem related to IIS. ( I checked again ASP.NET ETC are
installed properly)
while installing it is not showing server componets and Report manager. It
is just showing client components. Does'nt eval edit have reporting server.
I dont know what to do at this
ANY HELP
Thanks in advance
R.DRS requires IIS with Dotnet 1.1 installed. Something is not right with the
prerequisites on your machine. The install should show the server
components. I used the evaluation edition for a couple of months so I know
for a fact it has everything.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R.D" <RD@.discussions.microsoft.com> wrote in message
news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> Hi
> I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> (pending CD from retailer)
> During the installation it tested for prerequisites and has thrown
> message
> saying IIS is not installed or neither configured for rs.
> But when I open .net report wizard etc are working fine. I can preview
> report in .net
> again Problem is when i tried to deploy it , it is saying reporting server
> is not available.
> I unistalled it and again checked while installing
> I found the following:
> again same problem related to IIS. ( I checked again ASP.NET ETC are
> installed properly)
> while installing it is not showing server componets and Report manager. It
> is just showing client components. Does'nt eval edit have reporting
> server.
> I dont know what to do at this
> ANY HELP
> Thanks in advance
> R.D
>|||Bruce,
I checked all, .net 2003 is installed, still problem persists.
Should I unistall IIS server and install again with all pre-requisites.
R.D
"Bruce L-C [MVP]" wrote:
> RS requires IIS with Dotnet 1.1 installed. Something is not right with the
> prerequisites on your machine. The install should show the server
> components. I used the evaluation edition for a couple of months so I know
> for a fact it has everything.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > Hi
> >
> > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> >
> > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > (pending CD from retailer)
> >
> > During the installation it tested for prerequisites and has thrown
> > message
> > saying IIS is not installed or neither configured for rs.
> >
> > But when I open .net report wizard etc are working fine. I can preview
> > report in .net
> >
> > again Problem is when i tried to deploy it , it is saying reporting server
> > is not available.
> >
> > I unistalled it and again checked while installing
> >
> > I found the following:
> >
> > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > installed properly)
> >
> > while installing it is not showing server componets and Report manager. It
> > is just showing client components. Does'nt eval edit have reporting
> > server.
> >
> > I dont know what to do at this
> >
> > ANY HELP
> >
> > Thanks in advance
> >
> > R.D
> >
> >
>
>|||Not sure what is happening for you. I have installed on 3 different machines
and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
pro I had to add IIS to the machine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R.D" <RD@.discussions.microsoft.com> wrote in message
news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> Bruce,
> I checked all, .net 2003 is installed, still problem persists.
> Should I unistall IIS server and install again with all pre-requisites.
> R.D
>
>
> "Bruce L-C [MVP]" wrote:
> > RS requires IIS with Dotnet 1.1 installed. Something is not right with
the
> > prerequisites on your machine. The install should show the server
> > components. I used the evaluation edition for a couple of months so I
know
> > for a fact it has everything.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > Hi
> > >
> > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > >
> > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > (pending CD from retailer)
> > >
> > > During the installation it tested for prerequisites and has thrown
> > > message
> > > saying IIS is not installed or neither configured for rs.
> > >
> > > But when I open .net report wizard etc are working fine. I can preview
> > > report in .net
> > >
> > > again Problem is when i tried to deploy it , it is saying reporting
server
> > > is not available.
> > >
> > > I unistalled it and again checked while installing
> > >
> > > I found the following:
> > >
> > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > installed properly)
> > >
> > > while installing it is not showing server componets and Report
manager. It
> > > is just showing client components. Does'nt eval edit have reporting
> > > server.
> > >
> > > I dont know what to do at this
> > >
> > > ANY HELP
> > >
> > > Thanks in advance
> > >
> > > R.D
> > >
> > >
> >
> >
> >|||I just had a thought. RS installs on the default website. Did you by any
chance remove the default website?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eIvKuPK$EHA.2568@.TK2MSFTNGP10.phx.gbl...
> Not sure what is happening for you. I have installed on 3 different
machines
> and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
> pro I had to add IIS to the machine.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> > Bruce,
> >
> > I checked all, .net 2003 is installed, still problem persists.
> >
> > Should I unistall IIS server and install again with all pre-requisites.
> >
> > R.D
> >
> >
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > RS requires IIS with Dotnet 1.1 installed. Something is not right with
> the
> > > prerequisites on your machine. The install should show the server
> > > components. I used the evaluation edition for a couple of months so I
> know
> > > for a fact it has everything.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > > Hi
> > > >
> > > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > > >
> > > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > > (pending CD from retailer)
> > > >
> > > > During the installation it tested for prerequisites and has thrown
> > > > message
> > > > saying IIS is not installed or neither configured for rs.
> > > >
> > > > But when I open .net report wizard etc are working fine. I can
preview
> > > > report in .net
> > > >
> > > > again Problem is when i tried to deploy it , it is saying reporting
> server
> > > > is not available.
> > > >
> > > > I unistalled it and again checked while installing
> > > >
> > > > I found the following:
> > > >
> > > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > > installed properly)
> > > >
> > > > while installing it is not showing server componets and Report
> manager. It
> > > > is just showing client components. Does'nt eval edit have reporting
> > > > server.
> > > >
> > > > I dont know what to do at this
> > > >
> > > > ANY HELP
> > > >
> > > > Thanks in advance
> > > >
> > > > R.D
> > > >
> > > >
> > >
> > >
> > >
>|||Bruce
Actually I unistalled IIS and installed again . Now I can see serve componets.
It is working fine.
Is there any way to store snapshots automatically to database instead of a
folder.
Thanks
R.D
"Bruce L-C [MVP]" wrote:
> Not sure what is happening for you. I have installed on 3 different machines
> and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
> pro I had to add IIS to the machine.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> > Bruce,
> >
> > I checked all, .net 2003 is installed, still problem persists.
> >
> > Should I unistall IIS server and install again with all pre-requisites.
> >
> > R.D
> >
> >
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > RS requires IIS with Dotnet 1.1 installed. Something is not right with
> the
> > > prerequisites on your machine. The install should show the server
> > > components. I used the evaluation edition for a couple of months so I
> know
> > > for a fact it has everything.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > > Hi
> > > >
> > > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > > >
> > > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > > (pending CD from retailer)
> > > >
> > > > During the installation it tested for prerequisites and has thrown
> > > > message
> > > > saying IIS is not installed or neither configured for rs.
> > > >
> > > > But when I open .net report wizard etc are working fine. I can preview
> > > > report in .net
> > > >
> > > > again Problem is when i tried to deploy it , it is saying reporting
> server
> > > > is not available.
> > > >
> > > > I unistalled it and again checked while installing
> > > >
> > > > I found the following:
> > > >
> > > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > > installed properly)
> > > >
> > > > while installing it is not showing server componets and Report
> manager. It
> > > > is just showing client components. Does'nt eval edit have reporting
> > > > server.
> > > >
> > > > I dont know what to do at this
> > > >
> > > > ANY HELP
> > > >
> > > > Thanks in advance
> > > >
> > > > R.D
> > > >
> > > >
> > >
> > >
> > >
>
>
I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
(pending CD from retailer)
During the installation it tested for prerequisites and has thrown message
saying IIS is not installed or neither configured for rs.
But when I open .net report wizard etc are working fine. I can preview
report in .net
again Problem is when i tried to deploy it , it is saying reporting server
is not available.
I unistalled it and again checked while installing
I found the following:
again same problem related to IIS. ( I checked again ASP.NET ETC are
installed properly)
while installing it is not showing server componets and Report manager. It
is just showing client components. Does'nt eval edit have reporting server.
I dont know what to do at this
ANY HELP
Thanks in advance
R.DRS requires IIS with Dotnet 1.1 installed. Something is not right with the
prerequisites on your machine. The install should show the server
components. I used the evaluation edition for a couple of months so I know
for a fact it has everything.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R.D" <RD@.discussions.microsoft.com> wrote in message
news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> Hi
> I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> (pending CD from retailer)
> During the installation it tested for prerequisites and has thrown
> message
> saying IIS is not installed or neither configured for rs.
> But when I open .net report wizard etc are working fine. I can preview
> report in .net
> again Problem is when i tried to deploy it , it is saying reporting server
> is not available.
> I unistalled it and again checked while installing
> I found the following:
> again same problem related to IIS. ( I checked again ASP.NET ETC are
> installed properly)
> while installing it is not showing server componets and Report manager. It
> is just showing client components. Does'nt eval edit have reporting
> server.
> I dont know what to do at this
> ANY HELP
> Thanks in advance
> R.D
>|||Bruce,
I checked all, .net 2003 is installed, still problem persists.
Should I unistall IIS server and install again with all pre-requisites.
R.D
"Bruce L-C [MVP]" wrote:
> RS requires IIS with Dotnet 1.1 installed. Something is not right with the
> prerequisites on your machine. The install should show the server
> components. I used the evaluation edition for a couple of months so I know
> for a fact it has everything.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > Hi
> >
> > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> >
> > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > (pending CD from retailer)
> >
> > During the installation it tested for prerequisites and has thrown
> > message
> > saying IIS is not installed or neither configured for rs.
> >
> > But when I open .net report wizard etc are working fine. I can preview
> > report in .net
> >
> > again Problem is when i tried to deploy it , it is saying reporting server
> > is not available.
> >
> > I unistalled it and again checked while installing
> >
> > I found the following:
> >
> > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > installed properly)
> >
> > while installing it is not showing server componets and Report manager. It
> > is just showing client components. Does'nt eval edit have reporting
> > server.
> >
> > I dont know what to do at this
> >
> > ANY HELP
> >
> > Thanks in advance
> >
> > R.D
> >
> >
>
>|||Not sure what is happening for you. I have installed on 3 different machines
and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
pro I had to add IIS to the machine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R.D" <RD@.discussions.microsoft.com> wrote in message
news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> Bruce,
> I checked all, .net 2003 is installed, still problem persists.
> Should I unistall IIS server and install again with all pre-requisites.
> R.D
>
>
> "Bruce L-C [MVP]" wrote:
> > RS requires IIS with Dotnet 1.1 installed. Something is not right with
the
> > prerequisites on your machine. The install should show the server
> > components. I used the evaluation edition for a couple of months so I
know
> > for a fact it has everything.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > Hi
> > >
> > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > >
> > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > (pending CD from retailer)
> > >
> > > During the installation it tested for prerequisites and has thrown
> > > message
> > > saying IIS is not installed or neither configured for rs.
> > >
> > > But when I open .net report wizard etc are working fine. I can preview
> > > report in .net
> > >
> > > again Problem is when i tried to deploy it , it is saying reporting
server
> > > is not available.
> > >
> > > I unistalled it and again checked while installing
> > >
> > > I found the following:
> > >
> > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > installed properly)
> > >
> > > while installing it is not showing server componets and Report
manager. It
> > > is just showing client components. Does'nt eval edit have reporting
> > > server.
> > >
> > > I dont know what to do at this
> > >
> > > ANY HELP
> > >
> > > Thanks in advance
> > >
> > > R.D
> > >
> > >
> >
> >
> >|||I just had a thought. RS installs on the default website. Did you by any
chance remove the default website?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eIvKuPK$EHA.2568@.TK2MSFTNGP10.phx.gbl...
> Not sure what is happening for you. I have installed on 3 different
machines
> and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
> pro I had to add IIS to the machine.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> > Bruce,
> >
> > I checked all, .net 2003 is installed, still problem persists.
> >
> > Should I unistall IIS server and install again with all pre-requisites.
> >
> > R.D
> >
> >
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > RS requires IIS with Dotnet 1.1 installed. Something is not right with
> the
> > > prerequisites on your machine. The install should show the server
> > > components. I used the evaluation edition for a couple of months so I
> know
> > > for a fact it has everything.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > > Hi
> > > >
> > > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > > >
> > > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > > (pending CD from retailer)
> > > >
> > > > During the installation it tested for prerequisites and has thrown
> > > > message
> > > > saying IIS is not installed or neither configured for rs.
> > > >
> > > > But when I open .net report wizard etc are working fine. I can
preview
> > > > report in .net
> > > >
> > > > again Problem is when i tried to deploy it , it is saying reporting
> server
> > > > is not available.
> > > >
> > > > I unistalled it and again checked while installing
> > > >
> > > > I found the following:
> > > >
> > > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > > installed properly)
> > > >
> > > > while installing it is not showing server componets and Report
> manager. It
> > > > is just showing client components. Does'nt eval edit have reporting
> > > > server.
> > > >
> > > > I dont know what to do at this
> > > >
> > > > ANY HELP
> > > >
> > > > Thanks in advance
> > > >
> > > > R.D
> > > >
> > > >
> > >
> > >
> > >
>|||Bruce
Actually I unistalled IIS and installed again . Now I can see serve componets.
It is working fine.
Is there any way to store snapshots automatically to database instead of a
folder.
Thanks
R.D
"Bruce L-C [MVP]" wrote:
> Not sure what is happening for you. I have installed on 3 different machines
> and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
> pro I had to add IIS to the machine.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> > Bruce,
> >
> > I checked all, .net 2003 is installed, still problem persists.
> >
> > Should I unistall IIS server and install again with all pre-requisites.
> >
> > R.D
> >
> >
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > RS requires IIS with Dotnet 1.1 installed. Something is not right with
> the
> > > prerequisites on your machine. The install should show the server
> > > components. I used the evaluation edition for a couple of months so I
> know
> > > for a fact it has everything.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > > Hi
> > > >
> > > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > > >
> > > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > > (pending CD from retailer)
> > > >
> > > > During the installation it tested for prerequisites and has thrown
> > > > message
> > > > saying IIS is not installed or neither configured for rs.
> > > >
> > > > But when I open .net report wizard etc are working fine. I can preview
> > > > report in .net
> > > >
> > > > again Problem is when i tried to deploy it , it is saying reporting
> server
> > > > is not available.
> > > >
> > > > I unistalled it and again checked while installing
> > > >
> > > > I found the following:
> > > >
> > > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > > installed properly)
> > > >
> > > > while installing it is not showing server componets and Report
> manager. It
> > > > is just showing client components. Does'nt eval edit have reporting
> > > > server.
> > > >
> > > > I dont know what to do at this
> > > >
> > > > ANY HELP
> > > >
> > > > Thanks in advance
> > > >
> > > > R.D
> > > >
> > > >
> > >
> > >
> > >
>
>
Wednesday, March 21, 2012
installed sp3a but @@version still says sp2
Ran the sp3a (setup.bat) on server from G:\ then MSSQL is
installed on F:\ (NOT C:). I choose default on the
installation because that is all it gave me, could not
type in. The installation went through and restarted
machine. MDAC got updated, but @.@.version in sql still
gives me 8.00.534.
Looks like databases have a updated modified date on them
bu they all say old version. Where did my update go? Any
files I can check for? Did it install it on C:'
Please help!Look for *.out files. If there are none, run the installation again with
the verbose logging option on (see the readme file for running setup from a
command line to change switches.)
"Kada" <kadahoffman@.hotmail.com> wrote in message
news:01a901c37faa$e952c730$a301280a@.phx.gbl...
> Ran the sp3a (setup.bat) on server from G:\ then MSSQL is
> installed on F:\ (NOT C:). I choose default on the
> installation because that is all it gave me, could not
> type in. The installation went through and restarted
> machine. MDAC got updated, but @.@.version in sql still
> gives me 8.00.534.
> Looks like databases have a updated modified date on them
> bu they all say old version. Where did my update go? Any
> files I can check for? Did it install it on C:'
> Please help!|||Do you mean if I do not see something called sp3_repl.out
and sp3_serv_uni.out? Or what Out files should I see?
Thanks!
>--Original Message--
>Look for *.out files. If there are none, run the
installation again with
>the verbose logging option on (see the readme file for
running setup from a
>command line to change switches.)
>
>
>"Kada" <kadahoffman@.hotmail.com> wrote in message
>news:01a901c37faa$e952c730$a301280a@.phx.gbl...
>> Ran the sp3a (setup.bat) on server from G:\ then MSSQL
is
>> installed on F:\ (NOT C:). I choose default on the
>> installation because that is all it gave me, could not
>> type in. The installation went through and restarted
>> machine. MDAC got updated, but @.@.version in sql still
>> gives me 8.00.534.
>> Looks like databases have a updated modified date on
them
>> bu they all say old version. Where did my update go?
Any
>> files I can check for? Did it install it on C:'
>> Please help!
>
>.
>
installed on F:\ (NOT C:). I choose default on the
installation because that is all it gave me, could not
type in. The installation went through and restarted
machine. MDAC got updated, but @.@.version in sql still
gives me 8.00.534.
Looks like databases have a updated modified date on them
bu they all say old version. Where did my update go? Any
files I can check for? Did it install it on C:'
Please help!Look for *.out files. If there are none, run the installation again with
the verbose logging option on (see the readme file for running setup from a
command line to change switches.)
"Kada" <kadahoffman@.hotmail.com> wrote in message
news:01a901c37faa$e952c730$a301280a@.phx.gbl...
> Ran the sp3a (setup.bat) on server from G:\ then MSSQL is
> installed on F:\ (NOT C:). I choose default on the
> installation because that is all it gave me, could not
> type in. The installation went through and restarted
> machine. MDAC got updated, but @.@.version in sql still
> gives me 8.00.534.
> Looks like databases have a updated modified date on them
> bu they all say old version. Where did my update go? Any
> files I can check for? Did it install it on C:'
> Please help!|||Do you mean if I do not see something called sp3_repl.out
and sp3_serv_uni.out? Or what Out files should I see?
Thanks!
>--Original Message--
>Look for *.out files. If there are none, run the
installation again with
>the verbose logging option on (see the readme file for
running setup from a
>command line to change switches.)
>
>
>"Kada" <kadahoffman@.hotmail.com> wrote in message
>news:01a901c37faa$e952c730$a301280a@.phx.gbl...
>> Ran the sp3a (setup.bat) on server from G:\ then MSSQL
is
>> installed on F:\ (NOT C:). I choose default on the
>> installation because that is all it gave me, could not
>> type in. The installation went through and restarted
>> machine. MDAC got updated, but @.@.version in sql still
>> gives me 8.00.534.
>> Looks like databases have a updated modified date on
them
>> bu they all say old version. Where did my update go?
Any
>> files I can check for? Did it install it on C:'
>> Please help!
>
>.
>
Installatuin Problems
Hi
I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
(pending CD from retailer)
During the installation it tested for prerequisites and has thrown message
saying IIS is not installed or neither configured for rs.
But when I open .net report wizard etc are working fine. I can preview
report in .net
again Problem is when i tried to deploy it , it is saying reporting server
is not available.
I unistalled it and again checked while installing
I found the following:
again same problem related to IIS. ( I checked again ASP.NET ETC are
installed properly)
while installing it is not showing server componets and Report manager. It
is just showing client components. Does'nt eval edit have reporting server.
I dont know what to do at this
ANY HELP
Thanks in advance
R.DRS requires IIS with Dotnet 1.1 installed. Something is not right with the
prerequisites on your machine. The install should show the server
components. I used the evaluation edition for a couple of months so I know
for a fact it has everything.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R.D" <RD@.discussions.microsoft.com> wrote in message
news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> Hi
> I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> (pending CD from retailer)
> During the installation it tested for prerequisites and has thrown
> message
> saying IIS is not installed or neither configured for rs.
> But when I open .net report wizard etc are working fine. I can preview
> report in .net
> again Problem is when i tried to deploy it , it is saying reporting server
> is not available.
> I unistalled it and again checked while installing
> I found the following:
> again same problem related to IIS. ( I checked again ASP.NET ETC are
> installed properly)
> while installing it is not showing server componets and Report manager. It
> is just showing client components. Does'nt eval edit have reporting
> server.
> I dont know what to do at this
> ANY HELP
> Thanks in advance
> R.D
>|||Bruce,
I checked all, .net 2003 is installed, still problem persists.
Should I unistall IIS server and install again with all pre-requisites.
R.D
"Bruce L-C [MVP]" wrote:
> RS requires IIS with Dotnet 1.1 installed. Something is not right with the
> prerequisites on your machine. The install should show the server
> components. I used the evaluation edition for a couple of months so I know
> for a fact it has everything.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > Hi
> >
> > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> >
> > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > (pending CD from retailer)
> >
> > During the installation it tested for prerequisites and has thrown
> > message
> > saying IIS is not installed or neither configured for rs.
> >
> > But when I open .net report wizard etc are working fine. I can preview
> > report in .net
> >
> > again Problem is when i tried to deploy it , it is saying reporting server
> > is not available.
> >
> > I unistalled it and again checked while installing
> >
> > I found the following:
> >
> > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > installed properly)
> >
> > while installing it is not showing server componets and Report manager. It
> > is just showing client components. Does'nt eval edit have reporting
> > server.
> >
> > I dont know what to do at this
> >
> > ANY HELP
> >
> > Thanks in advance
> >
> > R.D
> >
> >
>
>|||Not sure what is happening for you. I have installed on 3 different machines
and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
pro I had to add IIS to the machine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R.D" <RD@.discussions.microsoft.com> wrote in message
news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> Bruce,
> I checked all, .net 2003 is installed, still problem persists.
> Should I unistall IIS server and install again with all pre-requisites.
> R.D
>
>
> "Bruce L-C [MVP]" wrote:
> > RS requires IIS with Dotnet 1.1 installed. Something is not right with
the
> > prerequisites on your machine. The install should show the server
> > components. I used the evaluation edition for a couple of months so I
know
> > for a fact it has everything.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > Hi
> > >
> > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > >
> > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > (pending CD from retailer)
> > >
> > > During the installation it tested for prerequisites and has thrown
> > > message
> > > saying IIS is not installed or neither configured for rs.
> > >
> > > But when I open .net report wizard etc are working fine. I can preview
> > > report in .net
> > >
> > > again Problem is when i tried to deploy it , it is saying reporting
server
> > > is not available.
> > >
> > > I unistalled it and again checked while installing
> > >
> > > I found the following:
> > >
> > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > installed properly)
> > >
> > > while installing it is not showing server componets and Report
manager. It
> > > is just showing client components. Does'nt eval edit have reporting
> > > server.
> > >
> > > I dont know what to do at this
> > >
> > > ANY HELP
> > >
> > > Thanks in advance
> > >
> > > R.D
> > >
> > >
> >
> >
> >|||I just had a thought. RS installs on the default website. Did you by any
chance remove the default website?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eIvKuPK$EHA.2568@.TK2MSFTNGP10.phx.gbl...
> Not sure what is happening for you. I have installed on 3 different
machines
> and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
> pro I had to add IIS to the machine.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> > Bruce,
> >
> > I checked all, .net 2003 is installed, still problem persists.
> >
> > Should I unistall IIS server and install again with all pre-requisites.
> >
> > R.D
> >
> >
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > RS requires IIS with Dotnet 1.1 installed. Something is not right with
> the
> > > prerequisites on your machine. The install should show the server
> > > components. I used the evaluation edition for a couple of months so I
> know
> > > for a fact it has everything.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > > Hi
> > > >
> > > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > > >
> > > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > > (pending CD from retailer)
> > > >
> > > > During the installation it tested for prerequisites and has thrown
> > > > message
> > > > saying IIS is not installed or neither configured for rs.
> > > >
> > > > But when I open .net report wizard etc are working fine. I can
preview
> > > > report in .net
> > > >
> > > > again Problem is when i tried to deploy it , it is saying reporting
> server
> > > > is not available.
> > > >
> > > > I unistalled it and again checked while installing
> > > >
> > > > I found the following:
> > > >
> > > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > > installed properly)
> > > >
> > > > while installing it is not showing server componets and Report
> manager. It
> > > > is just showing client components. Does'nt eval edit have reporting
> > > > server.
> > > >
> > > > I dont know what to do at this
> > > >
> > > > ANY HELP
> > > >
> > > > Thanks in advance
> > > >
> > > > R.D
> > > >
> > > >
> > >
> > >
> > >
>|||Bruce
Actually I unistalled IIS and installed again . Now I can see serve componets.
It is working fine.
Is there any way to store snapshots automatically to database instead of a
folder.
Thanks
R.D
"Bruce L-C [MVP]" wrote:
> Not sure what is happening for you. I have installed on 3 different machines
> and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
> pro I had to add IIS to the machine.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> > Bruce,
> >
> > I checked all, .net 2003 is installed, still problem persists.
> >
> > Should I unistall IIS server and install again with all pre-requisites.
> >
> > R.D
> >
> >
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > RS requires IIS with Dotnet 1.1 installed. Something is not right with
> the
> > > prerequisites on your machine. The install should show the server
> > > components. I used the evaluation edition for a couple of months so I
> know
> > > for a fact it has everything.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > > Hi
> > > >
> > > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > > >
> > > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > > (pending CD from retailer)
> > > >
> > > > During the installation it tested for prerequisites and has thrown
> > > > message
> > > > saying IIS is not installed or neither configured for rs.
> > > >
> > > > But when I open .net report wizard etc are working fine. I can preview
> > > > report in .net
> > > >
> > > > again Problem is when i tried to deploy it , it is saying reporting
> server
> > > > is not available.
> > > >
> > > > I unistalled it and again checked while installing
> > > >
> > > > I found the following:
> > > >
> > > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > > installed properly)
> > > >
> > > > while installing it is not showing server componets and Report
> manager. It
> > > > is just showing client components. Does'nt eval edit have reporting
> > > > server.
> > > >
> > > > I dont know what to do at this
> > > >
> > > > ANY HELP
> > > >
> > > > Thanks in advance
> > > >
> > > > R.D
> > > >
> > > >
> > >
> > >
> > >
>
>
I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
(pending CD from retailer)
During the installation it tested for prerequisites and has thrown message
saying IIS is not installed or neither configured for rs.
But when I open .net report wizard etc are working fine. I can preview
report in .net
again Problem is when i tried to deploy it , it is saying reporting server
is not available.
I unistalled it and again checked while installing
I found the following:
again same problem related to IIS. ( I checked again ASP.NET ETC are
installed properly)
while installing it is not showing server componets and Report manager. It
is just showing client components. Does'nt eval edit have reporting server.
I dont know what to do at this
ANY HELP
Thanks in advance
R.DRS requires IIS with Dotnet 1.1 installed. Something is not right with the
prerequisites on your machine. The install should show the server
components. I used the evaluation edition for a couple of months so I know
for a fact it has everything.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R.D" <RD@.discussions.microsoft.com> wrote in message
news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> Hi
> I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> (pending CD from retailer)
> During the installation it tested for prerequisites and has thrown
> message
> saying IIS is not installed or neither configured for rs.
> But when I open .net report wizard etc are working fine. I can preview
> report in .net
> again Problem is when i tried to deploy it , it is saying reporting server
> is not available.
> I unistalled it and again checked while installing
> I found the following:
> again same problem related to IIS. ( I checked again ASP.NET ETC are
> installed properly)
> while installing it is not showing server componets and Report manager. It
> is just showing client components. Does'nt eval edit have reporting
> server.
> I dont know what to do at this
> ANY HELP
> Thanks in advance
> R.D
>|||Bruce,
I checked all, .net 2003 is installed, still problem persists.
Should I unistall IIS server and install again with all pre-requisites.
R.D
"Bruce L-C [MVP]" wrote:
> RS requires IIS with Dotnet 1.1 installed. Something is not right with the
> prerequisites on your machine. The install should show the server
> components. I used the evaluation edition for a couple of months so I know
> for a fact it has everything.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > Hi
> >
> > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> >
> > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > (pending CD from retailer)
> >
> > During the installation it tested for prerequisites and has thrown
> > message
> > saying IIS is not installed or neither configured for rs.
> >
> > But when I open .net report wizard etc are working fine. I can preview
> > report in .net
> >
> > again Problem is when i tried to deploy it , it is saying reporting server
> > is not available.
> >
> > I unistalled it and again checked while installing
> >
> > I found the following:
> >
> > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > installed properly)
> >
> > while installing it is not showing server componets and Report manager. It
> > is just showing client components. Does'nt eval edit have reporting
> > server.
> >
> > I dont know what to do at this
> >
> > ANY HELP
> >
> > Thanks in advance
> >
> > R.D
> >
> >
>
>|||Not sure what is happening for you. I have installed on 3 different machines
and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
pro I had to add IIS to the machine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R.D" <RD@.discussions.microsoft.com> wrote in message
news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> Bruce,
> I checked all, .net 2003 is installed, still problem persists.
> Should I unistall IIS server and install again with all pre-requisites.
> R.D
>
>
> "Bruce L-C [MVP]" wrote:
> > RS requires IIS with Dotnet 1.1 installed. Something is not right with
the
> > prerequisites on your machine. The install should show the server
> > components. I used the evaluation edition for a couple of months so I
know
> > for a fact it has everything.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > Hi
> > >
> > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > >
> > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > (pending CD from retailer)
> > >
> > > During the installation it tested for prerequisites and has thrown
> > > message
> > > saying IIS is not installed or neither configured for rs.
> > >
> > > But when I open .net report wizard etc are working fine. I can preview
> > > report in .net
> > >
> > > again Problem is when i tried to deploy it , it is saying reporting
server
> > > is not available.
> > >
> > > I unistalled it and again checked while installing
> > >
> > > I found the following:
> > >
> > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > installed properly)
> > >
> > > while installing it is not showing server componets and Report
manager. It
> > > is just showing client components. Does'nt eval edit have reporting
> > > server.
> > >
> > > I dont know what to do at this
> > >
> > > ANY HELP
> > >
> > > Thanks in advance
> > >
> > > R.D
> > >
> > >
> >
> >
> >|||I just had a thought. RS installs on the default website. Did you by any
chance remove the default website?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eIvKuPK$EHA.2568@.TK2MSFTNGP10.phx.gbl...
> Not sure what is happening for you. I have installed on 3 different
machines
> and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
> pro I had to add IIS to the machine.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> > Bruce,
> >
> > I checked all, .net 2003 is installed, still problem persists.
> >
> > Should I unistall IIS server and install again with all pre-requisites.
> >
> > R.D
> >
> >
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > RS requires IIS with Dotnet 1.1 installed. Something is not right with
> the
> > > prerequisites on your machine. The install should show the server
> > > components. I used the evaluation edition for a couple of months so I
> know
> > > for a fact it has everything.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > > Hi
> > > >
> > > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > > >
> > > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > > (pending CD from retailer)
> > > >
> > > > During the installation it tested for prerequisites and has thrown
> > > > message
> > > > saying IIS is not installed or neither configured for rs.
> > > >
> > > > But when I open .net report wizard etc are working fine. I can
preview
> > > > report in .net
> > > >
> > > > again Problem is when i tried to deploy it , it is saying reporting
> server
> > > > is not available.
> > > >
> > > > I unistalled it and again checked while installing
> > > >
> > > > I found the following:
> > > >
> > > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > > installed properly)
> > > >
> > > > while installing it is not showing server componets and Report
> manager. It
> > > > is just showing client components. Does'nt eval edit have reporting
> > > > server.
> > > >
> > > > I dont know what to do at this
> > > >
> > > > ANY HELP
> > > >
> > > > Thanks in advance
> > > >
> > > > R.D
> > > >
> > > >
> > >
> > >
> > >
>|||Bruce
Actually I unistalled IIS and installed again . Now I can see serve componets.
It is working fine.
Is there any way to store snapshots automatically to database instead of a
folder.
Thanks
R.D
"Bruce L-C [MVP]" wrote:
> Not sure what is happening for you. I have installed on 3 different machines
> and 2 different OS's (2000 pro and 2003 server) without a problem. On 2000
> pro I had to add IIS to the machine.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "R.D" <RD@.discussions.microsoft.com> wrote in message
> news:3B3397DB-C791-480F-A262-67583A80BED9@.microsoft.com...
> > Bruce,
> >
> > I checked all, .net 2003 is installed, still problem persists.
> >
> > Should I unistall IIS server and install again with all pre-requisites.
> >
> > R.D
> >
> >
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > RS requires IIS with Dotnet 1.1 installed. Something is not right with
> the
> > > prerequisites on your machine. The install should show the server
> > > components. I used the evaluation edition for a couple of months so I
> know
> > > for a fact it has everything.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "R.D" <RD@.discussions.microsoft.com> wrote in message
> > > news:5A6D40FB-16D6-4DC8-94E4-FEFC10628F46@.microsoft.com...
> > > > Hi
> > > >
> > > > I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003
> > > >
> > > > I tried to install SQL SERVER REPORTING EVAL downloded from MS site.
> > > > (pending CD from retailer)
> > > >
> > > > During the installation it tested for prerequisites and has thrown
> > > > message
> > > > saying IIS is not installed or neither configured for rs.
> > > >
> > > > But when I open .net report wizard etc are working fine. I can preview
> > > > report in .net
> > > >
> > > > again Problem is when i tried to deploy it , it is saying reporting
> server
> > > > is not available.
> > > >
> > > > I unistalled it and again checked while installing
> > > >
> > > > I found the following:
> > > >
> > > > again same problem related to IIS. ( I checked again ASP.NET ETC are
> > > > installed properly)
> > > >
> > > > while installing it is not showing server componets and Report
> manager. It
> > > > is just showing client components. Does'nt eval edit have reporting
> > > > server.
> > > >
> > > > I dont know what to do at this
> > > >
> > > > ANY HELP
> > > >
> > > > Thanks in advance
> > > >
> > > > R.D
> > > >
> > > >
> > >
> > >
> > >
>
>
Friday, March 9, 2012
Installation of SQL sp3a on Windows 2003 ent Failover Clustering
Platform: Windows 2003 ent failover cluster SQL Server 2k ent
We did installation of SQL Server 2k ent successfully. We are using Mixed
mode which allow both NT and SQL authentication. We assigned sa password. We
are able to start/stop/start SQL servrices. We are able to failover to
another node on SQL server. Right after completed SQL Server 2k ent
installation, we started to apply SP3a. But we got error in middle of serivce
pack: Setup was unable to verify the state of the server for an upgrade.
Verify the server is able to start and that you provide a valid sa password
and restart setup. We followed the instruction on article ID 330022 and
readme come with CD but it still doesn't work.
I also referenced the article http://support.microsoft.com/?id=814844 but
they are not really applied to our case. Our platform is on WINDOWS 2003.
We are implementing Failover Clustering. Our MDAC is 2.8 version above. We
didn't have any problem to install sql sp3a on any other win2k or win2k3 ent
platform. Only this time is Windows 2003 ent FAILOVER CLUSTERING.
Look at
PRB: Installation of a named instance of SQL Server 2000 virtual server on a
Windows 2003-based cluster fails
http://support.microsoft.com/default...b;en-us;815431
The aliases have to stay in place until SP3a is complete.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:4CDB4730-44F5-4EFC-9F5F-030CAF9A9101@.microsoft.com...
> Platform: Windows 2003 ent failover cluster SQL Server 2k ent
> We did installation of SQL Server 2k ent successfully. We are using Mixed
> mode which allow both NT and SQL authentication. We assigned sa password.
We
> are able to start/stop/start SQL servrices. We are able to failover to
> another node on SQL server. Right after completed SQL Server 2k ent
> installation, we started to apply SP3a. But we got error in middle of
serivce
> pack: Setup was unable to verify the state of the server for an upgrade.
> Verify the server is able to start and that you provide a valid sa
password
> and restart setup. We followed the instruction on article ID 330022 and
> readme come with CD but it still doesn't work.
> I also referenced the article http://support.microsoft.com/?id=814844 but
> they are not really applied to our case. Our platform is on WINDOWS 2003.
> We are implementing Failover Clustering. Our MDAC is 2.8 version above.
We
> didn't have any problem to install sql sp3a on any other win2k or win2k3
ent
> platform. Only this time is Windows 2003 ent FAILOVER CLUSTERING.
>
We did installation of SQL Server 2k ent successfully. We are using Mixed
mode which allow both NT and SQL authentication. We assigned sa password. We
are able to start/stop/start SQL servrices. We are able to failover to
another node on SQL server. Right after completed SQL Server 2k ent
installation, we started to apply SP3a. But we got error in middle of serivce
pack: Setup was unable to verify the state of the server for an upgrade.
Verify the server is able to start and that you provide a valid sa password
and restart setup. We followed the instruction on article ID 330022 and
readme come with CD but it still doesn't work.
I also referenced the article http://support.microsoft.com/?id=814844 but
they are not really applied to our case. Our platform is on WINDOWS 2003.
We are implementing Failover Clustering. Our MDAC is 2.8 version above. We
didn't have any problem to install sql sp3a on any other win2k or win2k3 ent
platform. Only this time is Windows 2003 ent FAILOVER CLUSTERING.
Look at
PRB: Installation of a named instance of SQL Server 2000 virtual server on a
Windows 2003-based cluster fails
http://support.microsoft.com/default...b;en-us;815431
The aliases have to stay in place until SP3a is complete.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:4CDB4730-44F5-4EFC-9F5F-030CAF9A9101@.microsoft.com...
> Platform: Windows 2003 ent failover cluster SQL Server 2k ent
> We did installation of SQL Server 2k ent successfully. We are using Mixed
> mode which allow both NT and SQL authentication. We assigned sa password.
We
> are able to start/stop/start SQL servrices. We are able to failover to
> another node on SQL server. Right after completed SQL Server 2k ent
> installation, we started to apply SP3a. But we got error in middle of
serivce
> pack: Setup was unable to verify the state of the server for an upgrade.
> Verify the server is able to start and that you provide a valid sa
password
> and restart setup. We followed the instruction on article ID 330022 and
> readme come with CD but it still doesn't work.
> I also referenced the article http://support.microsoft.com/?id=814844 but
> they are not really applied to our case. Our platform is on WINDOWS 2003.
> We are implementing Failover Clustering. Our MDAC is 2.8 version above.
We
> didn't have any problem to install sql sp3a on any other win2k or win2k3
ent
> platform. Only this time is Windows 2003 ent FAILOVER CLUSTERING.
>
Wednesday, March 7, 2012
Installation of MSDE after Microsoft BCM or Microsoft CRM
Hi,
I'm having some problems getting MSDE (SP3a) to install on machines that
already have BCM or CRM installed. The installation rolls back when it nears
the end. I have searched for an answer to this but cannot seem to find one
anywhere. If the install happens the other way round (i.e. MSDE first then
BCM which installs it's own instance) then there is no problem. Am I missing
a particular switch to make this work?
Thanks in advance for your help.
hi,
Joel wrote:
> Hi,
> I'm having some problems getting MSDE (SP3a) to install on machines
> that already have BCM or CRM installed. The installation rolls back
> when it nears the end. I have searched for an answer to this but
> cannot seem to find one anywhere. If the install happens the other
> way round (i.e. MSDE first then BCM which installs it's own instance)
> then there is no problem. Am I missing a particular switch to make
> this work?
> Thanks in advance for your help.
try adding the
/L*v "c:\MsdeLog.txt"
parameter to the setup.exe paramenter collections, in order to enable
verbose logging of the installation process...
you can then inspect the resulting text file for
RETURN VALUE 3
entries, indicating troubles, and about 10/15 lines befor each entry some
(sometime cryptic) description of the problem will be reported..
Andrea Montanari
http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
The file reads as follows(part of the file around the Return Value 3):
MSI (s) (4C:9C) [08:07:51:599]: Executing op:
ActionStart(Name=InstallServices,Description=Insta lling new
services,Template=Service: [2])
MSI (s) (4C:9C) [08:07:51:619]: Executing op:
ProgressTotal(Total=2,Type=1,ByteEquivalent=130000 0)
MSI (s) (4C:9C) [08:07:51:659]: Executing op:
ServiceInstall(Name=SQLSERVERAGENT,DisplayName=SQL SERVERAGENT,ImagePath=C:\Program
Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.EXE -i
MSSQLSERVER,ServiceType=16,StartType=3,ErrorContro l=1,,Dependencies=MSSQLSERVER[~][~],,,,)
MSI (s) (4C:9C) [08:07:52:080]: Executing op:
ServiceInstall(Name=MSSQLSERVER,DisplayName=MSSQLS ERVER,ImagePath=C:\Program
Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
-sMSSQLSERVER,ServiceType=16,StartType=2,ErrorContr ol=1,,,,,,)
MSI (s) (4C:9C) [08:07:52:521]: Executing op:
ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:52:541]: Executing op:
CustomActionSchedule(Action=InstallPerfMon.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=InstallPerfMon,)
MSI (s) (4C:30) [08:07:52:561]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3B4.tmp, Entrypoint: InstallPerfMon
Loading extended custom action library sqlcax.dll
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
MSI (s) (4C:9C) [08:07:54:273]: Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:54:283]: Executing op:
CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (4C:9C) [08:07:54:293]: Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:54:293]: Executing op:
CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
MSI (s) (4C:78) [08:07:54:313]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3B9.tmp, Entrypoint: InstallSQLAgentSecurity
Loading extended custom action library sqlcax.dll
Starting custom action InstallSQLAgentSecurity
LoadLibrary failed for C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\SEMNT.DLL. GetLastError() returned: 126
Action ended 08:07:55: InstallFinalize. Return value 3.
MSI (s) (4C:9C) [08:07:55:245]: User policy value 'DisableRollback' is 0
MSI (s) (4C:9C) [08:07:55:245]: Machine policy value 'DisableRollback' is 0
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
Header(Signature=1397708873,Version=301,Timestamp= 860242137,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
MSI (s) (4C:9C) [08:07:55:275]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing backup files,CleanupTemplate=File: [1])
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
RegisterBackupFile(File=C:\Config.Msi\3893374.rbf)
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
RegisterBackupFile(File=C:\Config.Msi\3893375.rbf)
MSI (s) (4C:9C) [08:07:55:285]: Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:55:285]: Executing op:
ProductInfo(ProductKey={689404D2-1C94-44B3-9203-BEC5594FDA7A},ProductName=Microsoft
SQL Server Desktop
Engine,PackageName=SqlRun02.msi,Language=1033,Vers ion=134217922,Assignment=1,ObsoleteArg=0,,PackageM ediaPath=\x86\SQL2000\MSDE\Setup\,PackageCode={4A8 9EFF5-10ED-4A32-8252-6EA09B952643},,,InstanceType=0,LUASetting=0,Remote URTInstalls=0)
MSI (s) (4C:9C) [08:07:55:295]: Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:55:295]: Executing op:
CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (4C:E8) [08:07:55:315]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3BC.tmp, Entrypoint: UnInstSQLAgentSecurity
Loading extended custom action library sqlcax.dll
"Andrea Montanari" wrote:
> hi,
> Joel wrote:
> try adding the
> /L*v "c:\MsdeLog.txt"
> parameter to the setup.exe paramenter collections, in order to enable
> verbose logging of the installation process...
> you can then inspect the resulting text file for
> RETURN VALUE 3
> entries, indicating troubles, and about 10/15 lines befor each entry some
> (sometime cryptic) description of the problem will be reported..
> --
> Andrea Montanari
> http://www.asql.biz/DbaMgr.shtm
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||Oh and the server service is running, I have checked that already from
previous posts.
"Joel" wrote:
[vbcol=seagreen]
> Hi Andrea,
> The file reads as follows(part of the file around the Return Value 3):
> MSI (s) (4C:9C) [08:07:51:599]: Executing op:
> ActionStart(Name=InstallServices,Description=Insta lling new
> services,Template=Service: [2])
> MSI (s) (4C:9C) [08:07:51:619]: Executing op:
> ProgressTotal(Total=2,Type=1,ByteEquivalent=130000 0)
> MSI (s) (4C:9C) [08:07:51:659]: Executing op:
> ServiceInstall(Name=SQLSERVERAGENT,DisplayName=SQL SERVERAGENT,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.EXE -i
> MSSQLSERVER,ServiceType=16,StartType=3,ErrorContro l=1,,Dependencies=MSSQLSERVER[~][~],,,,)
> MSI (s) (4C:9C) [08:07:52:080]: Executing op:
> ServiceInstall(Name=MSSQLSERVER,DisplayName=MSSQLS ERVER,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
> -sMSSQLSERVER,ServiceType=16,StartType=2,ErrorContr ol=1,,,,,,)
> MSI (s) (4C:9C) [08:07:52:521]: Executing op:
> ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:52:541]: Executing op:
> CustomActionSchedule(Action=InstallPerfMon.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=InstallPerfMon,)
> MSI (s) (4C:30) [08:07:52:561]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B4.tmp, Entrypoint: InstallPerfMon
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> MSI (s) (4C:9C) [08:07:54:273]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:283]: Executing op:
> CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
> MSI (s) (4C:78) [08:07:54:313]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B9.tmp, Entrypoint: InstallSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallSQLAgentSecurity
> LoadLibrary failed for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SEMNT.DLL. GetLastError() returned: 126
> Action ended 08:07:55: InstallFinalize. Return value 3.
> MSI (s) (4C:9C) [08:07:55:245]: User policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:245]: Machine policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> Header(Signature=1397708873,Version=301,Timestamp= 860242137,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op: DialogInfo(Type=0,Argument=1033)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
> action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing backup files,CleanupTemplate=File: [1])
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893374.rbf)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893375.rbf)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ProductInfo(ProductKey={689404D2-1C94-44B3-9203-BEC5594FDA7A},ProductName=Microsoft
> SQL Server Desktop
> Engine,PackageName=SqlRun02.msi,Language=1033,Vers ion=134217922,Assignment=1,ObsoleteArg=0,,PackageM ediaPath=\x86\SQL2000\MSDE\Setup\,PackageCode={4A8 9EFF5-10ED-4A32-8252-6EA09B952643},,,InstanceType=0,LUASetting=0,Remote URTInstalls=0)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:E8) [08:07:55:315]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3BC.tmp, Entrypoint: UnInstSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
>
> "Andrea Montanari" wrote:
|||I think I have found the workaround from the following KB article, BUG: MSDE
Installation Fails on Systems That Have SQL Server 2000 Service Pack 1 or 2
Installed:
http://support.microsoft.com/default...b;en-us;299351
This has allowed me to install successfully.
"Joel" wrote:
[vbcol=seagreen]
> Hi Andrea,
> The file reads as follows(part of the file around the Return Value 3):
> MSI (s) (4C:9C) [08:07:51:599]: Executing op:
> ActionStart(Name=InstallServices,Description=Insta lling new
> services,Template=Service: [2])
> MSI (s) (4C:9C) [08:07:51:619]: Executing op:
> ProgressTotal(Total=2,Type=1,ByteEquivalent=130000 0)
> MSI (s) (4C:9C) [08:07:51:659]: Executing op:
> ServiceInstall(Name=SQLSERVERAGENT,DisplayName=SQL SERVERAGENT,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.EXE -i
> MSSQLSERVER,ServiceType=16,StartType=3,ErrorContro l=1,,Dependencies=MSSQLSERVER[~][~],,,,)
> MSI (s) (4C:9C) [08:07:52:080]: Executing op:
> ServiceInstall(Name=MSSQLSERVER,DisplayName=MSSQLS ERVER,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
> -sMSSQLSERVER,ServiceType=16,StartType=2,ErrorContr ol=1,,,,,,)
> MSI (s) (4C:9C) [08:07:52:521]: Executing op:
> ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:52:541]: Executing op:
> CustomActionSchedule(Action=InstallPerfMon.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=InstallPerfMon,)
> MSI (s) (4C:30) [08:07:52:561]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B4.tmp, Entrypoint: InstallPerfMon
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> MSI (s) (4C:9C) [08:07:54:273]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:283]: Executing op:
> CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
> MSI (s) (4C:78) [08:07:54:313]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B9.tmp, Entrypoint: InstallSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallSQLAgentSecurity
> LoadLibrary failed for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SEMNT.DLL. GetLastError() returned: 126
> Action ended 08:07:55: InstallFinalize. Return value 3.
> MSI (s) (4C:9C) [08:07:55:245]: User policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:245]: Machine policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> Header(Signature=1397708873,Version=301,Timestamp= 860242137,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op: DialogInfo(Type=0,Argument=1033)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
> action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing backup files,CleanupTemplate=File: [1])
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893374.rbf)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893375.rbf)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ProductInfo(ProductKey={689404D2-1C94-44B3-9203-BEC5594FDA7A},ProductName=Microsoft
> SQL Server Desktop
> Engine,PackageName=SqlRun02.msi,Language=1033,Vers ion=134217922,Assignment=1,ObsoleteArg=0,,PackageM ediaPath=\x86\SQL2000\MSDE\Setup\,PackageCode={4A8 9EFF5-10ED-4A32-8252-6EA09B952643},,,InstanceType=0,LUASetting=0,Remote URTInstalls=0)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:E8) [08:07:55:315]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3BC.tmp, Entrypoint: UnInstSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
>
> "Andrea Montanari" wrote:
I'm having some problems getting MSDE (SP3a) to install on machines that
already have BCM or CRM installed. The installation rolls back when it nears
the end. I have searched for an answer to this but cannot seem to find one
anywhere. If the install happens the other way round (i.e. MSDE first then
BCM which installs it's own instance) then there is no problem. Am I missing
a particular switch to make this work?
Thanks in advance for your help.
hi,
Joel wrote:
> Hi,
> I'm having some problems getting MSDE (SP3a) to install on machines
> that already have BCM or CRM installed. The installation rolls back
> when it nears the end. I have searched for an answer to this but
> cannot seem to find one anywhere. If the install happens the other
> way round (i.e. MSDE first then BCM which installs it's own instance)
> then there is no problem. Am I missing a particular switch to make
> this work?
> Thanks in advance for your help.
try adding the
/L*v "c:\MsdeLog.txt"
parameter to the setup.exe paramenter collections, in order to enable
verbose logging of the installation process...
you can then inspect the resulting text file for
RETURN VALUE 3
entries, indicating troubles, and about 10/15 lines befor each entry some
(sometime cryptic) description of the problem will be reported..
Andrea Montanari
http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
The file reads as follows(part of the file around the Return Value 3):
MSI (s) (4C:9C) [08:07:51:599]: Executing op:
ActionStart(Name=InstallServices,Description=Insta lling new
services,Template=Service: [2])
MSI (s) (4C:9C) [08:07:51:619]: Executing op:
ProgressTotal(Total=2,Type=1,ByteEquivalent=130000 0)
MSI (s) (4C:9C) [08:07:51:659]: Executing op:
ServiceInstall(Name=SQLSERVERAGENT,DisplayName=SQL SERVERAGENT,ImagePath=C:\Program
Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.EXE -i
MSSQLSERVER,ServiceType=16,StartType=3,ErrorContro l=1,,Dependencies=MSSQLSERVER[~][~],,,,)
MSI (s) (4C:9C) [08:07:52:080]: Executing op:
ServiceInstall(Name=MSSQLSERVER,DisplayName=MSSQLS ERVER,ImagePath=C:\Program
Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
-sMSSQLSERVER,ServiceType=16,StartType=2,ErrorContr ol=1,,,,,,)
MSI (s) (4C:9C) [08:07:52:521]: Executing op:
ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:52:541]: Executing op:
CustomActionSchedule(Action=InstallPerfMon.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=InstallPerfMon,)
MSI (s) (4C:30) [08:07:52:561]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3B4.tmp, Entrypoint: InstallPerfMon
Loading extended custom action library sqlcax.dll
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
MSI (s) (4C:9C) [08:07:54:273]: Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:54:283]: Executing op:
CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (4C:9C) [08:07:54:293]: Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:54:293]: Executing op:
CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
MSI (s) (4C:78) [08:07:54:313]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3B9.tmp, Entrypoint: InstallSQLAgentSecurity
Loading extended custom action library sqlcax.dll
Starting custom action InstallSQLAgentSecurity
LoadLibrary failed for C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\SEMNT.DLL. GetLastError() returned: 126
Action ended 08:07:55: InstallFinalize. Return value 3.
MSI (s) (4C:9C) [08:07:55:245]: User policy value 'DisableRollback' is 0
MSI (s) (4C:9C) [08:07:55:245]: Machine policy value 'DisableRollback' is 0
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
Header(Signature=1397708873,Version=301,Timestamp= 860242137,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
MSI (s) (4C:9C) [08:07:55:275]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing backup files,CleanupTemplate=File: [1])
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
RegisterBackupFile(File=C:\Config.Msi\3893374.rbf)
MSI (s) (4C:9C) [08:07:55:275]: Executing op:
RegisterBackupFile(File=C:\Config.Msi\3893375.rbf)
MSI (s) (4C:9C) [08:07:55:285]: Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:55:285]: Executing op:
ProductInfo(ProductKey={689404D2-1C94-44B3-9203-BEC5594FDA7A},ProductName=Microsoft
SQL Server Desktop
Engine,PackageName=SqlRun02.msi,Language=1033,Vers ion=134217922,Assignment=1,ObsoleteArg=0,,PackageM ediaPath=\x86\SQL2000\MSDE\Setup\,PackageCode={4A8 9EFF5-10ED-4A32-8252-6EA09B952643},,,InstanceType=0,LUASetting=0,Remote URTInstalls=0)
MSI (s) (4C:9C) [08:07:55:295]: Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (4C:9C) [08:07:55:295]: Executing op:
CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (4C:E8) [08:07:55:315]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3BC.tmp, Entrypoint: UnInstSQLAgentSecurity
Loading extended custom action library sqlcax.dll
"Andrea Montanari" wrote:
> hi,
> Joel wrote:
> try adding the
> /L*v "c:\MsdeLog.txt"
> parameter to the setup.exe paramenter collections, in order to enable
> verbose logging of the installation process...
> you can then inspect the resulting text file for
> RETURN VALUE 3
> entries, indicating troubles, and about 10/15 lines befor each entry some
> (sometime cryptic) description of the problem will be reported..
> --
> Andrea Montanari
> http://www.asql.biz/DbaMgr.shtm
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||Oh and the server service is running, I have checked that already from
previous posts.
"Joel" wrote:
[vbcol=seagreen]
> Hi Andrea,
> The file reads as follows(part of the file around the Return Value 3):
> MSI (s) (4C:9C) [08:07:51:599]: Executing op:
> ActionStart(Name=InstallServices,Description=Insta lling new
> services,Template=Service: [2])
> MSI (s) (4C:9C) [08:07:51:619]: Executing op:
> ProgressTotal(Total=2,Type=1,ByteEquivalent=130000 0)
> MSI (s) (4C:9C) [08:07:51:659]: Executing op:
> ServiceInstall(Name=SQLSERVERAGENT,DisplayName=SQL SERVERAGENT,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.EXE -i
> MSSQLSERVER,ServiceType=16,StartType=3,ErrorContro l=1,,Dependencies=MSSQLSERVER[~][~],,,,)
> MSI (s) (4C:9C) [08:07:52:080]: Executing op:
> ServiceInstall(Name=MSSQLSERVER,DisplayName=MSSQLS ERVER,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
> -sMSSQLSERVER,ServiceType=16,StartType=2,ErrorContr ol=1,,,,,,)
> MSI (s) (4C:9C) [08:07:52:521]: Executing op:
> ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:52:541]: Executing op:
> CustomActionSchedule(Action=InstallPerfMon.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=InstallPerfMon,)
> MSI (s) (4C:30) [08:07:52:561]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B4.tmp, Entrypoint: InstallPerfMon
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> MSI (s) (4C:9C) [08:07:54:273]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:283]: Executing op:
> CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
> MSI (s) (4C:78) [08:07:54:313]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B9.tmp, Entrypoint: InstallSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallSQLAgentSecurity
> LoadLibrary failed for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SEMNT.DLL. GetLastError() returned: 126
> Action ended 08:07:55: InstallFinalize. Return value 3.
> MSI (s) (4C:9C) [08:07:55:245]: User policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:245]: Machine policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> Header(Signature=1397708873,Version=301,Timestamp= 860242137,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op: DialogInfo(Type=0,Argument=1033)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
> action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing backup files,CleanupTemplate=File: [1])
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893374.rbf)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893375.rbf)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ProductInfo(ProductKey={689404D2-1C94-44B3-9203-BEC5594FDA7A},ProductName=Microsoft
> SQL Server Desktop
> Engine,PackageName=SqlRun02.msi,Language=1033,Vers ion=134217922,Assignment=1,ObsoleteArg=0,,PackageM ediaPath=\x86\SQL2000\MSDE\Setup\,PackageCode={4A8 9EFF5-10ED-4A32-8252-6EA09B952643},,,InstanceType=0,LUASetting=0,Remote URTInstalls=0)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:E8) [08:07:55:315]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3BC.tmp, Entrypoint: UnInstSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
>
> "Andrea Montanari" wrote:
|||I think I have found the workaround from the following KB article, BUG: MSDE
Installation Fails on Systems That Have SQL Server 2000 Service Pack 1 or 2
Installed:
http://support.microsoft.com/default...b;en-us;299351
This has allowed me to install successfully.
"Joel" wrote:
[vbcol=seagreen]
> Hi Andrea,
> The file reads as follows(part of the file around the Return Value 3):
> MSI (s) (4C:9C) [08:07:51:599]: Executing op:
> ActionStart(Name=InstallServices,Description=Insta lling new
> services,Template=Service: [2])
> MSI (s) (4C:9C) [08:07:51:619]: Executing op:
> ProgressTotal(Total=2,Type=1,ByteEquivalent=130000 0)
> MSI (s) (4C:9C) [08:07:51:659]: Executing op:
> ServiceInstall(Name=SQLSERVERAGENT,DisplayName=SQL SERVERAGENT,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.EXE -i
> MSSQLSERVER,ServiceType=16,StartType=3,ErrorContro l=1,,Dependencies=MSSQLSERVER[~][~],,,,)
> MSI (s) (4C:9C) [08:07:52:080]: Executing op:
> ServiceInstall(Name=MSSQLSERVER,DisplayName=MSSQLS ERVER,ImagePath=C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
> -sMSSQLSERVER,ServiceType=16,StartType=2,ErrorContr ol=1,,,,,,)
> MSI (s) (4C:9C) [08:07:52:521]: Executing op:
> ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:52:541]: Executing op:
> CustomActionSchedule(Action=InstallPerfMon.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=InstallPerfMon,)
> MSI (s) (4C:30) [08:07:52:561]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B4.tmp, Entrypoint: InstallPerfMon
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> MSI (s) (4C:9C) [08:07:54:273]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:283]: Executing op:
> CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:54:293]: Executing op:
> CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
> MSI (s) (4C:78) [08:07:54:313]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3B9.tmp, Entrypoint: InstallSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
> Starting custom action InstallSQLAgentSecurity
> LoadLibrary failed for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SEMNT.DLL. GetLastError() returned: 126
> Action ended 08:07:55: InstallFinalize. Return value 3.
> MSI (s) (4C:9C) [08:07:55:245]: User policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:245]: Machine policy value 'DisableRollback' is 0
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> Header(Signature=1397708873,Version=301,Timestamp= 860242137,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op: DialogInfo(Type=0,Argument=1033)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
> action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing backup files,CleanupTemplate=File: [1])
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893374.rbf)
> MSI (s) (4C:9C) [08:07:55:275]: Executing op:
> RegisterBackupFile(File=C:\Config.Msi\3893375.rbf)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:285]: Executing op:
> ProductInfo(ProductKey={689404D2-1C94-44B3-9203-BEC5594FDA7A},ProductName=Microsoft
> SQL Server Desktop
> Engine,PackageName=SqlRun02.msi,Language=1033,Vers ion=134217922,Assignment=1,ObsoleteArg=0,,PackageM ediaPath=\x86\SQL2000\MSDE\Setup\,PackageCode={4A8 9EFF5-10ED-4A32-8252-6EA09B952643},,,InstanceType=0,LUASetting=0,Remote URTInstalls=0)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (4C:9C) [08:07:55:295]: Executing op:
> CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (4C:E8) [08:07:55:315]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI3BC.tmp, Entrypoint: UnInstSQLAgentSecurity
> Loading extended custom action library sqlcax.dll
>
> "Andrea Montanari" wrote:
Friday, February 24, 2012
Installation Issue
I have a test server that is a domain controller.
It is running Windows Server 2003 Enterprise.
Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
I installed Reporting Services successfully.
Due to machine configuration changes, I uninstalled reporting services.
I have not been able to put it back on - its really strange - I get the
dialog box that says it successfully installed the SQL Server Reporting
Services Setup Support Files. When I click the Next button nothing happens.
If I reboot the machine and log back in as Administrator, I get the Error
Report dialog:
SQL Server Setup encountered an error and needed to close.
Of course, I choose "Send" to send the error report.
What I would like to do is generate an install log, to see why it is dying.
Can anyone tell me what command-line switch I can use to pass to the
setup.exe to put the log file, say on the c:\msi.log location?
=-ChrisTry using /lfarmviewcup <filelocation>
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"msnews.microsoft.com" <someone@.someplace.com> wrote in message
news:una7vTIrEHA.376@.TK2MSFTNGP14.phx.gbl...
> I have a test server that is a domain controller.
> It is running Windows Server 2003 Enterprise.
> Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> I installed Reporting Services successfully.
> Due to machine configuration changes, I uninstalled reporting services.
> I have not been able to put it back on - its really strange - I get the
> dialog box that says it successfully installed the SQL Server Reporting
> Services Setup Support Files. When I click the Next button nothing
happens.
> If I reboot the machine and log back in as Administrator, I get the Error
> Report dialog:
> SQL Server Setup encountered an error and needed to close.
> Of course, I choose "Send" to send the error report.
> What I would like to do is generate an install log, to see why it is
dying.
> Can anyone tell me what command-line switch I can use to pass to the
> setup.exe to put the log file, say on the c:\msi.log location?
> =-Chris
>
>|||Thanks for replying Daniel, this did not produce a log file at all.
I used this:
Setup.exe /lfarmviewcup c:\setupmsi.log
Any other suggestions?
=-Chris
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:#VFkTZVrEHA.1296@.TK2MSFTNGP12.phx.gbl...
> Try using /lfarmviewcup <filelocation>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "msnews.microsoft.com" <someone@.someplace.com> wrote in message
> news:una7vTIrEHA.376@.TK2MSFTNGP14.phx.gbl...
> > I have a test server that is a domain controller.
> > It is running Windows Server 2003 Enterprise.
> > Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> >
> > I installed Reporting Services successfully.
> >
> > Due to machine configuration changes, I uninstalled reporting services.
> >
> > I have not been able to put it back on - its really strange - I get the
> > dialog box that says it successfully installed the SQL Server Reporting
> > Services Setup Support Files. When I click the Next button nothing
> happens.
> >
> > If I reboot the machine and log back in as Administrator, I get the
Error
> > Report dialog:
> >
> > SQL Server Setup encountered an error and needed to close.
> >
> > Of course, I choose "Send" to send the error report.
> >
> > What I would like to do is generate an install log, to see why it is
> dying.
> > Can anyone tell me what command-line switch I can use to pass to the
> > setup.exe to put the log file, say on the c:\msi.log location?
> >
> > =-Chris
> >
> >
> >
>
It is running Windows Server 2003 Enterprise.
Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
I installed Reporting Services successfully.
Due to machine configuration changes, I uninstalled reporting services.
I have not been able to put it back on - its really strange - I get the
dialog box that says it successfully installed the SQL Server Reporting
Services Setup Support Files. When I click the Next button nothing happens.
If I reboot the machine and log back in as Administrator, I get the Error
Report dialog:
SQL Server Setup encountered an error and needed to close.
Of course, I choose "Send" to send the error report.
What I would like to do is generate an install log, to see why it is dying.
Can anyone tell me what command-line switch I can use to pass to the
setup.exe to put the log file, say on the c:\msi.log location?
=-ChrisTry using /lfarmviewcup <filelocation>
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"msnews.microsoft.com" <someone@.someplace.com> wrote in message
news:una7vTIrEHA.376@.TK2MSFTNGP14.phx.gbl...
> I have a test server that is a domain controller.
> It is running Windows Server 2003 Enterprise.
> Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> I installed Reporting Services successfully.
> Due to machine configuration changes, I uninstalled reporting services.
> I have not been able to put it back on - its really strange - I get the
> dialog box that says it successfully installed the SQL Server Reporting
> Services Setup Support Files. When I click the Next button nothing
happens.
> If I reboot the machine and log back in as Administrator, I get the Error
> Report dialog:
> SQL Server Setup encountered an error and needed to close.
> Of course, I choose "Send" to send the error report.
> What I would like to do is generate an install log, to see why it is
dying.
> Can anyone tell me what command-line switch I can use to pass to the
> setup.exe to put the log file, say on the c:\msi.log location?
> =-Chris
>
>|||Thanks for replying Daniel, this did not produce a log file at all.
I used this:
Setup.exe /lfarmviewcup c:\setupmsi.log
Any other suggestions?
=-Chris
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:#VFkTZVrEHA.1296@.TK2MSFTNGP12.phx.gbl...
> Try using /lfarmviewcup <filelocation>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "msnews.microsoft.com" <someone@.someplace.com> wrote in message
> news:una7vTIrEHA.376@.TK2MSFTNGP14.phx.gbl...
> > I have a test server that is a domain controller.
> > It is running Windows Server 2003 Enterprise.
> > Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> >
> > I installed Reporting Services successfully.
> >
> > Due to machine configuration changes, I uninstalled reporting services.
> >
> > I have not been able to put it back on - its really strange - I get the
> > dialog box that says it successfully installed the SQL Server Reporting
> > Services Setup Support Files. When I click the Next button nothing
> happens.
> >
> > If I reboot the machine and log back in as Administrator, I get the
Error
> > Report dialog:
> >
> > SQL Server Setup encountered an error and needed to close.
> >
> > Of course, I choose "Send" to send the error report.
> >
> > What I would like to do is generate an install log, to see why it is
> dying.
> > Can anyone tell me what command-line switch I can use to pass to the
> > setup.exe to put the log file, say on the c:\msi.log location?
> >
> > =-Chris
> >
> >
> >
>
Installation Fails -> need sp3a but there's a sp4??
I installed RS developer edition on windows 2000 with sp4.
Also there's SQL 2000 with sp4.
During the installation where missing:
1)VS 2003
2)Authz.dll
I installed it without those things.I download the Authz.dll and add it 2
system32 and Reinstalled the RS but somewhere in the middle there was error
that Reporting services requier sql 2000 with sp3a but i have sp4!!!
What 2 do?well the solution was as expected with microsoft products:
Remove sp4 and install it again.
"ש×?×?×?" wrote:
> I installed RS developer edition on windows 2000 with sp4.
> Also there's SQL 2000 with sp4.
> During the installation where missing:
> 1)VS 2003
> 2)Authz.dll
> I installed it without those things.I download the Authz.dll and add it 2
> system32 and Reinstalled the RS but somewhere in the middle there was error
> that Reporting services requier sql 2000 with sp3a but i have sp4!!!
> What 2 do?
>
Also there's SQL 2000 with sp4.
During the installation where missing:
1)VS 2003
2)Authz.dll
I installed it without those things.I download the Authz.dll and add it 2
system32 and Reinstalled the RS but somewhere in the middle there was error
that Reporting services requier sql 2000 with sp3a but i have sp4!!!
What 2 do?well the solution was as expected with microsoft products:
Remove sp4 and install it again.
"ש×?×?×?" wrote:
> I installed RS developer edition on windows 2000 with sp4.
> Also there's SQL 2000 with sp4.
> During the installation where missing:
> 1)VS 2003
> 2)Authz.dll
> I installed it without those things.I download the Authz.dll and add it 2
> system32 and Reinstalled the RS but somewhere in the middle there was error
> that Reporting services requier sql 2000 with sp3a but i have sp4!!!
> What 2 do?
>
Subscribe to:
Posts (Atom)