I am running on Sql Server 2000.
This was set up a couple of weeks ago and ran fine. I came in today and was
looking at some of my asp.net pages and started to get the error:
Execution of a full-text operation failed. The catalog does not exist or is
currently unavailable
I tried just a simple query:
select * from position where Contains(jobDescription,'sales')
and got the same error.
What causes the problem? When I right-click on the table and go the
fulltext menu and wizard, it says it is already set up for FullText
indexing.
Thanks,
Tom
Can you check for any messages in the event log from MSSearch or MSSCI?
You might also want to use the gthrlog.vbs to examine your gatherer logs for
this catalog.
Go to c:\program files\Common files\system\mssearch\bin copy the gthrlog.vbs
to c:\winnt\system32 directory or add the above path to your
path (control panel - system - Environment - user and in the path variable
append the above path in the path value (separate it from the entry before
with a ;).
Click on set, apply and OK. Run path from the command prompt to ensure you
did this correctly. You may have to close down all dos boxes to get this to
update
correctly, if not a log off log on normally works.
Now navigate to your gather log location. On my machine it is at
C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\XGatherLogs>
then type cscript.vbs gthrlog SQL0000600006.7.gthr or whatever you find
there.
these logs have time stamps on them, look for a date relevant one to
examine.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:eeSITHLMFHA.3016@.TK2MSFTNGP15.phx.gbl...
> I am running on Sql Server 2000.
> This was set up a couple of weeks ago and ran fine. I came in today and
was
> looking at some of my asp.net pages and started to get the error:
> Execution of a full-text operation failed. The catalog does not exist or
is
> currently unavailable
> I tried just a simple query:
> select * from position where Contains(jobDescription,'sales')
> and got the same error.
> What causes the problem? When I right-click on the table and go the
> fulltext menu and wizard, it says it is already set up for FullText
> indexing.
> Thanks,
> Tom
>
>
|||> Can you check for any messages in the event log from MSSearch or MSSCI?
> You might also want to use the gthrlog.vbs to examine your gatherer logs
> for
> this catalog.
> Go to c:\program files\Common files\system\mssearch\bin copy the
> gthrlog.vbs
> to c:\winnt\system32 directory or add the above path to your
> path (control panel - system - Environment - user and in the path variable
> append the above path in the path value (separate it from the entry before
> with a ;).
> Click on set, apply and OK. Run path from the command prompt to ensure you
> did this correctly. You may have to close down all dos boxes to get this
> to
> update
> correctly, if not a log off log on normally works.
> Now navigate to your gather log location. On my machine it is at
>
> C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\XGatherLogs>
>
> then type cscript.vbs gthrlog SQL0000600006.7.gthr or whatever you find
> there.
> these logs have time stamps on them, look for a date relevant one to
> examine.
We don't have cscript.vbs on our server which is a "Windows 2003 Server".
But the date of the only file in the GatherLogs folder is 3/15/05 and this
happened today.
There is no entry in the Event log or the Sql Server Logs about this
either - the last entry was 2:00 am this morning for our backups.
However, I did look at the FullTextCatalogs in the Databases folder on EM
and saw that the JobDescriptions Catalog is idle. Is this normal?
Thanks,
Tom
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:eeSITHLMFHA.3016@.TK2MSFTNGP15.phx.gbl...
> was
> is
>
|||Possibly, can you try to run a full population.
Btw its cscript gthrlog SQL0000600006.7.gthr
My mistake
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:e$rh5NMMFHA.3960@.TK2MSFTNGP12.phx.gbl...
> We don't have cscript.vbs on our server which is a "Windows 2003 Server".
> But the date of the only file in the GatherLogs folder is 3/15/05 and this
> happened today.
> There is no entry in the Event log or the Sql Server Logs about this
> either - the last entry was 2:00 am this morning for our backups.
> However, I did look at the FullTextCatalogs in the Databases folder on EM
> and saw that the JobDescriptions Catalog is idle. Is this normal?
> Thanks,
> Tom
>
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uiDrhnMMFHA.4044@.TK2MSFTNGP12.phx.gbl...
> Possibly, can you try to run a full population.
I did try the full population, but that didn't seem to help. But when I did
a rebuild catalog and then full population it worked fine.
Why would it do that and how would I get around that?
I can't have people trying to use our site and finding that their searches
won't work.
Thanks,
Tom
> Btw its cscript gthrlog SQL0000600006.7.gthr
> My mistake
>
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:e$rh5NMMFHA.3960@.TK2MSFTNGP12.phx.gbl...
>
|||Its hard to say - their may have been some catalog corruption, but there
should have been error messages logged in the event log, or in the gatherer
logs.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:e26H3zMMFHA.3760@.TK2MSFTNGP12.phx.gbl...
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uiDrhnMMFHA.4044@.TK2MSFTNGP12.phx.gbl...
> I did try the full population, but that didn't seem to help. But when I
did[vbcol=seagreen]
> a rebuild catalog and then full population it worked fine.
> Why would it do that and how would I get around that?
> I can't have people trying to use our site and finding that their searches
> won't work.
> Thanks,
> Tom
MSSCI?[vbcol=seagreen]
logs[vbcol=seagreen]
find[vbcol=seagreen]
Server".[vbcol=seagreen]
EM
>
|||Hilary,
I have had a similiar issue; I cannot read any of my data from a simple
query or returning all rows from SQL. I tried to reinstal my *.dll files for
MSSearch, to no avail.
I am running Server 2003, SQL 2000 sp3.
Any help would be appreciated.
Derek
"Hilary Cotter" wrote:
> Its hard to say - their may have been some catalog corruption, but there
> should have been error messages logged in the event log, or in the gatherer
> logs.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:e26H3zMMFHA.3760@.TK2MSFTNGP12.phx.gbl...
> did
> MSSCI?
> logs
> find
> Server".
> EM
>
>
|||Its difficult to assess what the problem could be. Could you check the event
log from messages coming from MSSearch or MSSCi? This might refer to your
gatherer logs, which can be accessed by using the gthrlog.vbs utility.
go to c:\program files\Common files\system\mssearch\bin, copy the
gthrlog.vbs to c:\winnt\system32 directory or add the above path to your
path (control panel - system - Environment - user and in the path variable
append the above path in the path value (separate it from the entry before
with a ;).
Click on set, apply and OK. Run path from the command prompt to ensure you
did this correctly. You may have to close down all dos boxes to get this to
update
correctly, if not a log off log on normally works.
Now navigate to your gather log location. On my machine it is at C:\Program
Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\XGatherLogs
then type cscript.vbs gthrlog SQL0000600006.7.gthr or whatever you find
there. these logs have time stamps on them, look for a date relevant one
to examine.
The most common reason for such a failure is the the SQL Server Service
account was changed through control panel as opposed to through EM. Refer to
this kb article for more information.
http://support.microsoft.com/default...b;en-us;295034
http://support.microsoft.com/default...b;en-us;317746
http://support.microsoft.com/default...b;en-us;295772
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"dkoz" <dkoz@.discussions.microsoft.com> wrote in message
news:D0FA563F-B9B0-4ABF-887B-DEA64EE7DDE9@.microsoft.com...
> Hilary,
> I have had a similiar issue; I cannot read any of my data from a simple
> query or returning all rows from SQL. I tried to reinstal my *.dll files
for[vbcol=seagreen]
> MSSearch, to no avail.
> I am running Server 2003, SQL 2000 sp3.
> Any help would be appreciated.
> Derek
> "Hilary Cotter" wrote:
gatherer[vbcol=seagreen]
I[vbcol=seagreen]
searches[vbcol=seagreen]
gatherer[vbcol=seagreen]
entry[vbcol=seagreen]
ensure[vbcol=seagreen]
get[vbcol=seagreen]
to[vbcol=seagreen]
and[vbcol=seagreen]
this[vbcol=seagreen]
on[vbcol=seagreen]
today[vbcol=seagreen]
exist[vbcol=seagreen]
the[vbcol=seagreen]
FullText[vbcol=seagreen]
Showing posts with label pages. Show all posts
Showing posts with label pages. Show all posts
Monday, March 26, 2012
Friday, March 9, 2012
I am accessing data using data access pages in IIS 7 to SQL server 2005 Authentication is failin
is there a step by step paper to get there? here is what i need to consider. I Iwill have many customers that will need their own set of records and access pages "branded for their company" each customer will have many clients. I am hosting this application on a windows 2003 server with SQL 2005 server enterprise.
I am using windows authentication, I have created a username in windows, then i added the windows user in SQL management studio in security, granted "DB Read" and "DB write" and again under the database security tab. still from the web authentication fails. i must be nissing a step or two?
I expect to set up a username for each database as i setup new customers.
There is another post that had a similar issue...the discussion there may prove to be relevant for you:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=978330&SiteID=1
The important step is to disable Anonymous Authentication on your web server and enable Integrated Windows authentication. This will get the database request running in the context of the user making the web request (as opposed to the context of the default anonymous account).
Note that for data security/privacy reasons, you will probably want to avoid having clients from different companies, etc. sharing the same database and/or tables.
I am accessing data using data access pages in IIS 7 to SQL server 2005 Authentication is fa
is there a step by step paper to get there? here is what i need to consider. I Iwill have many customers that will need their own set of records and access pages "branded for their company" each customer will have many clients. I am hosting this application on a windows 2003 server with SQL 2005 server enterprise.
I am using windows authentication, I have created a username in windows, then i added the windows user in SQL management studio in security, granted "DB Read" and "DB write" and again under the database security tab. still from the web authentication fails. i must be nissing a step or two?
I expect to set up a username for each database as i setup new customers.
There is another post that had a similar issue...the discussion there may prove to be relevant for you:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=978330&SiteID=1
The important step is to disable Anonymous Authentication on your web server and enable Integrated Windows authentication. This will get the database request running in the context of the user making the web request (as opposed to the context of the default anonymous account).
Note that for data security/privacy reasons, you will probably want to avoid having clients from different companies, etc. sharing the same database and/or tables.
Subscribe to:
Posts (Atom)