| Groups | Blog | Home |
sql server full text search : 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 [quoted text, click to view] >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 ;-)) [quoted text, click to view] "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
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$SHAREPOINT', '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 [quoted text, click to view] "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 > 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
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 [quoted text, click to view] "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 > 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$SHAREPOINT', '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 > > 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
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 [quoted text, click to view] "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 > 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 > > 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$SHAREPOINT', '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 > > > 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: > > > >
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... [quoted text, click to view] > 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 [quoted text, click to view] "John Kane" <jt-kane@comcast.net> wrote in message itnews:%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 > 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 > > 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 > > > 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$SHAREPOINT', '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,
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |