Basics, just the basics, please (BUMP)

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$SHAREPOI NT', '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...;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[vbcol=seagreen]
> 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...
reasons[vbcol=seagreen]
> Dummy's"
is[vbcol=seagreen]
> "full
titles[vbcol=seagreen]
for[vbcol=seagreen]
least[vbcol=seagreen]
> and
> schedule
> that
or[vbcol=seagreen]
and[vbcol=seagreen]
in
> *contributor*)
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
> SQL
> your
> database
> all
up[vbcol=seagreen]
> externally
not[vbcol=seagreen]
14:22:05[vbcol=seagreen]
> Windows
Dummy's?"[vbcol=seagreen]
> is
> how
or
>
Hi Rich,
Not to worry... as I do actively monitor this newsgroup! Is the server
"SVR1" your local machine or a remote server? If it is local, then should be
able to run the follow EXEC from your (local) server when logged into your
(local) SQL Server as administrator or as sa as all it does is read a
registry key on the local server.
EXEC master..xp_regread 'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\Services\MSSQL$SHAREPOIN T', 'ObjectName'
If SVR1 is not your local machine, could you have someone who has direct
access to the remote server run the above SQL code on the remove server?
Note, (s)he too should be admin or have sa access to that server. This is
less an issue of how you are logged on and more an issue of how the
MSSQLServer service on either your local or remote server is started and
what is the account for that service.
Thanks,
John
"RDavid" <r@.c-m.NOSPAMcomm> wrote in message
news:e$6jtwtjEHA.596@.TK2MSFTNGP11.phx.gbl...
> 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[vbcol=seagreen]
> 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
>
>
could[vbcol=seagreen]
please[vbcol=seagreen]
should[vbcol=seagreen]
a[vbcol=seagreen]
> named
> Domain
>
>
> "RDavid" <r@.c-m.NOSPAMcomm> wrote in message
> news:#9vvgTVhEHA.2908@.TK2MSFTNGP10.phx.gbl...
lead.[vbcol=seagreen]
be[vbcol=seagreen]
Indexing...[vbcol=seagreen]
> as
Full-Text[vbcol=seagreen]
> is
> and
> the
as[vbcol=seagreen]
> reasons
> is
> titles
> for
> least
to[vbcol=seagreen]
Manager[vbcol=seagreen]
own[vbcol=seagreen]
FAQ's[vbcol=seagreen]
> or
> and
are[vbcol=seagreen]
Microsoft
> in
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
per[vbcol=seagreen]
both[vbcol=seagreen]
it's[vbcol=seagreen]
ends[vbcol=seagreen]
> up
> not
> 14:22:05
> Dummy's?"
much[vbcol=seagreen]
of[vbcol=seagreen]
> or
and[vbcol=seagreen]
same
>
>
|||Hi John,
I've about had it with this whole mess. I think I'm gonna issue 3x5 index
cards for everyone to just write down information and to heck with SQL
Server.
Okay. The server I've been trying to get FTS running on is about 12 feet
behind me. So I rolled my chair back there and logged off as Administrator
and logged in as myself. When I called Query Analyzer up, it asked for the
connection, so I gave it SVR1/SHAREPOINT and suddenly it just showed me what
it wouldn't show me before. <Grrrrrr>
I ran the EXEC and the response was Data=LocalSystem
So now that I found that out I went to the KB you indicated and read it, and
read it and read it and read it. It makes me think that I might just need a
16 pound sledge hammer instead of only an 8 pound sledge. I guess the
options of dealing with a stored procedure to perform the indexing
(database, table, column, etc) is a matter of review and considerations and
trade offs as far as speed and needs. I need to find the tech-writer for
WSS and have him/her reread the step by step instructions they show to make
FTS work. It isn't any little trivial thing and yet the documentation is
just, 'set this flag and save and voila!' Right, not hardly.
So I need to find out which table/column needs to be searchable and then
plan out which sp_ to use.
Your help has been enormous and I'm very appreciative. I still feel dumb,
but maybe some of this will finally sink in.
Thank you,
Rich
"John Kane" <jt-kane@.comcast.net> wrote in message
news:%23ACDr5tjEHA.3896@.TK2MSFTNGP15.phx.gbl...
> Hi Rich,
> Not to worry... as I do actively monitor this newsgroup! Is the server
> "SVR1" your local machine or a remote server? If it is local, then should
be[vbcol=seagreen]
> able to run the follow EXEC from your (local) server when logged into your
> (local) SQL Server as administrator or as sa as all it does is read a
> registry key on the local server.
> EXEC master..xp_regread 'HKEY_LOCAL_MACHINE',
> 'SYSTEM\CurrentControlSet\Services\MSSQL$SHAREPOIN T', 'ObjectName'
> If SVR1 is not your local machine, could you have someone who has direct
> access to the remote server run the above SQL code on the remove server?
> Note, (s)he too should be admin or have sa access to that server. This is
> less an issue of how you are logged on and more an issue of how the
> MSSQLServer service on either your local or remote server is started and
> what is the account for that service.
> Thanks,
> John
>
>
> "RDavid" <r@.c-m.NOSPAMcomm> wrote in message
> news:e$6jtwtjEHA.596@.TK2MSFTNGP11.phx.gbl...
was[vbcol=seagreen]
> and
> you
will[vbcol=seagreen]
> so
> Analyzer
> could
> please
Not[vbcol=seagreen]
> should
create[vbcol=seagreen]
> a
DOMAIN\Account[vbcol=seagreen]
> lead.
> be
> Indexing...
> Full-Text
(CMSouth[vbcol=seagreen]
Analyzer[vbcol=seagreen]
not[vbcol=seagreen]
> as
start[vbcol=seagreen]
on[vbcol=seagreen]
BOL[vbcol=seagreen]
> to
> Manager
> own
> FAQ's
below)[vbcol=seagreen]
behavior
> are
> Microsoft
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
> per
time?[vbcol=seagreen]
> both
> it's
> ends
or[vbcol=seagreen]
Sharepoint[vbcol=seagreen]
> much
root[vbcol=seagreen]
> of
installed
> and
> same
>
|||You're welcome, Rich,
Yea, I hear you and understand your frustration as I once told an ex-SQL PM,
that troubleshooting FTS is like trying to figure out what's on the other
side of a black hole - as in nothing escapes a black hole, not even light -
so it's very difficult to see what's on the other side of a black hole!
Anyways, the fact that the EXEC returned LocalSystem is a good thing... Now,
what I need to understand is how you have the remote server "registered" in
your SQL Server Enterprise Manager. Are you using the machine name or it's
IP address or an alias for the server?
While KB articles are sometimes not easy to understand (even for me and I
wrote a few of them! ;), the following SharePoint KB article, while not
directly related to SQL Server and SharePoint Portal Server, *might* be
helpful to you...
837367 How to turn on full-text search (FTS) in WSS (SharePoint) on a
Windows SBS 2003-based computer
http://support.microsoft.com/?kbid=837367
823377 (WSS) The database this server is using does not support search When
You Configure Full-Text Search for the Virtual Server
http://support.microsoft.com/default.aspx?kbid=823377
Also, if you have the Windows SharePoint Services 2.0 Administrator's Guide
help (a .chm file), you should also checkout title "Migrating from WMSDE to
SQL Server".
Regards,
John
"RDavid" <r@.c-m.NOSPAMcomm> wrote in message
news:#JjQiBvjEHA.3536@.TK2MSFTNGP12.phx.gbl...
> Hi John,
> I've about had it with this whole mess. I think I'm gonna issue 3x5 index
> cards for everyone to just write down information and to heck with SQL
> Server.
> Okay. The server I've been trying to get FTS running on is about 12 feet
> behind me. So I rolled my chair back there and logged off as Administrator
> and logged in as myself. When I called Query Analyzer up, it asked for the
> connection, so I gave it SVR1/SHAREPOINT and suddenly it just showed me
what
> it wouldn't show me before. <Grrrrrr>
> I ran the EXEC and the response was Data=LocalSystem
> So now that I found that out I went to the KB you indicated and read it,
and
> read it and read it and read it. It makes me think that I might just need
a
> 16 pound sledge hammer instead of only an 8 pound sledge. I guess the
> options of dealing with a stored procedure to perform the indexing
> (database, table, column, etc) is a matter of review and considerations
and
> trade offs as far as speed and needs. I need to find the tech-writer for
> WSS and have him/her reread the step by step instructions they show to
make[vbcol=seagreen]
> FTS work. It isn't any little trivial thing and yet the documentation is
> just, 'set this flag and save and voila!' Right, not hardly.
> So I need to find out which table/column needs to be searchable and then
> plan out which sp_ to use.
> Your help has been enormous and I'm very appreciative. I still feel dumb,
> but maybe some of this will finally sink in.
> Thank you,
> Rich
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:%23ACDr5tjEHA.3896@.TK2MSFTNGP15.phx.gbl...
should[vbcol=seagreen]
> be
your[vbcol=seagreen]
is[vbcol=seagreen]
> was
(local)[vbcol=seagreen]
EXEC...[vbcol=seagreen]
> will
'Administrator'[vbcol=seagreen]
> Not
> create
Server[vbcol=seagreen]
> DOMAIN\Account
would[vbcol=seagreen]
up[vbcol=seagreen]
> (CMSouth
> Analyzer
> not
well[vbcol=seagreen]
for[vbcol=seagreen]
> start
> on
and[vbcol=seagreen]
> BOL
not[vbcol=seagreen]
way[vbcol=seagreen]
the[vbcol=seagreen]
and[vbcol=seagreen]
your[vbcol=seagreen]
> below)
> behavior
issues
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
just[vbcol=seagreen]
(SVR1[vbcol=seagreen]
> time?
that[vbcol=seagreen]
> or
> Sharepoint
on[vbcol=seagreen]
how[vbcol=seagreen]
> root
> installed
the
>
|||John, you have the patience of Jobe.
And the saga continues...
In SQL Mgr a right click on the servers shows:
SVR1\SHAREPOINT
Server: SVR1\SHAREPOINT (combo box is disabled and ellipse is also
disabled)
Connection: Use Windows authentication is checked (Use SQL Server Auth
is NOT checked)
Options: Server Group = SQL Server Group (combo box only shows the one
group)
Display SQL Server in console = Checked
Show system db and objects = Checked
Auto start when connecting = Checked
(LOCAL)
Server: (LOCAL) (combo box is disabled and ellipse is also disabled)
Connection: Use Windows authentication is checked (Use SQL Server Auth
is NOT checked)
Options: Server Group = SQL Server Group (combo box only shows the one
group)
Display SQL Server in console = Checked
Show system db and objects = Checked
Auto start when connecting = Checked
When I click on the Add new registration for server the server I'm working
on (SVR1) is not listed. So the group only has (LOCAL) and SVR1\SHAREPOINT
but not SVR1 by itself.
You asked...
> Are you using the machine name or it's IP address or an alias for the
server?
I think the info above shows this (I think) but, the server name is SVR1 and
the domain name is CPM-South.
Also, I began to read the KB's you noted (thank you) and it seems that in
either case I've got to install SP3A. Well after viewing the webcast (some
of it anyway) on SP3A I'm not so sure that I want to get into that. I mean
there's a whole ton of new and different things any one of which could start
a nuclear meltdown on my SBS2003 server. If I don't do SP3A am I just
simply destined to have this orphan database (SVR1\SHAREPOINT), never to be
usable in either FTS or via Visual Studio? I hate to say this but my
options don't appear all that good.
All your info seems pretty good and I thank you for your help.
Rich
"John Kane" <jt-kane@.comcast.net> wrote in message
news:%235l1KGxjEHA.3624@.TK2MSFTNGP10.phx.gbl...
> You're welcome, Rich,
> Yea, I hear you and understand your frustration as I once told an ex-SQL
PM,
> that troubleshooting FTS is like trying to figure out what's on the other
> side of a black hole - as in nothing escapes a black hole, not even
light -
> so it's very difficult to see what's on the other side of a black hole!
> Anyways, the fact that the EXEC returned LocalSystem is a good thing...
Now,
> what I need to understand is how you have the remote server "registered"
in
> your SQL Server Enterprise Manager. Are you using the machine name or it's
> IP address or an alias for the server?
> While KB articles are sometimes not easy to understand (even for me and I
> wrote a few of them! ;), the following SharePoint KB article, while not
> directly related to SQL Server and SharePoint Portal Server, *might* be
> helpful to you...
> 837367 How to turn on full-text search (FTS) in WSS (SharePoint) on a
> Windows SBS 2003-based computer
> http://support.microsoft.com/?kbid=837367
> 823377 (WSS) The database this server is using does not support search
When
> You Configure Full-Text Search for the Virtual Server
> http://support.microsoft.com/default.aspx?kbid=823377
> Also, if you have the Windows SharePoint Services 2.0 Administrator's
Guide
> help (a .chm file), you should also checkout title "Migrating from WMSDE
to[vbcol=seagreen]
> SQL Server".
> Regards,
> John
>
> "RDavid" <r@.c-m.NOSPAMcomm> wrote in message
> news:#JjQiBvjEHA.3536@.TK2MSFTNGP12.phx.gbl...
index[vbcol=seagreen]
Administrator[vbcol=seagreen]
the[vbcol=seagreen]
> what
> and
need[vbcol=seagreen]
> a
> and
for[vbcol=seagreen]
> make
dumb,[vbcol=seagreen]
> should
> your
direct[vbcol=seagreen]
server?[vbcol=seagreen]
> is
and[vbcol=seagreen]
I[vbcol=seagreen]
> (local)
> EXEC...
it[vbcol=seagreen]
> 'Administrator'
up.[vbcol=seagreen]
(read[vbcol=seagreen]
the[vbcol=seagreen]
instance[vbcol=seagreen]
this[vbcol=seagreen]
so,[vbcol=seagreen]
Are[vbcol=seagreen]
You[vbcol=seagreen]
> Server
the[vbcol=seagreen]
the[vbcol=seagreen]
> would
> up
and[vbcol=seagreen]
> well
<G>[vbcol=seagreen]
various[vbcol=seagreen]
> for
search[vbcol=seagreen]
under[vbcol=seagreen]
> and
the[vbcol=seagreen]
> not
> way
> the
> and
> your
either
> issues
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
> just
> (SVR1
for[vbcol=seagreen]
server's[vbcol=seagreen]
> that
it[vbcol=seagreen]
something[vbcol=seagreen]
working[vbcol=seagreen]
2002[vbcol=seagreen]
Edition[vbcol=seagreen]
> on
> how
NT)
> the
>