Tuesday, March 6, 2012

64-bit problem

Hi,
I have an issue with a 64-bit clustered installation that I've just
completed, obviously the management tools can run on the itaniums and
I've put them on a 32-bit server on the same LAN.
My problem concerns creating the full-text indexes that I used to have
on a database. In a nutshell the MMC keeps telling me that the
Full-Text Search service must be running in order to do it (and the
MMC icon does show itself as being RED) but when I click on the
properties for it I get the correct response back that it is really
active. Everything to do with Full-Text is greyed out.
I know that I could script it but ideally I'll like to know if there's
some sort of hack available to make this work properly instead.
Thanks in advance for your help,
Mike
Mike,
Can you post the full output from -- SELECT @.@.version -- from your 64-bit
server? I'm assuming you're using the SQL Server 2000 (64-bit) EE version,
but need to confirm this. Additionally, what account ("System
account"/LocalSystem or DOMAIN\account) are you using for the MSSQLServer
account?
I've some experience with 64-bit SQL Server as I did some benchmarking tests
with Unisys at their lab in L.A. and the MSSearch service was functional,
however I didn't have the time to do FTS testing as we were busy testing
64-bit vs. 32-bit performance comparisons.
Since this is a clustered environment, this issue most likely is related to
either what account you have MSSQLServer running under or perhaps an
installation of the FTS components problem.
Thanks,
John
"Mike" <mike.metcalf@.4projects.com> wrote in message
news:678e073d.0411170818.5ae2e5f3@.posting.google.c om...
> Hi,
> I have an issue with a 64-bit clustered installation that I've just
> completed, obviously the management tools can run on the itaniums and
> I've put them on a 32-bit server on the same LAN.
> My problem concerns creating the full-text indexes that I used to have
> on a database. In a nutshell the MMC keeps telling me that the
> Full-Text Search service must be running in order to do it (and the
> MMC icon does show itself as being RED) but when I click on the
> properties for it I get the correct response back that it is really
> active. Everything to do with Full-Text is greyed out.
> I know that I could script it but ideally I'll like to know if there's
> some sort of hack available to make this work properly instead.
> Thanks in advance for your help,
> Mike
|||Hi John,
it turns out that it was just a blip in the installation and wasnt that
much of a one at that.
It's all working properly now and I for one am really impressed with the
performance increase we're getting across the board.
Thanks for helping,
Mike
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You're welcome, Mike,
Sometimes, all it takes to solve a problem, is to either wait long enough
(for it to solve itself) or reboot! :-)
John
"Mike Metcalf" <mike.metcalf@.4projects.com> wrote in message
news:OBPjpoizEHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi John,
> it turns out that it was just a blip in the installation and wasnt that
> much of a one at that.
> It's all working properly now and I for one am really impressed with the
> performance increase we're getting across the board.
> Thanks for helping,
> Mike
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

No comments:

Post a Comment