July 7, 2005 at 7:09 am
We have created fulltext catalogs in "E:" drive in old server.
We moved to a new server in which we only have "C:" and "D:" drives.
We created database using backup in our new server. Since catalogs were referring to "E:" drive, Fulltext is not getting enabled when we used the command exec sp_fulltext_database 'enable'. It is giving the following error:
Server: Msg 7610, Level 16, State 1, Procedure sp_fulltext_database, Line 61
Access is denied to 'E:\MySite\SQLServerCatalogs', or the path is invalid. Full-text search was not installed properly.
We tried to delete catalogs. But were not successful as it says invalid path.
Please help.
Thank you in Advance.
- Vasu
July 7, 2005 at 7:43 am
Good News!
I found a solution for this problem.
I found an article which solved my problem.
I opened to "SQL Server Instance" properties, went to "Server Settings" tab, checked "Allow modifications to be made directly to the system catalogs".
This allowed me to modify the path of the catalog present in "sysfulltextcatalogs". I changed the path to "D:\MySite\SQLServerCatalogs" which is a valid path as this drive exists in my server.
Now I could enable fulltext indexing in the database and do all other operations (Building Catalog, Population).
Article Path:
http://www.sqlservercentral.com/columnists/jwiner/20010422025723_1.asp
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply