Hello all --
I just put up a new web and data server of my very own in a data center (YIPEEE!! No more shared hosting!), and I installed SQL Server 7.0 on the data server.
I installed the Full Text Searching capabilities like a good little programmer, but now when I go make a new full text catalog and populate it, while it appears that everything goes off without a hitch, when you look at the properties of the catalog, it shows:
0 Item Count
0 Mb Size
1 Unique Word Count
And so of course, when I try to use CONTAINS in my queries, the resulting data set is empty.
I have deleted and rebuilt it several times to no avail. So I go into the application logs on the server and here's what I found:
-----------------------------------------
1st:
One or more warnings or errors for Gatherer project <SQLServer SQL0000900005> logged to file <C:\MSSQL7\FTDATA\SQLServer\GatherLogs\SQL0000900005.3.gthr>.
2nd:
Unable to access crawl seed <MSSQL://LOCALHOST/9.276912058> in project <SQLServer SQL0000900005>. Error: 8007052e - Logon failure: unknown user name or bad password.
^^poopoo message since I'm logged on admin account to do the operations^^
3rd:
Unable to start crawl for project <SQLServer SQL0000900005>. No crawl seeds could be accessed.
-------------------------------------
All three are warnings rather than errors.
I've searched MS, but all I can find are references to this troubleshooter thing that is "Currently undergoing maintenance".
This happened to me once before but I was on shared hosting at the time, and so after a few days, I got an email from the SQL Admin at the ISP informing me that everything was ok. I've no idea what he/she did to fix the problem.
Anyway, I'm hoping someone has had this problem before and can help get me moving on it. I'm at a total loss.
Thanks in advance for your advice and help!
Paul Prewett
I just put up a new web and data server of my very own in a data center (YIPEEE!! No more shared hosting!), and I installed SQL Server 7.0 on the data server.
I installed the Full Text Searching capabilities like a good little programmer, but now when I go make a new full text catalog and populate it, while it appears that everything goes off without a hitch, when you look at the properties of the catalog, it shows:
0 Item Count
0 Mb Size
1 Unique Word Count
And so of course, when I try to use CONTAINS in my queries, the resulting data set is empty.
I have deleted and rebuilt it several times to no avail. So I go into the application logs on the server and here's what I found:
-----------------------------------------
1st:
One or more warnings or errors for Gatherer project <SQLServer SQL0000900005> logged to file <C:\MSSQL7\FTDATA\SQLServer\GatherLogs\SQL0000900005.3.gthr>.
2nd:
Unable to access crawl seed <MSSQL://LOCALHOST/9.276912058> in project <SQLServer SQL0000900005>. Error: 8007052e - Logon failure: unknown user name or bad password.
^^poopoo message since I'm logged on admin account to do the operations^^
3rd:
Unable to start crawl for project <SQLServer SQL0000900005>. No crawl seeds could be accessed.
-------------------------------------
All three are warnings rather than errors.
I've searched MS, but all I can find are references to this troubleshooter thing that is "Currently undergoing maintenance".
This happened to me once before but I was on shared hosting at the time, and so after a few days, I got an email from the SQL Admin at the ISP informing me that everything was ok. I've no idea what he/she did to fix the problem.
Anyway, I'm hoping someone has had this problem before and can help get me moving on it. I'm at a total loss.
Thanks in advance for your advice and help!
Paul Prewett