install replication components on cluster

Hi,
At the SQL Server cluster installation time I haven't choose the replication component(wasn't required at that time). Now it is and when I run again the setup to modify the installation and to add the replication components it doesn't give me that option.
The only option that I have is to uninstall the SQL Server.
Is it what is suppose to be? If yes how can I install the replication components?
Cata,
replication isn't enabled from the setup. If you use EM, and go to tools,
replication, configure publishing... you can set it up there.
Regards,
Paul Ibison
|||Thanks for your replay.
At the setup time when you install the SQL Server one is
asked if he wants to install the Replication components -
so there are some components that have to be installed. I
haven't choose that option.
Additionally when I am choosing to configure replication
EM - Tools - Cofigure Publishing, I get the message "The
Replication components were not included when SQL Server
was installed on <server>"

>--Original Message--
>Cata,
>replication isn't enabled from the setup. If you use EM,
and go to tools,
>replication, configure publishing... you can set it up
there.
>Regards,
>Paul Ibison
>
>.
>
|||My apologies - I had selected this checkbox without thinking when I installed, which was a while ago. I'm out of the office for a while but if no-one else answers in the next few days then I'll try on a test cluster I have built back at work. I suspect yo
u'll have to break the cluster then add the components, but I'll have a look.
Regards,
Paul Ibison

Install issues under IIS6

Hello,
I ran the installer on a windows 2000/ iis5 server and no issues at all, the
server components were available during setup (trial version downloaded from
MS).
I subsequently tried the same thing on a Windows 2003 / IIS6 server and it
says IIS is not properly configured but it does not tell me what
specifically is the problem. IIS works fine on the server, i have over 10
sites hosted and it is working fine.
My guess is there must be a security/permission problem?
Anybody else have issues running the Report Services installer on an IIS6
machine?
PLEASE HELP! :)
thanks in advance,
-ZDRS will not install if you are running IIS 6 in IIS 5 compatibility mode.
You should check that first. If that is not the case then look in the
rsspt<#>.log file, search for prereq and there should be a line in there
telling you what check is failing.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Z D" <NOSPAM@.NOSPAM.com> wrote in message
news:O1wrZhUVEHA.2336@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I ran the installer on a windows 2000/ iis5 server and no issues at all,
the
> server components were available during setup (trial version downloaded
from
> MS).
> I subsequently tried the same thing on a Windows 2003 / IIS6 server and it
> says IIS is not properly configured but it does not tell me what
> specifically is the problem. IIS works fine on the server, i have over 10
> sites hosted and it is working fine.
> My guess is there must be a security/permission problem?
> Anybody else have issues running the Report Services installer on an IIS6
> machine?
> PLEASE HELP! :)
> thanks in advance,
> -ZD
>|||Daniel,
Thanks for your reply. :)
IIS6 is NOT running in IIS5 compat mode.
I am unable to find the rsspt*.log file anywhere on my webserver. Do you
know which directory it's supposed to be in? When exactly is it created? (I
cancel out of the install after I get the warning message saying IIS is not
installed/configured for a server component installation).
Thanks,
-ZD
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23$ETx9VVEHA.2752@.TK2MSFTNGP10.phx.gbl...
> RS will not install if you are running IIS 6 in IIS 5 compatibility mode.
> You should check that first. If that is not the case then look in the
> rsspt<#>.log file, search for prereq and there should be a line in there
> telling you what check is failing.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Z D" <NOSPAM@.NOSPAM.com> wrote in message
> news:O1wrZhUVEHA.2336@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I ran the installer on a windows 2000/ iis5 server and no issues at all,
> the
> > server components were available during setup (trial version downloaded
> from
> > MS).
> >
> > I subsequently tried the same thing on a Windows 2003 / IIS6 server and
it
> > says IIS is not properly configured but it does not tell me what
> > specifically is the problem. IIS works fine on the server, i have over
10
> > sites hosted and it is working fine.
> >
> > My guess is there must be a security/permission problem?
> >
> > Anybody else have issues running the Report Services installer on an
IIS6
> > machine?
> >
> > PLEASE HELP! :)
> >
> > thanks in advance,
> > -ZD
> >
> >
>|||Hi Daniel, thanks for your reply.
I finally found the file, it was named rsstp<#>.log (not rsspt<#>.log).
Anyways, below is the relevant portion of the log that is failing. It seems
as though its looking for W3SVC #1 ' Is that the default website? I deleted
that when I originally configured IIS, but I do have another site from which
the server can be accessed through http://localhost and http://<serverName>
Any ideas?
Thanks
-ZD
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Prerequisite Name="IsIISInstalled" Checked="Metabase"
Item="/LM/W3SVC/1/1016" Found="Can not read value" Expected="No error"
Result="Fail" />
Machine = WWW01, Article = IIS, Result = 60350 (0xebbe)
<Prerequisite Name="IsVS71Installed" Checked="Registry"
Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1" Found="Can not open key"
Expected="No error" Result="Fail" />
Machine = WWW01, Article = VSNET, Result = 60351 (0xebbf)
Machine = WWW01, Article = ASPNET, Result = 0 (0x0)
Machine = WWW01, Article = MDAC, Result = 0 (0x0)
Machine = WWW01, Article = DTC, Result = 0 (0x0)
Machine = WWW01, Article = SERVEROS, Result = 0 (0x0)
Machine = WWW01, Article = SHAREPOINT, Result = 0 (0x0)
Machine = WWW01, Article = AUTHZ, Result = 0 (0x0)
Machine = WWW01, Article = RSACCOUNTS, Result = 0 (0x0)
**************
WWW01
**************
Report Server component requirement
<B>Explanation:</B> Internet Information Services 5.0 (IIS) or later is
either not installed, or it is configured in a way that is incompatible with
a Reporting Services installation.
<B>Action:</B> To install the Report Server and Report Manager components,
you must first install Internet Information Services 5.0 (IIS) or later, and
then verify that the Web server configuration requirements are compatible
with Setup. Check the Setup documentation for more information about Web
server configuration requirements.
Report Designer component requirement
<B>Explanation:</B> Visual Studio .NET 2003 is not installed.
<B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to
install Report Designer. Or, continue Setup to complete the installation
without Report Designer.
Report size = 1050
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23$ETx9VVEHA.2752@.TK2MSFTNGP10.phx.gbl...
> RS will not install if you are running IIS 6 in IIS 5 compatibility mode.
> You should check that first. If that is not the case then look in the
> rsspt<#>.log file, search for prereq and there should be a line in there
> telling you what check is failing.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Z D" <NOSPAM@.NOSPAM.com> wrote in message
> news:O1wrZhUVEHA.2336@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I ran the installer on a windows 2000/ iis5 server and no issues at all,
> the
> > server components were available during setup (trial version downloaded
> from
> > MS).
> >
> > I subsequently tried the same thing on a Windows 2003 / IIS6 server and
it
> > says IIS is not properly configured but it does not tell me what
> > specifically is the problem. IIS works fine on the server, i have over
10
> > sites hosted and it is working fine.
> >
> > My guess is there must be a security/permission problem?
> >
> > Anybody else have issues running the Report Services installer on an
IIS6
> > machine?
> >
> > PLEASE HELP! :)
> >
> > thanks in advance,
> > -ZD
> >
> >
>|||RS setup only supports installing to the default website. Unfortunately
there is no way to change this. After the install the vdirs can be moved
using the following instructions:
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Z D" <NOSPAM@.NOSPAM.com> wrote in message
news:eWA$JcIWEHA.2972@.TK2MSFTNGP12.phx.gbl...
> Hi Daniel, thanks for your reply.
> I finally found the file, it was named rsstp<#>.log (not rsspt<#>.log).
> Anyways, below is the relevant portion of the log that is failing. It
seems
> as though its looking for W3SVC #1 ' Is that the default website? I
deleted
> that when I originally configured IIS, but I do have another site from
which
> the server can be accessed through http://localhost and
http://<serverName>
> Any ideas?
> Thanks
> -ZD
>
> <EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
> <Prerequisite Name="IsIISInstalled" Checked="Metabase"
> Item="/LM/W3SVC/1/1016" Found="Can not read value" Expected="No error"
> Result="Fail" />
> Machine = WWW01, Article = IIS, Result = 60350 (0xebbe)
> <Prerequisite Name="IsVS71Installed" Checked="Registry"
> Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1" Found="Can not open key"
> Expected="No error" Result="Fail" />
> Machine = WWW01, Article = VSNET, Result = 60351 (0xebbf)
> Machine = WWW01, Article = ASPNET, Result = 0 (0x0)
> Machine = WWW01, Article = MDAC, Result = 0 (0x0)
> Machine = WWW01, Article = DTC, Result = 0 (0x0)
> Machine = WWW01, Article = SERVEROS, Result = 0 (0x0)
> Machine = WWW01, Article = SHAREPOINT, Result = 0 (0x0)
> Machine = WWW01, Article = AUTHZ, Result = 0 (0x0)
> Machine = WWW01, Article = RSACCOUNTS, Result = 0 (0x0)
> **************
> WWW01
> **************
> Report Server component requirement
> <B>Explanation:</B> Internet Information Services 5.0 (IIS) or later is
> either not installed, or it is configured in a way that is incompatible
with
> a Reporting Services installation.
> <B>Action:</B> To install the Report Server and Report Manager components,
> you must first install Internet Information Services 5.0 (IIS) or later,
and
> then verify that the Web server configuration requirements are compatible
> with Setup. Check the Setup documentation for more information about Web
> server configuration requirements.
> Report Designer component requirement
> <B>Explanation:</B> Visual Studio .NET 2003 is not installed.
> <B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to
> install Report Designer. Or, continue Setup to complete the installation
> without Report Designer.
> Report size = 1050
>
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23$ETx9VVEHA.2752@.TK2MSFTNGP10.phx.gbl...
> > RS will not install if you are running IIS 6 in IIS 5 compatibility
mode.
> > You should check that first. If that is not the case then look in the
> > rsspt<#>.log file, search for prereq and there should be a line in there
> > telling you what check is failing.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Z D" <NOSPAM@.NOSPAM.com> wrote in message
> > news:O1wrZhUVEHA.2336@.TK2MSFTNGP12.phx.gbl...
> > > Hello,
> > >
> > > I ran the installer on a windows 2000/ iis5 server and no issues at
all,
> > the
> > > server components were available during setup (trial version
downloaded
> > from
> > > MS).
> > >
> > > I subsequently tried the same thing on a Windows 2003 / IIS6 server
and
> it
> > > says IIS is not properly configured but it does not tell me what
> > > specifically is the problem. IIS works fine on the server, i have
over
> 10
> > > sites hosted and it is working fine.
> > >
> > > My guess is there must be a security/permission problem?
> > >
> > > Anybody else have issues running the Report Services installer on an
> IIS6
> > > machine?
> > >
> > > PLEASE HELP! :)
> > >
> > > thanks in advance,
> > > -ZD
> > >
> > >
> >
> >
>

install intialization error

I am trying to install SQL Server 2000 on my Win2k pc. I double-click the cd, click SQL Server 2000 Components, Install Database Server, then I get an error message:

Error
Setup intialization error.
Error performing inpage operation.

Source: 'D:\x86\setup\...\Binn\Res\1033\purgeset.rll'
Target: 'C:\WINNT\TEMP\SqlSetup\Bin\purgeset.rll'

I tried rebooting, and it still does not work. Any ideas?Which edition of SQL used and is it a server edition of win2K?

Previously I found this error is caused due to bad media, if possible can you copy it to the local disk and try to install.

KBA - http://support.microsoft.com/?kbid=141117 explain about such errors on OS./

install integration service on existing instance

I need to install Integration Service on an existing SQL 2005 instance. Is
it possible add components to an existing instance or do I need to create a
new instance of SQL server?
When you install SSIS on a Server, the service is "stand alone", not bound to
a specific instance. You can install SSIS alone, running the setup and asking
for the installation of the Integration services without install the other
components
Gilberto Zampatti
"Mike" wrote:

> I need to install Integration Service on an existing SQL 2005 instance. Is
> it possible add components to an existing instance or do I need to create a
> new instance of SQL server?
>
>

install integration service on existing instance

I need to install Integration Service on an existing SQL 2005 instance. Is
it possible add components to an existing instance or do I need to create a
new instance of SQL server?When you install SSIS on a Server, the service is "stand alone", not bound t
o
a specific instance. You can install SSIS alone, running the setup and askin
g
for the installation of the Integration services without install the other
components
Gilberto Zampatti
"Mike" wrote:

> I need to install Integration Service on an existing SQL 2005 instance. Is
> it possible add components to an existing instance or do I need to create
a
> new instance of SQL server?
>
>

install integration service on existing instance

I need to install Integration Service on an existing SQL 2005 instance. Is
it possible add components to an existing instance or do I need to create a
new instance of SQL server?When you install SSIS on a Server, the service is "stand alone", not bound to
a specific instance. You can install SSIS alone, running the setup and asking
for the installation of the Integration services without install the other
components
Gilberto Zampatti
"Mike" wrote:
> I need to install Integration Service on an existing SQL 2005 instance. Is
> it possible add components to an existing instance or do I need to create a
> new instance of SQL server?
>
>sql

Install DTS packages on development machine

I would like to install the components I need to develop a SSIS custom component. Is there an SDK or install option for just the visual studio components?

There is no seperate redistributable or SDK for SSIS. There is actually an SDK folder that gets installed, normally C:\Program Files\Microsoft SQL Server\90\SDK which has SSIS related assemblies for referencing, but I am not sure which install option gives you this. I suggest you run setup and select "Integration Services" and also "Workstation Components..."

A nice blog post about installing SSIS and some of the options-

Michael Entin's WebLog : Why do I get "product level is insufficient..." error when I run my SSIS package?
(http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx)

Installation

When trying to install Reporting Services 2000 (Report Manager's server
components) on a Windows Server, the installation does not completely finish.
I use the setup in the first folder on the CD (the default option from
Add/Remove Programs.
Goes through the first part and tells me that installation is complete.
Goes to the screen that tells me I do not have Visual Studio installed on
that box (this is ok because this server is only going to house server
capabilities).
Then it goes to the next installation screen which tell me that installation
may take a few minutes. This screen completes and the message comes up that
I am finished.
The problem is that I never get to the part of the installation that asks
me about security, server\client part installation, etc.
If i try to get to the server's report server, it is not there.
In the start menu, the only shortcut made for RS is books online.
What is being done differently from this installation than past installations?Make sure when you get to the part that shows which things are being
installed that the Server Components are on the list. In prior installs
I know that if the Default WebSite was removed or shut off in IIS then
I wasn't even given the option of installing the Server Components.
If the Server Components are not installed then you won't see the
Report Manager or anything else after the install completes.

Install Database Components SP3a

Hi,
Do I need to know the sa password when I install Database Components for
SP3a? The extracted service pack files is in the directory of the local
computer.
Thanks.Only if you're installing on the SQL Server/MSDE, not for the clients.
"Samuel Yap" <yaphcs@.yahoo.com> wrote in message
news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> Do I need to know the sa password when I install Database Components for
> SP3a? The extracted service pack files is in the directory of the local
> computer.
> Thanks.
>|||Yes, preferably. But any account that has system administrator privileges to
SQL Server should suffice I suppose. "sa" account is safe and sure to have
all the access to the database files for sure.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
http://www.extremeexperts.com
"Samuel Yap" <yaphcs@.yahoo.com> wrote in message
news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> Do I need to know the sa password when I install Database Components for
> SP3a? The extracted service pack files is in the directory of the local
> computer.
> Thanks.
>|||Noted. Thanks.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:eqSUIi0dDHA.3992@.TK2MSFTNGP11.phx.gbl...
> Yes, preferably. But any account that has system administrator privileges
to
> SQL Server should suffice I suppose. "sa" account is safe and sure to have
> all the access to the database files for sure.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD
> http://www.extremeexperts.com
>
> "Samuel Yap" <yaphcs@.yahoo.com> wrote in message
> news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Do I need to know the sa password when I install Database Components for
> > SP3a? The extracted service pack files is in the directory of the local
> > computer.
> >
> > Thanks.
> >
> >
>

Install Components for my OLAP Application on client machine (OWC11, msolap9.0, MSXML 6) - for a

Hi,

i have a problem by installing my application by a customer,

i think some rights should be given for a normal user before he can use my application.

But I don't know where to search:

Where I can look what happens on installing this components:

OWC11, msolap9.0, msxml6 ?

Are there some registry entries written, or are there created some directories?

Is there somewhere a referrence where I can find answers on this questions?

My problem:

Customer has no rights for installing this components,

so i logged on his computer as admin and installed all.

But if I log in later as a normal user, my application doesnt work.

Thank you in advanced for the answers,

Mastroyani

You got to separate installation problems from connectivity or other problems.

To install, many applications require admin rights on the machine. If user running setup is not local machine administrator setup will most likely fail. That what you have seen with your customer.

Once your application is installed, you got to take a look at user permissions.

If you are saying that running as administrator you can run your application and connect to Analysis Server then most likely application has been installed correctly. You need to take a look at what permission your user has to access Anlysis Services.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Install Components for my OLAP Application on client machine (OWC11, msolap9.0, MSXML 6) - for a

Hi,

i have a problem by installing my application by a customer,

i think some rights should be given for a normal user before he can use my application.

But I don't know where to search:

Where I can look what happens on installing this components:

OWC11, msolap9.0, msxml6 ?

Are there some registry entries written, or are there created some directories?

Is there somewhere a referrence where I can find answers on this questions?

My problem:

Customer has no rights for installing this components,

so i logged on his computer as admin and installed all.

But if I log in later as a normal user, my application doesnt work.

Thank you in advanced for the answers,

Mastroyani

You got to separate installation problems from connectivity or other problems.

To install, many applications require admin rights on the machine. If user running setup is not local machine administrator setup will most likely fail. That what you have seen with your customer.

Once your application is installed, you got to take a look at user permissions.

If you are saying that running as administrator you can run your application and connect to Analysis Server then most likely application has been installed correctly. You need to take a look at what permission your user has to access Anlysis Services.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Install Analysis Services SP3

Hi,
I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
When i tried to installed , it gave me this error "An error occurred during
the move data process: -145"
why? please help and guide me on what to do next.
thx,
jessJessica,
Here are few possible issues:
- first of all, don't get mad with this bullet, but check whether you have
AS installed on the computer
- next, you can check the olapsp.log file to see what went wrong
- check the support article at http://www.support.microsoft.com/?id=814462
whether it applies to your case
- I've succeeded to install AS SP3a after this error when I stopped all
unnecessary services.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jessica" <Jessica@.discussions.microsoft.com> wrote in message
news:6EB3D551-0613-436B-8411-D6853C1370A7@.microsoft.com...
> Hi,
> I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
> When i tried to installed , it gave me this error "An error occurred
during
> the move data process: -145"
> why? please help and guide me on what to do next.
> thx,
> jess

Install Analysis Services SP3

Hi,
I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
When i tried to installed , it gave me this error "An error occurred during
the move data process: -145"
why? please help and guide me on what to do next.
thx,
jessJessica,
Here are few possible issues:
- first of all, don't get mad with this bullet, but check whether you have
AS installed on the computer
- next, you can check the olapsp.log file to see what went wrong
- check the support article at http://www.support.microsoft.com/?id=814462
whether it applies to your case
- I've succeeded to install AS SP3a after this error when I stopped all
unnecessary services.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jessica" <Jessica@.discussions.microsoft.com> wrote in message
news:6EB3D551-0613-436B-8411-D6853C1370A7@.microsoft.com...
> Hi,
> I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
> When i tried to installed , it gave me this error "An error occurred
during
> the move data process: -145"
> why? please help and guide me on what to do next.
> thx,
> jess

Install Analysis Services SP3

Hi,
I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
When i tried to installed , it gave me this error "An error occurred during
the move data process: -145"
why? please help and guide me on what to do next.
thx,
jess
Jessica,
Here are few possible issues:
- first of all, don't get mad with this bullet, but check whether you have
AS installed on the computer
- next, you can check the olapsp.log file to see what went wrong
- check the support article at http://www.support.microsoft.com/?id=814462
whether it applies to your case
- I've succeeded to install AS SP3a after this error when I stopped all
unnecessary services.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jessica" <Jessica@.discussions.microsoft.com> wrote in message
news:6EB3D551-0613-436B-8411-D6853C1370A7@.microsoft.com...
> Hi,
> I'm have downloaded database components SP3- SQL2KSP3.exe SP3a.
> When i tried to installed , it gave me this error "An error occurred
during
> the move data process: -145"
> why? please help and guide me on what to do next.
> thx,
> jess