Basics, just the basics, please (BUMP)
From: RDavid (r_at_c-m.NOSPAMcomm)
Date: 08/30/04
- Next message: John Kane: "Re: Basics, just the basics, please (BUMP)"
- Previous message: John Kane: "Re: Newbie rank order confusion"
- Next in thread: John Kane: "Re: Basics, just the basics, please (BUMP)"
- Reply: John Kane: "Re: Basics, just the basics, please (BUMP)"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 30 Aug 2004 14:59:29 -0700
John,
I've bumped this up because I have been so busy on other things that I was
afraid that it would get lost in the other messages....
On my SQL Server, as I had mentioned, I have two Server Groups: (local) and
SVR1/SHAREPOINT. When I try to use the SQL Analyzer to run the EXEC... you
wanted me to run, I cannot "see" the SVR1/SHAREPOINT server group, it will
only allow me to see the (local) one. I'm logging in as 'Administrator' so
I assumed that I should have access to everything. But in the SQL Analyzer
I can't get to it, but in the Enterprise Manager both groups show up.
Oh great guru, what words of wisdom can you impart on this lowly (read
'helpless'), but trying, IT worker?
Thanks for your help,
Rich
>You're welcome, Rich !
>Under your SHAREPOINT named instance of SQL Server, could you run the
>following code and post the result?
>
>EXEC master..xp_regread 'HKEY_LOCAL_MACHINE',
>'SYSTEM\CurrentControlSet\Services\MSSQL$SHAREPOINT', 'ObjectName'
>go
>
>The output Data should be the exact account that this named instance
>(SHAREPOINT) is running under. If it is a local Windows account, this could
>explain why the Full-Text Indexing menu items are grayed out. If so, please
>review KB article Q270671 (Q270671) "PRB: Full Text Search Menus Are Not
>Enabled for Local Windows NT Accounts" at:
>http://support.microsoft.com/default.aspx?scid=KB;en-us;q270671 You should
>test using the system stored procs sp_fulltext_* to see if you can create a
>FT Catalog and run a Full Population. If you can change the SQL Server
named
>instance (SHAREPOINT) startup account to a new or existing DOMAIN\Account
>that is a member of the server's Admin. Group, and not the DOMAIN
>Administrator account (I'm assuming that CMSouth\Administrator is the
Domain
>Admin account) that could solve this issue too.
>
>Thanks,
>John "Genius" Kane ;-))
"RDavid" <r@c-m.NOSPAMcomm> wrote in message
news:#9vvgTVhEHA.2908@TK2MSFTNGP10.phx.gbl...
> John,
>
> Thanks for your reply. I've got some reading to do, thanks for the lead.
>
> On the other issue I raised, regarding whether or not two groups would be
> handled as one, you indicated that both would need to have FTS set up
> through the wizard for FTS to take effect.
>
> The two groups I have are like this:
>
> Microsoft SQL Servers
> SQL Server Group
> (LOCAL) (Windows NT)
> (SVR1\SHAREPOINT) (Windows NT)
>
> When I highlight the LOCAL one, I get (under Tools) Full-Text Indexing...
as
> an enabled choice. But when I highlight the SHAREPOINT one, the Full-Text
> Indexing... is greyed out.
>
> I checked under Security on both and then Logins and both have
> BUILTIN\Administrators (group) and CMSouth\Administrator (user) (CMSouth
is
> the domain name of SVR1). Along with an 'sa' for both.
>
> Is there something I'm missing here? When I go into the Query Analyzer
and
> it prompts for the server to connect to, it only offers "local" and not
the
> SHAREPOINT database group.
>
> I would appreciate any light you might shed on this.
>
> Rich
>
> PS: And yes, I did say genius. Anyone who can understand this as well as
> you deserves that label.
>
>
>
>
>
>
> "John Kane" <jt-kane@comcast.net> wrote in message
> news:unU3fPMhEHA.3664@TK2MSFTNGP11.phx.gbl...
> > Rich,
> > Well, thank you! I've not been called a "genius" in sometime! <G>
> > Unfortunately, books on this subject have been delayed for various
reasons
> > (I'm writing one), so for now there is no "SQL Full-Text Search for
> Dummy's"
> > (yet), but look for one soon! In the meantime, the best place to start
is
> > SQL Server 2000 Books online (BOL) using the search tab and search on
> "full
> > text search" using the double quotes. The basics are covered under
titles
> > "Full-Text Query Architecture", "Full-Text Catalogs and Indexes" and
> > "Full-text Querying SQL Server Data". Also, you should review the BOL
for
> > CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE and last but not
least
> > "Full-Text Search Recommendations". Mostly, the best and easiest way to
> > FT-enable the database as well as table and columns is to launch the
> > Full-Text Indexing Wizard (sqlftwiz.exe) from the SQL Enterprise Manager
> and
> > it will prompt you through all the steps necessary to FT-enable and
> schedule
> > a Full Population for you or you can run a Full Population at your own
> > convience.
> >
> > Yes, there are problems with SQL FTS, but mainly these are either FAQ's
> that
> > currently are not documented in KB articles (see a list of KB's below)
or
> > are bugs or differences due to OS platforms, i.e., difference behavior
and
> > results between Win2K and Win2003. Additionally, many SQL FTS issues are
> > related to either performance or scalability issues and lack of
> > customization. FYI, many of these bugs are being addressed by Microsoft
in
> > the next release of SQL Server 2005 (codename Yukon).
> >
> > You should also review the FTS Deployment whitepaper (I was a
> *contributor*)
> > and how to enable at:
> >
>
http://support.microsoft.com/default.aspx?scid=/support/sql/content/2000papers/fts_white%20paper.asp#enable
> >
> >
> > Q. And does the FTS get set for ALL of SQL that's installed or just per
> SQL
> > Server Group? I have two groups; (LOCAL) (Windows NT) and (SVR1
> > SHAREPOINT) (Windows NT), would they both be handled at the same time?
> > A. Yes and no... Specifically, FTS is installed and functional for both
> your
> > local and SVR1 SHAREPOINT (named instance), however, each server's
> database
> > must be FT-enabled separately via the FT Indexing Wizard.
> >
> > Hope that helps!
> > John
> >
> >
> >
> >
> >
> > "RDavid" <r@c-m.NOSPAMcomm> wrote in message
> > news:eRVef2JhEHA.3272@TK2MSFTNGP11.phx.gbl...
> > > Hello you geniuses,
> > >
> > > I've read so many articles in here about full-text searching that it's
> all
> > > beginning to slip out of my ears.
> > >
> > > Most everyone seems to have gotten something working but then it ends
up
> > > with problems or issues when configurations change or something
> externally
> > > effects it. As for me, I don't know if I have something working or
not
> > and
> > > would just like to get the FTS working as part of Windows Sharepoint
> > > Services (WSS).
> > >
> > > SELECT @@version:
> > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
14:22:05
> > > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on
> Windows
> > > NT 5.2 (Build 3790: )
> > >
> > > SELECT @@language:
> > > us_english
> > >
> > > OS: SBS2003 DC
> > >
> > > Is there someplace that has a "SQL Full-Text Search Setup for
Dummy's?"
> > like
> > > paper, so I can follow by the numbers rather than ponder just how much
> is
> > > done and not done or jump in and out without understanding the root of
> how
> > > FTS works? And does the FTS get set for ALL of SQL that's installed
or
> > just
> > > per SQL Server Group? I have two groups; (LOCAL) (Windows NT) and
> > > (SVR1 SHAREPOINT) (Windows NT), would they both be handled at the same
> > time?
> > >
> > > Any help would be appreciated by this addled brained IT guy,
> > >
> > > Rich
> > >
> > >
> >
> >
>
>
- Next message: John Kane: "Re: Basics, just the basics, please (BUMP)"
- Previous message: John Kane: "Re: Newbie rank order confusion"
- Next in thread: John Kane: "Re: Basics, just the basics, please (BUMP)"
- Reply: John Kane: "Re: Basics, just the basics, please (BUMP)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
