64-bit problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 17 Nov 2004 16:18 GMT

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

Reply to this Message

John Kane - 17 Nov 2004 16:36 GMT

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

> Hi,
>
[quoted text clipped - 15 lines]
>
> Mike

Reply to this Message

Mike Metcalf - 19 Nov 2004 11:23 GMT

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

Reply to this Message

John Kane - 23 Nov 2004 06:53 GMT

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

> Hi John,
>
[quoted text clipped - 10 lines]
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Reply to this Message