Full Text Search Resource

Can u install FTS later on? I have a clustered env. and due to failure in
registering FTS the entire install is rolling back? so perhaps I can delete
the FTS Resource and install it later...
TIA
Yes, it can be installed later, just like any other component of the SQL
Server 2005 install.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Vai2000" <nospam@.microsoft.com> wrote in message
news:uEsn7dQIGHA.528@.TK2MSFTNGP12.phx.gbl...
> Can u install FTS later on? I have a clustered env. and due to failure in
> registering FTS the entire install is rolling back? so perhaps I can
> delete
> the FTS Resource and install it later...
> TIA
>

full text search in sql server

looks like sharepoint requires i install this.
i don't have much experience with full text search...anything i should watch
out for?
e.g. will is slow down my system as is indexes all the existing databases or
something?
thanks.
This short introduction may help:
http://www.mssql.com.au/kb/html/gmgx...psearch_articl
e_text&@.sa_id=59
"jason" <jason@.discussions.microsoft.com> wrote in message
news:1CF51B1E-376C-4C78-B51D-5DB004D52B92@.microsoft.com...
> looks like sharepoint requires i install this.
> i don't have much experience with full text search...anything i should
watch
> out for?
> e.g. will is slow down my system as is indexes all the existing databases
or
> something?
> thanks.
sql

full text search in sql server

looks like sharepoint requires i install this.
i don't have much experience with full text search...anything i should watch
out for?
e.g. will is slow down my system as is indexes all the existing databases or
something?
thanks.This short introduction may help:
http://www.mssql.com.au/kb/html/gmg...=psearch_articl
e_text&@.sa_id=59
"jason" <jason@.discussions.microsoft.com> wrote in message
news:1CF51B1E-376C-4C78-B51D-5DB004D52B92@.microsoft.com...
> looks like sharepoint requires i install this.
> i don't have much experience with full text search...anything i should
watch
> out for?
> e.g. will is slow down my system as is indexes all the existing databases
or
> something?
> thanks.

full text search in sql server

looks like sharepoint requires i install this.
i don't have much experience with full text search...anything i should watch
out for?
e.g. will is slow down my system as is indexes all the existing databases or
something?
thanks.This short introduction may help:
http://www.mssql.com.au/kb/html/gmgxsl.dll/htmlkb?usexsl=y&sp=psearch_articl
e_text&@.sa_id=59
"jason" <jason@.discussions.microsoft.com> wrote in message
news:1CF51B1E-376C-4C78-B51D-5DB004D52B92@.microsoft.com...
> looks like sharepoint requires i install this.
> i don't have much experience with full text search...anything i should
watch
> out for?
> e.g. will is slow down my system as is indexes all the existing databases
or
> something?
> thanks.

Full Text Search component Problem

Hai
i having Mssql Server 2000. My System OS is Windows xp and Ram 1 Gb

I having Install MS Sql Sever Service Pack 3 in my system. then i
install Full Text Search component

I run this Command

SELECT @.@.VERSION

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack
2)
SELECT SERVERPROPERTY('productversion') return =8.00.760

SELECT SERVERPROPERTY('productlevel')= Return SP3

SELECT SERVERPROPERTY('IsFullTextInstalled') returns: 0
but i run This command i got This Error

EXEC sp_fulltext_database 'enable' returns:

Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
Line 46
Full-Text Search is not installed, or a full-text component cannot
be loaded.

i check the Microsoft Search service in Computer Management,
Microsoft Search servic runing Properly
pls advice me

Try this :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449 This is the page to reinstall Microsoft Search (Full-Text) Service.

Good luck.

Full Text Search component Problem

Hai
i having Mssql Server 2000. My System OS is Windows xp and Ram 1 Gb

I having Install MS Sql Sever Service Pack 3 in my system. then i
install Full Text Search component

I run this Command

SELECT @.@.VERSION

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack
2)
SELECT SERVERPROPERTY('productversion') return =8.00.760

SELECT SERVERPROPERTY('productlevel')= Return SP3

SELECT SERVERPROPERTY('IsFullTextInstalled') returns: 0
but i run This command i got This Error

EXEC sp_fulltext_database 'enable' returns:

Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
Line 46
Full-Text Search is not installed, or a full-text component cannot
be loaded.

i check the Microsoft Search service in Computer Management,
Microsoft Search servic runing Properly
pls advice me

Try this :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449 This is the page to reinstall Microsoft Search (Full-Text) Service.

Good luck.

Full Text Search

I did not install full text search on my server. Now I
think I will need it. I tried to enable it and found out
that I couldn't because it was not installed. I have 2
questions. 1) Do I just need to put in the CD and do a re-
install in order to select the FTS component?
2) What is the impact of installing Full Text Search?
Anything negative, positive? Thanks.
John
1) install from SQL CD. just click on the box.
2) It has big impact on memory and cpu usage. repopulating the catalogs is a
resource consuming process. So you would need to prepare a powerful box for
the sql server install.
"John Bull" <anonymous@.discussions.microsoft.com> wrote in message
news:094f01c49736$bb252b60$a401280a@.phx.gbl...
> I did not install full text search on my server. Now I
> think I will need it. I tried to enable it and found out
> that I couldn't because it was not installed. I have 2
> questions. 1) Do I just need to put in the CD and do a re-
> install in order to select the FTS component?
> 2) What is the impact of installing Full Text Search?
> Anything negative, positive? Thanks.
> John
|||Thank you much.
John

>--Original Message--
>1) install from SQL CD. just click on the box.
>2) It has big impact on memory and cpu usage.
repopulating the catalogs is a
>resource consuming process. So you would need to prepare
a powerful box for
>the sql server install.
>
>"John Bull" <anonymous@.discussions.microsoft.com> wrote
in message[vbcol=seagreen]
>news:094f01c49736$bb252b60$a401280a@.phx.gbl...
out[vbcol=seagreen]
re-
>
>.
>
sql

Full Text Search

I did not install full text search on my server. Now I
think I will need it. I tried to enable it and found out
that I couldn't because it was not installed. I have 2
questions. 1) Do I just need to put in the CD and do a re-
install in order to select the FTS component?
2) What is the impact of installing Full Text Search?
Anything negative, positive? Thanks.
John1) install from SQL CD. just click on the box.
2) It has big impact on memory and cpu usage. repopulating the catalogs is a
resource consuming process. So you would need to prepare a powerful box for
the sql server install.
"John Bull" <anonymous@.discussions.microsoft.com> wrote in message
news:094f01c49736$bb252b60$a401280a@.phx.gbl...
> I did not install full text search on my server. Now I
> think I will need it. I tried to enable it and found out
> that I couldn't because it was not installed. I have 2
> questions. 1) Do I just need to put in the CD and do a re-
> install in order to select the FTS component?
> 2) What is the impact of installing Full Text Search?
> Anything negative, positive? Thanks.
> John|||Thank you much.
John
>--Original Message--
>1) install from SQL CD. just click on the box.
>2) It has big impact on memory and cpu usage.
repopulating the catalogs is a
>resource consuming process. So you would need to prepare
a powerful box for
>the sql server install.
>
>"John Bull" <anonymous@.discussions.microsoft.com> wrote
in message
>news:094f01c49736$bb252b60$a401280a@.phx.gbl...
>> I did not install full text search on my server. Now I
>> think I will need it. I tried to enable it and found
out
>> that I couldn't because it was not installed. I have 2
>> questions. 1) Do I just need to put in the CD and do a
re-
>> install in order to select the FTS component?
>> 2) What is the impact of installing Full Text Search?
>> Anything negative, positive? Thanks.
>> John
>
>.
>

Full Text option install

I have been trying to figure out why my full text menu option is not
working and it seems it is not installed.
I did get a 0 when I did the:
SELECT fulltextserviceproperty('IsFulltextInstalled')
Why wouldn't it be installed? Is it a special option? How do I install it.
Here is the results from select @.@.version
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Thanks,
Tom.It is not selected by default in the setup program. Run setup again and
select the ft index service.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:404A22E4.9090902@.deltanet.com...
> I have been trying to figure out why my full text menu option is not
> working and it seems it is not installed.
> I did get a 0 when I did the:
> SELECT fulltextserviceproperty('IsFulltextInstalled')
> Why wouldn't it be installed? Is it a special option? How do I install
it.
> Here is the results from select @.@.version
> Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
> Nov 27 1998 22:20:07
> Copyright (c) 1988-1998 Microsoft Corporation
> Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
> Thanks,
> Tom.
>|||Tibor Karaszi wrote:
> It is not selected by default in the setup program. Run setup again and
> select the ft index service.
>
Does this have to be run from the CD, or can it be run off the harddisk
with what is already there?
Thanks,
Tom.
>|||Thomas Scheiderich wrote:
> Tibor Karaszi wrote:
>> It is not selected by default in the setup program. Run setup again and
>> select the ft index service.
> Does this have to be run from the CD, or can it be run off the harddisk
> with what is already there?
When I try to load from the CD, it will only allow me to load the full
install (either desktop or standard). There doesn't seem to be a way to
install optional items the way 6.5 did.
> Thanks,
> Tom.
>|||I have an instance named FRESH on my machine. Insert he DVD (correct
edition, of course), Autorun, SQL Server 2000 Components, Install Database
Server. And then I get an option to "Upgrade, remove or add components to an
existing installation". The name of this dialog is "Installation Selection
and the other two options are "Create a new instance..." and "Advanced
options".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:404A2753.2090806@.deltanet.com...
> Tibor Karaszi wrote:
> > It is not selected by default in the setup program. Run setup again and
> > select the ft index service.
> >
> Does this have to be run from the CD, or can it be run off the harddisk
> with what is already there?
> Thanks,
> Tom.
> >
>|||Tibor Karaszi wrote:
> I have an instance named FRESH on my machine. Insert he DVD (correct
> edition, of course), Autorun, SQL Server 2000 Components, Install Database
> Server. And then I get an option to "Upgrade, remove or add components to an
> existing installation". The name of this dialog is "Installation Selection
> and the other two options are "Create a new instance..." and "Advanced
> options".
>
You're right. When I ran the install further, it allows me to install
other options.
But the only other 2 options not chose are development tools and code
samples. Everything else is checked.
So, why isn't full text search not showing? Could it be because on this
machine I only have the desktop version running?
Tom.
>|||Hmm, according to Books Online for SQK2K, FT is supported for Personal
Edition (except for Windows 98). Is there a "Microsoft Search" service on
your machine?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:404AAACA.5090205@.deltanet.com...
> Tibor Karaszi wrote:
> > I have an instance named FRESH on my machine. Insert he DVD (correct
> > edition, of course), Autorun, SQL Server 2000 Components, Install
Database
> > Server. And then I get an option to "Upgrade, remove or add components
to an
> > existing installation". The name of this dialog is "Installation
Selection
> > and the other two options are "Create a new instance..." and "Advanced
> > options".
> >
> You're right. When I ran the install further, it allows me to install
> other options.
> But the only other 2 options not chose are development tools and code
> samples. Everything else is checked.
> So, why isn't full text search not showing? Could it be because on this
> machine I only have the desktop version running?
> Tom.
> >
>|||Tibor Karaszi wrote:
> Hmm, according to Books Online for SQK2K, FT is supported for Personal
> Edition (except for Windows 98). Is there a "Microsoft Search" service on
> your machine?
>
No. There is an indexing service, but that appears to be for something else.
I also have SQL server 7 loaded on my MS2K server as a standard edition
and it doesn't work there, either.
Tom

Full Text option install

I have been trying to figure out why my full text menu option is not
working and it seems it is not installed.
I did get a 0 when I did the:
SELECT fulltextserviceproperty('IsFulltextInsta
lled')
Why wouldn't it be installed? Is it a special option? How do I install it.
Here is the results from select @.@.version
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Thanks,
Tom.It is not selected by default in the setup program. Run setup again and
select the ft index service.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:404A22E4.9090902@.deltanet.com...
> I have been trying to figure out why my full text menu option is not
> working and it seems it is not installed.
> I did get a 0 when I did the:
> SELECT fulltextserviceproperty('IsFulltextInsta
lled')
> Why wouldn't it be installed? Is it a special option? How do I install
it.
> Here is the results from select @.@.version
> Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
> Nov 27 1998 22:20:07
> Copyright (c) 1988-1998 Microsoft Corporation
> Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
> Thanks,
> Tom.
>|||Tibor Karaszi wrote:

> It is not selected by default in the setup program. Run setup again and
> select the ft index service.
>
Does this have to be run from the CD, or can it be run off the harddisk
with what is already there?
Thanks,
Tom.

>|||Thomas Scheiderich wrote:

> Tibor Karaszi wrote:
>
> Does this have to be run from the CD, or can it be run off the harddisk
> with what is already there?
When I try to load from the CD, it will only allow me to load the full
install (either desktop or standard). There doesn't seem to be a way to
install optional items the way 6.5 did.

> Thanks,
> Tom.
>
>|||I have an instance named FRESH on my machine. Insert he DVD (correct
edition, of course), Autorun, SQL Server 2000 Components, Install Database
Server. And then I get an option to "Upgrade, remove or add components to an
existing installation". The name of this dialog is "Installation Selection
and the other two options are "Create a new instance..." and "Advanced
options".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:404A2753.2090806@.deltanet.com...
> Tibor Karaszi wrote:
>
> Does this have to be run from the CD, or can it be run off the harddisk
> with what is already there?
> Thanks,
> Tom.
>
>|||Tibor Karaszi wrote:

> I have an instance named FRESH on my machine. Insert he DVD (correct
> edition, of course), Autorun, SQL Server 2000 Components, Install Database
> Server. And then I get an option to "Upgrade, remove or add components to
an
> existing installation". The name of this dialog is "Installation Selection
> and the other two options are "Create a new instance..." and "Advanced
> options".
>
You're right. When I ran the install further, it allows me to install
other options.
But the only other 2 options not chose are development tools and code
samples. Everything else is checked.
So, why isn't full text search not showing? Could it be because on this
machine I only have the desktop version running?
Tom.

>|||Hmm, according to Books Online for SQK2K, FT is supported for Personal
Edition (except for Windows 98). Is there a "Microsoft Search" service on
your machine?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:404AAACA.5090205@.deltanet.com...
> Tibor Karaszi wrote:
>
Database
to an
Selection
> You're right. When I ran the install further, it allows me to install
> other options.
> But the only other 2 options not chose are development tools and code
> samples. Everything else is checked.
> So, why isn't full text search not showing? Could it be because on this
> machine I only have the desktop version running?
> Tom.
>
>|||Tibor Karaszi wrote:

> Hmm, according to Books Online for SQK2K, FT is supported for Personal
> Edition (except for Windows 98). Is there a "Microsoft Search" service on
> your machine?
>
No. There is an indexing service, but that appears to be for something else
.
I also have SQL server 7 loaded on my MS2K server as a standard edition
and it doesn't work there, either.
Tom

FULL TEXT INDEXING is grayed out-- Is it O/S prob?

My OS is Windows XP Professional 2002, when i'm trying to install the
Server Components for the FULL TEXT INDEXING using the SQL Server
Standard Edition CD, prior to the installation it is giving a message
saying "Microsoft SQL Server 2000 Standard Edition server component is
not supported on this operating system. only client components will be
available for instatllation"
and when i proceed further the "Upgrade, remove or add components to
the SQL Server is grayed out" where as my friend having the same OS and
same SQL Server Edition can add the Service "Microsoft Search Service"
and "Full Text Indexing".
I tried many options but nothing is working out?
what am I suppose to do now ?
can anybody help please?
Thanks in Advance
--@.@.version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
Windows NT 5.1 (Build 2600: Service Pack 2)
Have a look at this - http://www.indexserverfaq.com/tablenotenabled.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"savvy" <johngera@.gmail.com> wrote in message
news:1138275125.260804.40060@.g47g2000cwa.googlegro ups.com...
> My OS is Windows XP Professional 2002, when i'm trying to install the
> Server Components for the FULL TEXT INDEXING using the SQL Server
> Standard Edition CD, prior to the installation it is giving a message
> saying "Microsoft SQL Server 2000 Standard Edition server component is
> not supported on this operating system. only client components will be
> available for instatllation"
> and when i proceed further the "Upgrade, remove or add components to
> the SQL Server is grayed out" where as my friend having the same OS and
> same SQL Server Edition can add the Service "Microsoft Search Service"
> and "Full Text Indexing".
> I tried many options but nothing is working out?
> what am I suppose to do now ?
> can anybody help please?
> Thanks in Advance
> --@.@.version
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
> Windows NT 5.1 (Build 2600: Service Pack 2)
>

Full Install for SP2

I have one production SQL server 2000 with Reporting services SP2 installed
on it. I have a redundent IIS 6.0 just purchased. I went to install RS on
it and point it to the production machine but it won't install because the CD
I have is RS SP1 which isn't compatible with SP2. How can I get my hands on
a Full install of RS SP2 so that I can install it on my new IIS machine?
Thanks,
JohnThere is not a full install with SP2. You have to install and then upgrade
with SP2. SP2 includes all the fixes from SP1.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
news:D8929F90-02FE-4782-AECF-E3028CC5C72F@.microsoft.com...
>I have one production SQL server 2000 with Reporting services SP2 installed
> on it. I have a redundent IIS 6.0 just purchased. I went to install RS
> on
> it and point it to the production machine but it won't install because the
> CD
> I have is RS SP1 which isn't compatible with SP2. How can I get my hands
> on
> a Full install of RS SP2 so that I can install it on my new IIS machine?
> Thanks,
> John
>|||Bruce,
Thanks for your reply. I already have SP2 installed. I am trying to
install Reporting Services on a new IIS machine and it won't let me because I
have a RS SP1 install and that is not compatible with SP2. Are you telling
me the only way to install this on my new machine is to completely uninstall
RS, on my production machine, and then reinstall RS on the new IIS machine?
Do you know if MS is going to come out with a CD soon for a full RS SP2
install? Since SP2 is incompatible with SP1 I can't imagine I'll be the only
one with this problem...
Thanks,
John
"Bruce L-C [MVP]" wrote:
> There is not a full install with SP2. You have to install and then upgrade
> with SP2. SP2 includes all the fixes from SP1.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
> news:D8929F90-02FE-4782-AECF-E3028CC5C72F@.microsoft.com...
> >I have one production SQL server 2000 with Reporting services SP2 installed
> > on it. I have a redundent IIS 6.0 just purchased. I went to install RS
> > on
> > it and point it to the production machine but it won't install because the
> > CD
> > I have is RS SP1 which isn't compatible with SP2. How can I get my hands
> > on
> > a Full install of RS SP2 so that I can install it on my new IIS machine?
> > Thanks,
> > John
> >
>
>|||I'm confused on what you are trying to do. Are you setting up up a web farm?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
news:DB20322D-8C67-43A0-B520-24BF7E80C34B@.microsoft.com...
> Bruce,
> Thanks for your reply. I already have SP2 installed. I am trying to
> install Reporting Services on a new IIS machine and it won't let me
> because I
> have a RS SP1 install and that is not compatible with SP2. Are you
> telling
> me the only way to install this on my new machine is to completely
> uninstall
> RS, on my production machine, and then reinstall RS on the new IIS
> machine?
> Do you know if MS is going to come out with a CD soon for a full RS SP2
> install? Since SP2 is incompatible with SP1 I can't imagine I'll be the
> only
> one with this problem...
> Thanks,
> John
> "Bruce L-C [MVP]" wrote:
>> There is not a full install with SP2. You have to install and then
>> upgrade
>> with SP2. SP2 includes all the fixes from SP1.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
>> news:D8929F90-02FE-4782-AECF-E3028CC5C72F@.microsoft.com...
>> >I have one production SQL server 2000 with Reporting services SP2
>> >installed
>> > on it. I have a redundent IIS 6.0 just purchased. I went to install
>> > RS
>> > on
>> > it and point it to the production machine but it won't install because
>> > the
>> > CD
>> > I have is RS SP1 which isn't compatible with SP2. How can I get my
>> > hands
>> > on
>> > a Full install of RS SP2 so that I can install it on my new IIS
>> > machine?
>> > Thanks,
>> > John
>> >
>>|||I am setting up redundancy. I have a production IIS and SQL server running
RS SP2. I have a redundant SQL server that is getting updates from the
production server using Double-take. I would like to have the production IIS
machine replicate to the backup IIS machine using the same software. In
order to do this I need all the same products and versions on the redundant
server before I set up the replication. Unfortunately I upgraded my
production IIS and SQL to SP2 before I did the original install of RS on my
backup IIS machine. I tried installing RS but it tells me my CD RS version,
SP1, is incompatible with the production SQL version, SP2. I figured it
would be easy enough to just get a CD with a full install, including SP2,
from MS.
"Bruce L-C [MVP]" wrote:
> I'm confused on what you are trying to do. Are you setting up up a web farm?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
> news:DB20322D-8C67-43A0-B520-24BF7E80C34B@.microsoft.com...
> > Bruce,
> > Thanks for your reply. I already have SP2 installed. I am trying to
> > install Reporting Services on a new IIS machine and it won't let me
> > because I
> > have a RS SP1 install and that is not compatible with SP2. Are you
> > telling
> > me the only way to install this on my new machine is to completely
> > uninstall
> > RS, on my production machine, and then reinstall RS on the new IIS
> > machine?
> > Do you know if MS is going to come out with a CD soon for a full RS SP2
> > install? Since SP2 is incompatible with SP1 I can't imagine I'll be the
> > only
> > one with this problem...
> >
> > Thanks,
> > John
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> There is not a full install with SP2. You have to install and then
> >> upgrade
> >> with SP2. SP2 includes all the fixes from SP1.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
> >> news:D8929F90-02FE-4782-AECF-E3028CC5C72F@.microsoft.com...
> >> >I have one production SQL server 2000 with Reporting services SP2
> >> >installed
> >> > on it. I have a redundent IIS 6.0 just purchased. I went to install
> >> > RS
> >> > on
> >> > it and point it to the production machine but it won't install because
> >> > the
> >> > CD
> >> > I have is RS SP1 which isn't compatible with SP2. How can I get my
> >> > hands
> >> > on
> >> > a Full install of RS SP2 so that I can install it on my new IIS
> >> > machine?
> >> > Thanks,
> >> > John
> >> >
> >>
> >>
> >>
>
>|||You might not be the only one but what you are doing is not the normal way
for redundancy (by normal I mean the way the product is designed to provide
redundancy). RS was designed to provide reduncancy by creating a web farm.
All the IIS boxes use the same, single database server (which could have a
redundancy setup). The downside of this is licensing, each box needs to have
an enterprise license. Although this might still be the case with what you
are doing as well. At a minimum today you need 2 licenses. One for your IIS
box and one for your SQL Server box.
I suggesting reading up on how to install and setup a web farm, could be it
would give you ideas on how to move ahead with this.
Off the top of my head one thing you could do is to temporarily have SQL
Server locally on the second box and install RS. Then when done point it
away from being local to the other SQL Server box and remove SQL Server from
the second IIS box. I know this is possible but have not done it myself.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
news:CC7BDAC3-1F73-4848-A0E8-F190068C363B@.microsoft.com...
>I am setting up redundancy. I have a production IIS and SQL server running
> RS SP2. I have a redundant SQL server that is getting updates from the
> production server using Double-take. I would like to have the production
> IIS
> machine replicate to the backup IIS machine using the same software. In
> order to do this I need all the same products and versions on the
> redundant
> server before I set up the replication. Unfortunately I upgraded my
> production IIS and SQL to SP2 before I did the original install of RS on
> my
> backup IIS machine. I tried installing RS but it tells me my CD RS
> version,
> SP1, is incompatible with the production SQL version, SP2. I figured it
> would be easy enough to just get a CD with a full install, including SP2,
> from MS.
> "Bruce L-C [MVP]" wrote:
>> I'm confused on what you are trying to do. Are you setting up up a web
>> farm?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
>> news:DB20322D-8C67-43A0-B520-24BF7E80C34B@.microsoft.com...
>> > Bruce,
>> > Thanks for your reply. I already have SP2 installed. I am trying to
>> > install Reporting Services on a new IIS machine and it won't let me
>> > because I
>> > have a RS SP1 install and that is not compatible with SP2. Are you
>> > telling
>> > me the only way to install this on my new machine is to completely
>> > uninstall
>> > RS, on my production machine, and then reinstall RS on the new IIS
>> > machine?
>> > Do you know if MS is going to come out with a CD soon for a full RS SP2
>> > install? Since SP2 is incompatible with SP1 I can't imagine I'll be
>> > the
>> > only
>> > one with this problem...
>> >
>> > Thanks,
>> > John
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> There is not a full install with SP2. You have to install and then
>> >> upgrade
>> >> with SP2. SP2 includes all the fixes from SP1.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:D8929F90-02FE-4782-AECF-E3028CC5C72F@.microsoft.com...
>> >> >I have one production SQL server 2000 with Reporting services SP2
>> >> >installed
>> >> > on it. I have a redundent IIS 6.0 just purchased. I went to
>> >> > install
>> >> > RS
>> >> > on
>> >> > it and point it to the production machine but it won't install
>> >> > because
>> >> > the
>> >> > CD
>> >> > I have is RS SP1 which isn't compatible with SP2. How can I get my
>> >> > hands
>> >> > on
>> >> > a Full install of RS SP2 so that I can install it on my new IIS
>> >> > machine?
>> >> > Thanks,
>> >> > John
>> >> >
>> >>
>> >>
>> >>
>>

FTS Installation Problem - unavailable in SQL Server

Hello, I have a SQL Server 2000 sp4 server. Trying to install Full-Text
Search. I can see the Microsoft Search service and it shows as started. But
the Full-Text Search option in SEM is 'grayed out'. The FTS system procs
also report that FTS is not available. SQL Server has been stopped/restarted
but still no luck. Is there something else that needs to happen to make SQL
Server 2K see that FTS is installed?
- Thanks,
Chris M.
Does this help?
http://www.indexserverfaq.com/tablenotenabled.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Chris M" <ChrisM@.discussions.microsoft.com> wrote in message
news:C445089B-5F09-40D9-B376-C6F60B669E86@.microsoft.com...
> Hello, I have a SQL Server 2000 sp4 server. Trying to install Full-Text
> Search. I can see the Microsoft Search service and it shows as started.
> But
> the Full-Text Search option in SEM is 'grayed out'. The FTS system procs
> also report that FTS is not available. SQL Server has been
> stopped/restarted
> but still no luck. Is there something else that needs to happen to make
> SQL
> Server 2K see that FTS is installed?
> - Thanks,
> Chris M.