Merging two dbs: installation

Showing posts with label installation. Show all posts

Friday, March 30, 2012

Microsoft SQL Server 2005 Express Edition Toolkit Is not in my Add Remove Programs how do I unin

I have Microsoft SQL Server 2005 Express Edition Toolkit installed but there is something from with the installation since every time that I try and create a Report Server Project It gives me error

Could not load file or assembly "Microsoft.ReportingServices.Designer, Version 9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannopt find the file spesified.

How can I reinstall it or repair the installation so it will work. I have uninstalled every SQL2000 component in Add Remove Programs and reinstalled them. The problem is however that I cannot see an entry for "Microsoft SQL Server 2005 Express Edition Toolkit" in the Add Remove programs in Windows XP Profesional.

Can someone please help me. Maybe tell me where the uninstall file is located on disk?

Any help will be great

Manu Thanks

This may not be what you are expecting but it could be you don't have IIS installed in your box and when IIS is not installed, in full SQL Server editions the installer skips Reporting services. So make sure IIS is installed before trying to open reporting services because it will not run without it. Hope this helps.|||

Thanks for the quick response.

I have everything else working, IIS is working and I can access the report manager and the report server url's, those all work fine. The problem comes in when I try and create a Report Server Project in Visual Studio. As soon as I try and create the project I get the error I mentioned above. It is as if it doesn't find the Reporting Services Design Assembly, but I've done a search on the PC and I did find the dll, so I might need to spesify somewhere where it is?

I'd like to just uninstall the Toolkit and Reinstall it but the Express installer doesn't support uninstalling and the Add Remove Programs in Control Panel doesn't have an Entry for the Toolkit.

Wednesday, March 28, 2012

Microsoft SQL Express 2005 Installation Failure

I can get SQL SERVER 2005 to install it goes through the extracting files then gives me an error message that says "SQL Server Setup unexpectedly failed. for more information, review the setup summery log file " . I don't think i have any beta versons of Visual Studio or SQL I do have Accouting Express with has something with SQL I don't know if that will stop my installation. I really need SQL to work for my business.

Please Help ME!!!

Heres a copy of my log file:[SQLSetup0017_DSTRETCH_Core]

Microsoft SQL Server 2005 Setup beginning at Wed Apr 18 19:28:35 2007
Process ID : 5244
c:\84d9dbbedcbb7eee6c8eeabf58\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/18 19:28:35
Complete: LoadResourcesAction at: 2007/3/18 19:28:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35
Loaded DLL:c:\84d9dbbedcbb7eee6c8eeabf58\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/3/18 19:28:35
Complete: ValidateWinNTAction at: 2007/3/18 19:28:35, returned true
Running: ValidateMinOSAction at: 2007/3/18 19:28:35
Complete: ValidateMinOSAction at: 2007/3/18 19:28:35, returned true
Running: PerformSCCAction at: 2007/3/18 19:28:35
Complete: PerformSCCAction at: 2007/3/18 19:28:35, returned true
Running: ActivateLoggingAction at: 2007/3/18 19:28:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
02E7CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Can you search through your SQL install log directory for the text string "value 3" and post the 10 or so lines above that? It may give a more descriptive error message.

Thanks,
Sam Lester (MSFT)

|||

Ah, I think it may be this issue. Can you read through this post and see if it applies to your situation.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1117117&SiteID=1

Thanks,
Sam

|||I can't find "value 3" and the artical that you linked to did not apply to my problem.

Microsoft SQL Express 2005 Installation Failure

Please Help ME!!!

Heres a copy of my log file:[SQLSetup0017_DSTRETCH_Core]

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Can you search through your SQL install log directory for the text string "value 3" and post the 10 or so lines above that? It may give a more descriptive error message.

Thanks,
Sam Lester (MSFT)

|||

Ah, I think it may be this issue. Can you read through this post and see if it applies to your situation.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1117117&SiteID=1

Thanks,
Sam

|||I can't find "value 3" and the artical that you linked to did not apply to my problem.

Microsoft search service kills SQL 2000 server

Hi all,

This may be more of a Sharepoint or server question but I thought I would post it here to start off with. I have an installation of SQL 2000 SP4 and sharepoint services 2003 all on one server. For example the SQL 2000 (SP4), sharepoint and its indexes all on the one server (HP G4 DL380). I have installed the index service and the full text services on the SQL server then configured searching in sharepoint. The search worked fine for about a year until one day the server started randomly hanging for no apparent reason. After a hard reboot the server would begin to hand again after around 2-3 minutes of being online, sometimes less. After lots of problem shooting I nailed it down to being the Microsoft search service that caused the issue. Basically if I set this service to manual and boot I have no problem. As soon as I start the service the server will start to hang about 2-3 minutes later.

I tried this again last night after trying some fixed and got the same result. The only error I get are in the application log which are about 4 of these with different file types.

One or more documents stored in image columns with extension “X” did not get full-textindexed because loading the filter failed with error '0x1'

The server continues to log messages while it is hanging and you can ping the server but you can not access sharepoint, remote in to the server, you can login locally but as soon as you try anything like bring up the start menu all resources will freeze up. During this time there is no disk activity and the CPU usage is 1-3% and mem usage is low.

Can anyone suggest anything to fix this problem so I can start the Microsoft search service and use search in sharepoint again.

Thanks,

I've moved this into the general engine thread since the question is in no way related to Broker.|||Thanks. Sorry for the misplacement.sql

Microsoft Search service can't start after SQL2005 installation!

Hi
The version numbers in your post seem to be inconsistent!
I assume that you have removed SQL 2000 and only have a named instance of
SQL 2005. If you want the instance of SQL 2005 to be the default instance you
will need to install SQL 2005 again anyhow, and possibly remove the named
instance of SQL 2005 if it is not wanted. If you want to reinstall the
current named instance you can install it from the command line with the
REINSTALLMODE=OMUS option see
http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
REINSTALLMODE=O will replace the missing file, but it would probably not do
any harm having the other options.
John
"PG" wrote:

> Hi everybody I had a server with SQL2000 Standard on Server2003 Standard
> working, but I was told to uninstall and install SQl2005 Standard, but now
> when I start the server I receive an error saying that a service could not
> start, I went to see what service the server was talking about and it was
> the Microsoft Search service. The error says that the specified file can't
> be found, so I went to "C:\Program Files\Common
> Files\System\MSSearch\Bin\mssearch.exe" and the file mssearch.exe is
> missing!!!
> Was it the uninstall of SQL2000 that screwed this up, or the installation of
> SQL2005?
> I dont know what to do from here, what can I do?...Any help would be
> appreciated.
> Thanks in advance..
>
>
Hi
"PG" wrote:

> I'm sorry if I didn't make myself clear, what I did was uninstall SQL2000
> and afterwards install SQL2005 on the same machine (WindowsServer2003).
>
mssearch.exe is for SQL 2000 if you want to reinstall it see
http://support.microsoft.com/default.aspx/kb/827449 but if you have SQL 2005
you should see an instance of SQL Server FullText Search (MSSQLSERVER) in
your services which runs "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\msftesql.exe". The article also shows how to
remove it.
John
|||John Bell from BCSI?
Jason

Quote:

Originally Posted by John Bell View Post

Hi
"PG" wrote:

> I'm sorry if I didn't make myself clear, what I did was uninstall SQL2000
> and afterwards install SQL2005 on the same machine (WindowsServer2003).
>
mssearch.exe is for SQL 2000 if you want to reinstall it see
http://support.microsoft.com/default.aspx/kb/827449 but if you have SQL 2005
you should see an instance of SQL Server FullText Search (MSSQLSERVER) in
your services which runs "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\msftesql.exe". The article also shows how to
remove it.
John

Microsoft Search service can't start after SQL2005 installation!

Hi everybody I had a server with SQL2000 Standard on Server2003 Standard
working, but I was told to uninstall and install SQl2005 Standard, but now
when I start the server I receive an error saying that a service could not
start, I went to see what service the server was talking about and it was
the Microsoft Search service. The error says that the specified file can't
be found, so I went to "C:\Program Files\Common
Files\System\MSSearch\Bin\mssearch.exe" and the file mssearch.exe is
missing!!!
Was it the uninstall of SQL2000 that screwed this up, or the installation of
SQL2005?
I dont know what to do from here, what can I do?...Any help would be
appreciated.
Thanks in advance..Hi
The version numbers in your post seem to be inconsistent!
I assume that you have removed SQL 2000 and only have a named instance of
SQL 2005. If you want the instance of SQL 2005 to be the default instance you
will need to install SQL 2005 again anyhow, and possibly remove the named
instance of SQL 2005 if it is not wanted. If you want to reinstall the
current named instance you can install it from the command line with the
REINSTALLMODE=OMUS option see
http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
REINSTALLMODE=O will replace the missing file, but it would probably not do
any harm having the other options.
John
"PG" wrote:
> Hi everybody I had a server with SQL2000 Standard on Server2003 Standard
> working, but I was told to uninstall and install SQl2005 Standard, but now
> when I start the server I receive an error saying that a service could not
> start, I went to see what service the server was talking about and it was
> the Microsoft Search service. The error says that the specified file can't
> be found, so I went to "C:\Program Files\Common
> Files\System\MSSearch\Bin\mssearch.exe" and the file mssearch.exe is
> missing!!!
> Was it the uninstall of SQL2000 that screwed this up, or the installation of
> SQL2005?
> I dont know what to do from here, what can I do?...Any help would be
> appreciated.
> Thanks in advance..
>
>|||I'm sorry if I didn't make myself clear, what I did was uninstall SQL2000
and afterwards install SQL2005 on the same machine (WindowsServer2003).
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:82ECF7F8-D4A2-4213-9A68-76656BC41C79@.microsoft.com...
> Hi
> The version numbers in your post seem to be inconsistent!
> I assume that you have removed SQL 2000 and only have a named instance of
> SQL 2005. If you want the instance of SQL 2005 to be the default instance
> you
> will need to install SQL 2005 again anyhow, and possibly remove the named
> instance of SQL 2005 if it is not wanted. If you want to reinstall the
> current named instance you can install it from the command line with the
> REINSTALLMODE=OMUS option see
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
> REINSTALLMODE=O will replace the missing file, but it would probably not
> do
> any harm having the other options.
> John
> "PG" wrote:
>> Hi everybody I had a server with SQL2000 Standard on Server2003 Standard
>> working, but I was told to uninstall and install SQl2005 Standard, but
>> now
>> when I start the server I receive an error saying that a service could
>> not
>> start, I went to see what service the server was talking about and it was
>> the Microsoft Search service. The error says that the specified file
>> can't
>> be found, so I went to "C:\Program Files\Common
>> Files\System\MSSearch\Bin\mssearch.exe" and the file mssearch.exe is
>> missing!!!
>> Was it the uninstall of SQL2000 that screwed this up, or the installation
>> of
>> SQL2005?
>> I dont know what to do from here, what can I do?...Any help would be
>> appreciated.
>> Thanks in advance..
>>|||Hi
"PG" wrote:
> I'm sorry if I didn't make myself clear, what I did was uninstall SQL2000
> and afterwards install SQL2005 on the same machine (WindowsServer2003).
>
mssearch.exe is for SQL 2000 if you want to reinstall it see
http://support.microsoft.com/default.aspx/kb/827449 but if you have SQL 2005
you should see an instance of SQL Server FullText Search (MSSQLSERVER) in
your services which runs "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\msftesql.exe". The article also shows how to
remove it.
John

Microsoft Search service can't start after SQL2005 installation!

Hi everybody I had a server with SQL2000 Standard on Server2003 Standard
working, but I was told to uninstall and install SQl2005 Standard, but now
when I start the server I receive an error saying that a service could not
start, I went to see what service the server was talking about and it was
the Microsoft Search service. The error says that the specified file can't
be found, so I went to "C:\Program Files\Common
Files\System\MSSearch\Bin\mssearch.exe" and the file mssearch.exe is
missing!!!
Was it the uninstall of SQL2000 that screwed this up, or the installation of
SQL2005?
I dont know what to do from here, what can I do?...Any help would be
appreciated.
Thanks in advance..Hi
The version numbers in your post seem to be inconsistent!
I assume that you have removed SQL 2000 and only have a named instance of
SQL 2005. If you want the instance of SQL 2005 to be the default instance yo
u
will need to install SQL 2005 again anyhow, and possibly remove the named
instance of SQL 2005 if it is not wanted. If you want to reinstall the
current named instance you can install it from the command line with the
REINSTALLMODE=OMUS option see
http://msdn2.microsoft.com/en-us/li...x#reinstallmode
REINSTALLMODE=O will replace the missing file, but it would probably not do
any harm having the other options.
John
"PG" wrote:

> Hi everybody I had a server with SQL2000 Standard on Server2003 Standard
> working, but I was told to uninstall and install SQl2005 Standard, but now
> when I start the server I receive an error saying that a service could not
> start, I went to see what service the server was talking about and it was
> the Microsoft Search service. The error says that the specified file can't
> be found, so I went to "C:\Program Files\Common
> Files\System\MSSearch\Bin\mssearch.exe" and the file mssearch.exe is
> missing!!!
> Was it the uninstall of SQL2000 that screwed this up, or the installation
of
> SQL2005?
> I dont know what to do from here, what can I do?...Any help would be
> appreciated.
> Thanks in advance..
>
>|||I'm sorry if I didn't make myself clear, what I did was uninstall SQL2000
and afterwards install SQL2005 on the same machine (WindowsServer2003).
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:82ECF7F8-D4A2-4213-9A68-76656BC41C79@.microsoft.com...[vbcol=seagreen]
> Hi
> The version numbers in your post seem to be inconsistent!
> I assume that you have removed SQL 2000 and only have a named instance of
> SQL 2005. If you want the instance of SQL 2005 to be the default instance
> you
> will need to install SQL 2005 again anyhow, and possibly remove the named
> instance of SQL 2005 if it is not wanted. If you want to reinstall the
> current named instance you can install it from the command line with the
> REINSTALLMODE=OMUS option see
> http://msdn2.microsoft.com/en-us/li...x#reinstallmode
> REINSTALLMODE=O will replace the missing file, but it would probably not
> do
> any harm having the other options.
> John
> "PG" wrote:
>

'Microsoft Search service cannot be administered under the present user error' SP3

Hi,
We have SQL Server private installation on which we are developing an
application and public installation on whict we will be deploying the
application. All instances have run Windows 2003 Enterprise Edition with SQL
2000 SP3. However, the public installation MS Search is not functioning
correctly. Basically it will not full-text indeed databases and produces
the following error
1> exec sp_fulltext_database 'enable'
2> go
(1 row affected)
Msg 7635, Level 16, State 1, Server SIMP001, Procedure sp_fulltext_database,
Lin
e 46
The Microsoft Search service cannot be administered under the present user
account
Now, we have tried many things to try and solve this error, mainly based on
search newsgroups, which are itemized below:
1 Reboot System and reexecute sp_
2 Complete reinstall of SQL on system, then reapplication of SP3
3 Same as above (2) but reapply SP3a
4 Remove SQL Server installation subkey in order that can reinstall
full-text search only, then reapply SP3
5 Check from keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\ to make sure
SQL Server was there. It wasn't, removed SQL subkey and reinstalled,
re-adding full-text search as an option (to re-install full-text) then
reapplied SP3
6 Try reinstall, but do not reapply SP3 until have full-text enabled the
database.
None of the above worked. We still have a none functioning mssearch and
full-text disabled database on the system.
We have even tried enabling on a blank database. This does not work either.
PLEASE HELP! Getting desperate as the whole application depends on having
search ability.
Thanks
OzYou will probably need to use the steps in the following article to bypass
this error:
How to manually reinstall the Microsoft Search service for an instance of
SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;[LN];827449
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Oz,
In addition to the many things you tried below... a couple of things
specific to MSSearch and the MSSQLServer services...
1. Is the MSSearch service started and running under the System
(LocalSystem) account? If not, then change it to LocalSystem and stop and
re-start this service.
2. Have you or anyone else change the MSSQLServer account &/or password via
Win2K's Component service? IF so, then you MUST re-change the change via the
Enterprise Manager's server property security tab as this is the only place
where the two services security are kept in sync. See KB article 277549
(Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services] at http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
3. Have you or anyone else removed or modified the BUILTIN\Administrator
login on this server? If so, you MUST either re-add it with all of it's
normal default rights, especially sysadmin rights and with the default
database as master and the default language of English or use the following
T-SQL code to add the correct permissions:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
Additionally, but not necessarily related to the error in the subject line,
has this server ever been upgrade from SQL Server 7.0 or is this SQL Server
2000 a "named instance" with a default installation of SQL Server 7.0? As
this might be related to a post-SP3 bug. See KB 814035 (Q814035) FIX: A
Full-Text Population Fails After You Apply SQL Server 2000 Service Pack 3
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;814035 (80004002 -
No such interface supported)
Regards,
John
"Oz" <Oz(no_spam)@.nospam.com> wrote in message
news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> Hi,
> We have SQL Server private installation on which we are developing an
> application and public installation on whict we will be deploying the
> application. All instances have run Windows 2003 Enterprise Edition with
SQL
> 2000 SP3. However, the public installation MS Search is not functioning
> correctly. Basically it will not full-text indeed databases and produces
> the following error
> 1> exec sp_fulltext_database 'enable'
> 2> go
> (1 row affected)
> Msg 7635, Level 16, State 1, Server SIMP001, Procedure
sp_fulltext_database,
> Lin
> e 46
> The Microsoft Search service cannot be administered under the present user
> account
> Now, we have tried many things to try and solve this error, mainly based
on
> search newsgroups, which are itemized below:
> 1 Reboot System and reexecute sp_
> 2 Complete reinstall of SQL on system, then reapplication of SP3
> 3 Same as above (2) but reapply SP3a
> 4 Remove SQL Server installation subkey in order that can reinstall
> full-text search only, then reapply SP3
> 5 Check from keys under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\ to make
sure
> SQL Server was there. It wasn't, removed SQL subkey and reinstalled,
> re-adding full-text search as an option (to re-install full-text) then
> reapplied SP3
> 6 Try reinstall, but do not reapply SP3 until have full-text enabled the
> database.
> None of the above worked. We still have a none functioning mssearch and
> full-text disabled database on the system.
> We have even tried enabling on a blank database. This does not work
either.
> PLEASE HELP! Getting desperate as the whole application depends on having
> search ability.
> Thanks
> Oz
>|||Hi John,
Thanks for replying to my message. Unfortunately i forgot to add these items
as items i had also tried.
- Have not modified Administrator account, but i ran the SQL script anyway.
- MS Search has always been running as local system
- Changed the security settings using Ent Mgr to Local System and back again
to the user account.
- SQL account is not a local administrator. Tried adding it Administrators,
still, no joy.
Thanks
O
"John Kane" <jt-kane@.comcast.net> wrote in message
news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> Oz,
> In addition to the many things you tried below... a couple of things
> specific to MSSearch and the MSSQLServer services...
> 1. Is the MSSearch service started and running under the System
> (LocalSystem) account? If not, then change it to LocalSystem and stop and
> re-start this service.
> 2. Have you or anyone else change the MSSQLServer account &/or password
via
> Win2K's Component service? IF so, then you MUST re-change the change via
the
> Enterprise Manager's server property security tab as this is the only
place
> where the two services security are kept in sync. See KB article 277549
> (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K
Component
> Services] at
http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> 3. Have you or anyone else removed or modified the BUILTIN\Administrator
> login on this server? If so, you MUST either re-add it with all of it's
> normal default rights, especially sysadmin rights and with the default
> database as master and the default language of English or use the
following
> T-SQL code to add the correct permissions:
> exec sp_grantlogin N'NT Authority\System'
> exec sp_defaultdb N'NT Authority\System', N'master'
> exec sp_defaultlanguage N'NT Authority\System','us_english'
> exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> Additionally, but not necessarily related to the error in the subject
line,
> has this server ever been upgrade from SQL Server 7.0 or is this SQL
Server
> 2000 a "named instance" with a default installation of SQL Server 7.0? As
> this might be related to a post-SP3 bug. See KB 814035 (Q814035) FIX: A
> Full-Text Population Fails After You Apply SQL Server 2000 Service Pack 3
> at:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;814035 (80004002 -
> No such interface supported)
> Regards,
> John
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > We have SQL Server private installation on which we are developing an
> > application and public installation on whict we will be deploying the
> > application. All instances have run Windows 2003 Enterprise Edition with
> SQL
> > 2000 SP3. However, the public installation MS Search is not functioning
> > correctly. Basically it will not full-text indeed databases and
produces
> > the following error
> >
> > 1> exec sp_fulltext_database 'enable'
> > 2> go
> > (1 row affected)
> > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> sp_fulltext_database,
> > Lin
> > e 46
> > The Microsoft Search service cannot be administered under the present
user
> > account
> >
> > Now, we have tried many things to try and solve this error, mainly based
> on
> > search newsgroups, which are itemized below:
> >
> > 1 Reboot System and reexecute sp_
> > 2 Complete reinstall of SQL on system, then reapplication of SP3
> > 3 Same as above (2) but reapply SP3a
> > 4 Remove SQL Server installation subkey in order that can reinstall
> > full-text search only, then reapply SP3
> > 5 Check from keys under
> > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\ to make
> sure
> > SQL Server was there. It wasn't, removed SQL subkey and reinstalled,
> > re-adding full-text search as an option (to re-install full-text) then
> > reapplied SP3
> > 6 Try reinstall, but do not reapply SP3 until have full-text enabled the
> > database.
> >
> > None of the above worked. We still have a none functioning mssearch and
> > full-text disabled database on the system.
> >
> > We have even tried enabling on a blank database. This does not work
> either.
> >
> > PLEASE HELP! Getting desperate as the whole application depends on
having
> > search ability.
> >
> > Thanks
> >
> > Oz
> >
> >
>|||John
Is there a log file somewhere that i could try and see what precisely is
causing this problem.
Thanks
"John Kane" <jt-kane@.comcast.net> wrote in message
news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> Oz,
> In addition to the many things you tried below... a couple of things
> specific to MSSearch and the MSSQLServer services...
> 1. Is the MSSearch service started and running under the System
> (LocalSystem) account? If not, then change it to LocalSystem and stop and
> re-start this service.
> 2. Have you or anyone else change the MSSQLServer account &/or password
via
> Win2K's Component service? IF so, then you MUST re-change the change via
the
> Enterprise Manager's server property security tab as this is the only
place
> where the two services security are kept in sync. See KB article 277549
> (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K
Component
> Services] at
http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> 3. Have you or anyone else removed or modified the BUILTIN\Administrator
> login on this server? If so, you MUST either re-add it with all of it's
> normal default rights, especially sysadmin rights and with the default
> database as master and the default language of English or use the
following
> T-SQL code to add the correct permissions:
> exec sp_grantlogin N'NT Authority\System'
> exec sp_defaultdb N'NT Authority\System', N'master'
> exec sp_defaultlanguage N'NT Authority\System','us_english'
> exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> Additionally, but not necessarily related to the error in the subject
line,
> has this server ever been upgrade from SQL Server 7.0 or is this SQL
Server
> 2000 a "named instance" with a default installation of SQL Server 7.0? As
> this might be related to a post-SP3 bug. See KB 814035 (Q814035) FIX: A
> Full-Text Population Fails After You Apply SQL Server 2000 Service Pack 3
> at:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;814035 (80004002 -
> No such interface supported)
> Regards,
> John
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > We have SQL Server private installation on which we are developing an
> > application and public installation on whict we will be deploying the
> > application. All instances have run Windows 2003 Enterprise Edition with
> SQL
> > 2000 SP3. However, the public installation MS Search is not functioning
> > correctly. Basically it will not full-text indeed databases and
produces
> > the following error
> >
> > 1> exec sp_fulltext_database 'enable'
> > 2> go
> > (1 row affected)
> > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> sp_fulltext_database,
> > Lin
> > e 46
> > The Microsoft Search service cannot be administered under the present
user
> > account
> >
> > Now, we have tried many things to try and solve this error, mainly based
> on
> > search newsgroups, which are itemized below:
> >
> > 1 Reboot System and reexecute sp_
> > 2 Complete reinstall of SQL on system, then reapplication of SP3
> > 3 Same as above (2) but reapply SP3a
> > 4 Remove SQL Server installation subkey in order that can reinstall
> > full-text search only, then reapply SP3
> > 5 Check from keys under
> > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\ to make
> sure
> > SQL Server was there. It wasn't, removed SQL subkey and reinstalled,
> > re-adding full-text search as an option (to re-install full-text) then
> > reapplied SP3
> > 6 Try reinstall, but do not reapply SP3 until have full-text enabled the
> > database.
> >
> > None of the above worked. We still have a none functioning mssearch and
> > full-text disabled database on the system.
> >
> > We have even tried enabling on a blank database. This does not work
> either.
> >
> > PLEASE HELP! Getting desperate as the whole application depends on
having
> > search ability.
> >
> > Thanks
> >
> > Oz
> >
> >
>|||You're welcome, Oz,
Yes, there are MSSearch gatherer log files located under
\FTDATA\SQLServer\GatherLogs\ that can be "read" using gthrlog.vbs, however,
they most likely will have the same error (MSSearch service cannot be
admin..), so they are of little value in this issue.
Is this SQL Server installed on a Domain Controller (DC) server or is the
MSSQLServer startup account the DOMAIN\Administrator account?
While this should work, it's been my experience that with Full-Text Search
(FTS) on DC's that this is a problem for the "Microsoft Search" (MSSearch)
service. If you are using the DOMAIN\Administrator account, create a local
machine account and add this account into the DC's Administrator Group and
then change the MSSQLServer startup account in the Enterprise Manager (this
change MUST be done here) server's security tab. This should stop and
restart SQL Server and if all is successfully completed, FTS on a DC
*should* work...
Regards,
John
"Oz" <Oz(no_spam)@.nospam.com> wrote in message
news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> John
> Is there a log file somewhere that i could try and see what precisely is
> causing this problem.
> Thanks
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > Oz,
> > In addition to the many things you tried below... a couple of things
> > specific to MSSearch and the MSSQLServer services...
> > 1. Is the MSSearch service started and running under the System
> > (LocalSystem) account? If not, then change it to LocalSystem and stop
and
> > re-start this service.
> >
> > 2. Have you or anyone else change the MSSQLServer account &/or password
> via
> > Win2K's Component service? IF so, then you MUST re-change the change via
> the
> > Enterprise Manager's server property security tab as this is the only
> place
> > where the two services security are kept in sync. See KB article 277549
> > (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> > MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K
> Component
> > Services] at
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> >
> > 3. Have you or anyone else removed or modified the
BUILTIN\Administrator
> > login on this server? If so, you MUST either re-add it with all of it's
> > normal default rights, especially sysadmin rights and with the default
> > database as master and the default language of English or use the
> following
> > T-SQL code to add the correct permissions:
> >
> > exec sp_grantlogin N'NT Authority\System'
> > exec sp_defaultdb N'NT Authority\System', N'master'
> > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> >
> > Additionally, but not necessarily related to the error in the subject
> line,
> > has this server ever been upgrade from SQL Server 7.0 or is this SQL
> Server
> > 2000 a "named instance" with a default installation of SQL Server 7.0?
As
> > this might be related to a post-SP3 bug. See KB 814035 (Q814035) FIX: A
> > Full-Text Population Fails After You Apply SQL Server 2000 Service Pack
3
> > at:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
(80004002 -
> > No such interface supported)
> >
> > Regards,
> > John
> >
> >
> > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > >
> > > We have SQL Server private installation on which we are developing an
> > > application and public installation on whict we will be deploying the
> > > application. All instances have run Windows 2003 Enterprise Edition
with
> > SQL
> > > 2000 SP3. However, the public installation MS Search is not
functioning
> > > correctly. Basically it will not full-text indeed databases and
> produces
> > > the following error
> > >
> > > 1> exec sp_fulltext_database 'enable'
> > > 2> go
> > > (1 row affected)
> > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > sp_fulltext_database,
> > > Lin
> > > e 46
> > > The Microsoft Search service cannot be administered under the present
> user
> > > account
> > >
> > > Now, we have tried many things to try and solve this error, mainly
based
> > on
> > > search newsgroups, which are itemized below:
> > >
> > > 1 Reboot System and reexecute sp_
> > > 2 Complete reinstall of SQL on system, then reapplication of SP3
> > > 3 Same as above (2) but reapply SP3a
> > > 4 Remove SQL Server installation subkey in order that can reinstall
> > > full-text search only, then reapply SP3
> > > 5 Check from keys under
> > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\ to make
> > sure
> > > SQL Server was there. It wasn't, removed SQL subkey and reinstalled,
> > > re-adding full-text search as an option (to re-install full-text) then
> > > reapplied SP3
> > > 6 Try reinstall, but do not reapply SP3 until have full-text enabled
the
> > > database.
> > >
> > > None of the above worked. We still have a none functioning mssearch
and
> > > full-text disabled database on the system.
> > >
> > > We have even tried enabling on a blank database. This does not work
> > either.
> > >
> > > PLEASE HELP! Getting desperate as the whole application depends on
> having
> > > search ability.
> > >
> > > Thanks
> > >
> > > Oz
> > >
> > >
> >
> >
>|||Hi John,
Yes, it is running on a DC. I will try your suggestions and see if it makes
any difference.
Thanks
Oz
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> You're welcome, Oz,
> Yes, there are MSSearch gatherer log files located under
> \FTDATA\SQLServer\GatherLogs\ that can be "read" using gthrlog.vbs,
however,
> they most likely will have the same error (MSSearch service cannot be
> admin..), so they are of little value in this issue.
> Is this SQL Server installed on a Domain Controller (DC) server or is the
> MSSQLServer startup account the DOMAIN\Administrator account?
> While this should work, it's been my experience that with Full-Text Search
> (FTS) on DC's that this is a problem for the "Microsoft Search" (MSSearch)
> service. If you are using the DOMAIN\Administrator account, create a local
> machine account and add this account into the DC's Administrator Group and
> then change the MSSQLServer startup account in the Enterprise Manager
(this
> change MUST be done here) server's security tab. This should stop and
> restart SQL Server and if all is successfully completed, FTS on a DC
> *should* work...
> Regards,
> John
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > John
> >
> > Is there a log file somewhere that i could try and see what precisely is
> > causing this problem.
> >
> > Thanks
> > "John Kane" <jt-kane@.comcast.net> wrote in message
> > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > Oz,
> > > In addition to the many things you tried below... a couple of things
> > > specific to MSSearch and the MSSQLServer services...
> > > 1. Is the MSSearch service started and running under the System
> > > (LocalSystem) account? If not, then change it to LocalSystem and stop
> and
> > > re-start this service.
> > >
> > > 2. Have you or anyone else change the MSSQLServer account &/or
password
> > via
> > > Win2K's Component service? IF so, then you MUST re-change the change
via
> > the
> > > Enterprise Manager's server property security tab as this is the only
> > place
> > > where the two services security are kept in sync. See KB article
277549
> > > (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> > > MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K
> > Component
> > > Services] at
> > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > >
> > > 3. Have you or anyone else removed or modified the
> BUILTIN\Administrator
> > > login on this server? If so, you MUST either re-add it with all of
it's
> > > normal default rights, especially sysadmin rights and with the default
> > > database as master and the default language of English or use the
> > following
> > > T-SQL code to add the correct permissions:
> > >
> > > exec sp_grantlogin N'NT Authority\System'
> > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > >
> > > Additionally, but not necessarily related to the error in the subject
> > line,
> > > has this server ever been upgrade from SQL Server 7.0 or is this SQL
> > Server
> > > 2000 a "named instance" with a default installation of SQL Server 7.0?
> As
> > > this might be related to a post-SP3 bug. See KB 814035 (Q814035) FIX:
A
> > > Full-Text Population Fails After You Apply SQL Server 2000 Service
Pack
> 3
> > > at:
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> (80004002 -
> > > No such interface supported)
> > >
> > > Regards,
> > > John
> > >
> > >
> > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > Hi,
> > > >
> > > > We have SQL Server private installation on which we are developing
an
> > > > application and public installation on whict we will be deploying
the
> > > > application. All instances have run Windows 2003 Enterprise Edition
> with
> > > SQL
> > > > 2000 SP3. However, the public installation MS Search is not
> functioning
> > > > correctly. Basically it will not full-text indeed databases and
> > produces
> > > > the following error
> > > >
> > > > 1> exec sp_fulltext_database 'enable'
> > > > 2> go
> > > > (1 row affected)
> > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > sp_fulltext_database,
> > > > Lin
> > > > e 46
> > > > The Microsoft Search service cannot be administered under the
present
> > user
> > > > account
> > > >
> > > > Now, we have tried many things to try and solve this error, mainly
> based
> > > on
> > > > search newsgroups, which are itemized below:
> > > >
> > > > 1 Reboot System and reexecute sp_
> > > > 2 Complete reinstall of SQL on system, then reapplication of SP3
> > > > 3 Same as above (2) but reapply SP3a
> > > > 4 Remove SQL Server installation subkey in order that can reinstall
> > > > full-text search only, then reapply SP3
> > > > 5 Check from keys under
> > > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\ to
make
> > > sure
> > > > SQL Server was there. It wasn't, removed SQL subkey and reinstalled,
> > > > re-adding full-text search as an option (to re-install full-text)
then
> > > > reapplied SP3
> > > > 6 Try reinstall, but do not reapply SP3 until have full-text enabled
> the
> > > > database.
> > > >
> > > > None of the above worked. We still have a none functioning mssearch
> and
> > > > full-text disabled database on the system.
> > > >
> > > > We have even tried enabling on a blank database. This does not work
> > > either.
> > > >
> > > > PLEASE HELP! Getting desperate as the whole application depends on
> > having
> > > > search ability.
> > > >
> > > > Thanks
> > > >
> > > > Oz
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi John,
It's just occurred, to me, there is nothing in those directories as i cannot
enable the database for full-text!
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> You're welcome, Oz,
> Yes, there are MSSearch gatherer log files located under
> \FTDATA\SQLServer\GatherLogs\ that can be "read" using gthrlog.vbs,
however,
> they most likely will have the same error (MSSearch service cannot be
> admin..), so they are of little value in this issue.
> Is this SQL Server installed on a Domain Controller (DC) server or is the
> MSSQLServer startup account the DOMAIN\Administrator account?
> While this should work, it's been my experience that with Full-Text Search
> (FTS) on DC's that this is a problem for the "Microsoft Search" (MSSearch)
> service. If you are using the DOMAIN\Administrator account, create a local
> machine account and add this account into the DC's Administrator Group and
> then change the MSSQLServer startup account in the Enterprise Manager
(this
> change MUST be done here) server's security tab. This should stop and
> restart SQL Server and if all is successfully completed, FTS on a DC
> *should* work...
> Regards,
> John
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > John
> >
> > Is there a log file somewhere that i could try and see what precisely is
> > causing this problem.
> >
> > Thanks
> > "John Kane" <jt-kane@.comcast.net> wrote in message
> > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > Oz,
> > > In addition to the many things you tried below... a couple of things
> > > specific to MSSearch and the MSSQLServer services...
> > > 1. Is the MSSearch service started and running under the System
> > > (LocalSystem) account? If not, then change it to LocalSystem and stop
> and
> > > re-start this service.
> > >
> > > 2. Have you or anyone else change the MSSQLServer account &/or
password
> > via
> > > Win2K's Component service? IF so, then you MUST re-change the change
via
> > the
> > > Enterprise Manager's server property security tab as this is the only
> > place
> > > where the two services security are kept in sync. See KB article
277549
> > > (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> > > MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K
> > Component
> > > Services] at
> > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > >
> > > 3. Have you or anyone else removed or modified the
> BUILTIN\Administrator
> > > login on this server? If so, you MUST either re-add it with all of
it's
> > > normal default rights, especially sysadmin rights and with the default
> > > database as master and the default language of English or use the
> > following
> > > T-SQL code to add the correct permissions:
> > >
> > > exec sp_grantlogin N'NT Authority\System'
> > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > >
> > > Additionally, but not necessarily related to the error in the subject
> > line,
> > > has this server ever been upgrade from SQL Server 7.0 or is this SQL
> > Server
> > > 2000 a "named instance" with a default installation of SQL Server 7.0?
> As
> > > this might be related to a post-SP3 bug. See KB 814035 (Q814035) FIX:
A
> > > Full-Text Population Fails After You Apply SQL Server 2000 Service
Pack
> 3
> > > at:
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> (80004002 -
> > > No such interface supported)
> > >
> > > Regards,
> > > John
> > >
> > >
> > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > Hi,
> > > >
> > > > We have SQL Server private installation on which we are developing
an
> > > > application and public installation on whict we will be deploying
the
> > > > application. All instances have run Windows 2003 Enterprise Edition
> with
> > > SQL
> > > > 2000 SP3. However, the public installation MS Search is not
> functioning
> > > > correctly. Basically it will not full-text indeed databases and
> > produces
> > > > the following error
> > > >
> > > > 1> exec sp_fulltext_database 'enable'
> > > > 2> go
> > > > (1 row affected)
> > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > sp_fulltext_database,
> > > > Lin
> > > > e 46
> > > > The Microsoft Search service cannot be administered under the
present
> > user
> > > > account
> > > >
> > > > Now, we have tried many things to try and solve this error, mainly
> based
> > > on
> > > > search newsgroups, which are itemized below:
> > > >
> > > > 1 Reboot System and reexecute sp_
> > > > 2 Complete reinstall of SQL on system, then reapplication of SP3
> > > > 3 Same as above (2) but reapply SP3a
> > > > 4 Remove SQL Server installation subkey in order that can reinstall
> > > > full-text search only, then reapply SP3
> > > > 5 Check from keys under
> > > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\ to
make
> > > sure
> > > > SQL Server was there. It wasn't, removed SQL subkey and reinstalled,
> > > > re-adding full-text search as an option (to re-install full-text)
then
> > > > reapplied SP3
> > > > 6 Try reinstall, but do not reapply SP3 until have full-text enabled
> the
> > > > database.
> > > >
> > > > None of the above worked. We still have a none functioning mssearch
> and
> > > > full-text disabled database on the system.
> > > >
> > > > We have even tried enabling on a blank database. This does not work
> > > either.
> > > >
> > > > PLEASE HELP! Getting desperate as the whole application depends on
> > having
> > > > search ability.
> > > >
> > > > Thanks
> > > >
> > > > Oz
> > > >
> > > >
> > >
> > >
> >
> >
>|||Also John,
I have always been running a local (i.e. Domain user) account as the SQL
account, althought it is not a member of the administrators group. This is
one of the things i tried (adding it to the admins group), but didn't help.
Thanks
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> You're welcome, Oz,
> Yes, there are MSSearch gatherer log files located under
> \FTDATA\SQLServer\GatherLogs\ that can be "read" using gthrlog.vbs,
however,
> they most likely will have the same error (MSSearch service cannot be
> admin..), so they are of little value in this issue.
> Is this SQL Server installed on a Domain Controller (DC) server or is the
> MSSQLServer startup account the DOMAIN\Administrator account?
> While this should work, it's been my experience that with Full-Text Search
> (FTS) on DC's that this is a problem for the "Microsoft Search" (MSSearch)
> service. If you are using the DOMAIN\Administrator account, create a local
> machine account and add this account into the DC's Administrator Group and
> then change the MSSQLServer startup account in the Enterprise Manager
(this
> change MUST be done here) server's security tab. This should stop and
> restart SQL Server and if all is successfully completed, FTS on a DC
> *should* work...
> Regards,
> John
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > John
> >
> > Is there a log file somewhere that i could try and see what precisely is
> > causing this problem.
> >
> > Thanks
> > "John Kane" <jt-kane@.comcast.net> wrote in message
> > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > Oz,
> > > In addition to the many things you tried below... a couple of things
> > > specific to MSSearch and the MSSQLServer services...
> > > 1. Is the MSSearch service started and running under the System
> > > (LocalSystem) account? If not, then change it to LocalSystem and stop
> and
> > > re-start this service.
> > >
> > > 2. Have you or anyone else change the MSSQLServer account &/or
password
> > via
> > > Win2K's Component service? IF so, then you MUST re-change the change
via
> > the
> > > Enterprise Manager's server property security tab as this is the only
> > place
> > > where the two services security are kept in sync. See KB article
277549
> > > (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> > > MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K
> > Component
> > > Services] at
> > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > >
> > > 3. Have you or anyone else removed or modified the
> BUILTIN\Administrator
> > > login on this server? If so, you MUST either re-add it with all of
it's
> > > normal default rights, especially sysadmin rights and with the default
> > > database as master and the default language of English or use the
> > following
> > > T-SQL code to add the correct permissions:
> > >
> > > exec sp_grantlogin N'NT Authority\System'
> > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > >
> > > Additionally, but not necessarily related to the error in the subject
> > line,
> > > has this server ever been upgrade from SQL Server 7.0 or is this SQL
> > Server
> > > 2000 a "named instance" with a default installation of SQL Server 7.0?
> As
> > > this might be related to a post-SP3 bug. See KB 814035 (Q814035) FIX:
A
> > > Full-Text Population Fails After You Apply SQL Server 2000 Service
Pack
> 3
> > > at:
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> (80004002 -
> > > No such interface supported)
> > >
> > > Regards,
> > > John
> > >
> > >
> > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > Hi,
> > > >
> > > > We have SQL Server private installation on which we are developing
an
> > > > application and public installation on whict we will be deploying
the
> > > > application. All instances have run Windows 2003 Enterprise Edition
> with
> > > SQL
> > > > 2000 SP3. However, the public installation MS Search is not
> functioning
> > > > correctly. Basically it will not full-text indeed databases and
> > produces
> > > > the following error
> > > >
> > > > 1> exec sp_fulltext_database 'enable'
> > > > 2> go
> > > > (1 row affected)
> > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > sp_fulltext_database,
> > > > Lin
> > > > e 46
> > > > The Microsoft Search service cannot be administered under the
present
> > user
> > > > account
> > > >
> > > > Now, we have tried many things to try and solve this error, mainly
> based
> > > on
> > > > search newsgroups, which are itemized below:
> > > >
> > > > 1 Reboot System and reexecute sp_
> > > > 2 Complete reinstall of SQL on system, then reapplication of SP3
> > > > 3 Same as above (2) but reapply SP3a
> > > > 4 Remove SQL Server installation subkey in order that can reinstall
> > > > full-text search only, then reapply SP3
> > > > 5 Check from keys under
> > > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\ to
make
> > > sure
> > > > SQL Server was there. It wasn't, removed SQL subkey and reinstalled,
> > > > re-adding full-text search as an option (to re-install full-text)
then
> > > > reapplied SP3
> > > > 6 Try reinstall, but do not reapply SP3 until have full-text enabled
> the
> > > > database.
> > > >
> > > > None of the above worked. We still have a none functioning mssearch
> and
> > > > full-text disabled database on the system.
> > > >
> > > > We have even tried enabling on a blank database. This does not work
> > > either.
> > > >
> > > > PLEASE HELP! Getting desperate as the whole application depends on
> > having
> > > > search ability.
> > > >
> > > > Thanks
> > > >
> > > > Oz
> > > >
> > > >
> > >
> > >
> >
> >
>|||You're welcome, Oz,
When you said "It's just occurred, to me, there is nothing in those
directories as i cannot enable the database for full-text!"
What directories were you referring to?
Could you change the MSSQLServer service startup account to the system
account (LocalSystem) via the Enterprise Manager's server property security
tab? This should stop and restart SQL Server and attempt to FT-enable the
Pubs database and the authors table and let me know the result of the that?
Thanks,
John
"Oz" <Oz(no_spam)@.nospam.com> wrote in message
news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> Also John,
> I have always been running a local (i.e. Domain user) account as the SQL
> account, althought it is not a member of the administrators group. This
is
> one of the things i tried (adding it to the admins group), but didn't
help.
> Thanks
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > You're welcome, Oz,
> > Yes, there are MSSearch gatherer log files located under
> > \FTDATA\SQLServer\GatherLogs\ that can be "read" using gthrlog.vbs,
> however,
> > they most likely will have the same error (MSSearch service cannot be
> > admin..), so they are of little value in this issue.
> >
> > Is this SQL Server installed on a Domain Controller (DC) server or is
the
> > MSSQLServer startup account the DOMAIN\Administrator account?
> >
> > While this should work, it's been my experience that with Full-Text
Search
> > (FTS) on DC's that this is a problem for the "Microsoft Search"
(MSSearch)
> > service. If you are using the DOMAIN\Administrator account, create a
local
> > machine account and add this account into the DC's Administrator Group
and
> > then change the MSSQLServer startup account in the Enterprise Manager
> (this
> > change MUST be done here) server's security tab. This should stop and
> > restart SQL Server and if all is successfully completed, FTS on a DC
> > *should* work...
> >
> > Regards,
> > John
> >
> >
> >
> > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > John
> > >
> > > Is there a log file somewhere that i could try and see what precisely
is
> > > causing this problem.
> > >
> > > Thanks
> > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > Oz,
> > > > In addition to the many things you tried below... a couple of things
> > > > specific to MSSearch and the MSSQLServer services...
> > > > 1. Is the MSSearch service started and running under the System
> > > > (LocalSystem) account? If not, then change it to LocalSystem and
stop
> > and
> > > > re-start this service.
> > > >
> > > > 2. Have you or anyone else change the MSSQLServer account &/or
> password
> > > via
> > > > Win2K's Component service? IF so, then you MUST re-change the change
> via
> > > the
> > > > Enterprise Manager's server property security tab as this is the
only
> > > place
> > > > where the two services security are kept in sync. See KB article
> 277549
> > > > (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> > > > MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K
> > > Component
> > > > Services] at
> > > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > >
> > > > 3. Have you or anyone else removed or modified the
> > BUILTIN\Administrator
> > > > login on this server? If so, you MUST either re-add it with all of
> it's
> > > > normal default rights, especially sysadmin rights and with the
default
> > > > database as master and the default language of English or use the
> > > following
> > > > T-SQL code to add the correct permissions:
> > > >
> > > > exec sp_grantlogin N'NT Authority\System'
> > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > > >
> > > > Additionally, but not necessarily related to the error in the
subject
> > > line,
> > > > has this server ever been upgrade from SQL Server 7.0 or is this SQL
> > > Server
> > > > 2000 a "named instance" with a default installation of SQL Server
7.0?
> > As
> > > > this might be related to a post-SP3 bug. See KB 814035 (Q814035)
FIX:
> A
> > > > Full-Text Population Fails After You Apply SQL Server 2000 Service
> Pack
> > 3
> > > > at:
> > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > (80004002 -
> > > > No such interface supported)
> > > >
> > > > Regards,
> > > > John
> > > >
> > > >
> > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > Hi,
> > > > >
> > > > > We have SQL Server private installation on which we are developing
> an
> > > > > application and public installation on whict we will be deploying
> the
> > > > > application. All instances have run Windows 2003 Enterprise
Edition
> > with
> > > > SQL
> > > > > 2000 SP3. However, the public installation MS Search is not
> > functioning
> > > > > correctly. Basically it will not full-text indeed databases and
> > > produces
> > > > > the following error
> > > > >
> > > > > 1> exec sp_fulltext_database 'enable'
> > > > > 2> go
> > > > > (1 row affected)
> > > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > > sp_fulltext_database,
> > > > > Lin
> > > > > e 46
> > > > > The Microsoft Search service cannot be administered under the
> present
> > > user
> > > > > account
> > > > >
> > > > > Now, we have tried many things to try and solve this error, mainly
> > based
> > > > on
> > > > > search newsgroups, which are itemized below:
> > > > >
> > > > > 1 Reboot System and reexecute sp_
> > > > > 2 Complete reinstall of SQL on system, then reapplication of SP3
> > > > > 3 Same as above (2) but reapply SP3a
> > > > > 4 Remove SQL Server installation subkey in order that can
reinstall
> > > > > full-text search only, then reapply SP3
> > > > > 5 Check from keys under
> > > > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\ to
> make
> > > > sure
> > > > > SQL Server was there. It wasn't, removed SQL subkey and
reinstalled,
> > > > > re-adding full-text search as an option (to re-install full-text)
> then
> > > > > reapplied SP3
> > > > > 6 Try reinstall, but do not reapply SP3 until have full-text
enabled
> > the
> > > > > database.
> > > > >
> > > > > None of the above worked. We still have a none functioning
mssearch
> > and
> > > > > full-text disabled database on the system.
> > > > >
> > > > > We have even tried enabling on a blank database. This does not
work
> > > > either.
> > > > >
> > > > > PLEASE HELP! Getting desperate as the whole application depends on
> > > having
> > > > > search ability.
> > > > >
> > > > > Thanks
> > > > >
> > > > > Oz
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Ok,
Will do.
I'm talking about the FTData directory. It was there, but it was blank. So
i couldn't check for gatherer files etc.
Thanks
"John Kane" <jt-kane@.comcast.net> wrote in message
news:uBU3C6pNEHA.1340@.TK2MSFTNGP12.phx.gbl...
> You're welcome, Oz,
> When you said "It's just occurred, to me, there is nothing in those
> directories as i cannot enable the database for full-text!"
> What directories were you referring to?
> Could you change the MSSQLServer service startup account to the system
> account (LocalSystem) via the Enterprise Manager's server property
security
> tab? This should stop and restart SQL Server and attempt to FT-enable the
> Pubs database and the authors table and let me know the result of the
that?
> Thanks,
> John
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> > Also John,
> >
> > I have always been running a local (i.e. Domain user) account as the SQL
> > account, althought it is not a member of the administrators group. This
> is
> > one of the things i tried (adding it to the admins group), but didn't
> help.
> >
> > Thanks
> > "John Kane" <jt-kane@.comcast.net> wrote in message
> > news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > > You're welcome, Oz,
> > > Yes, there are MSSearch gatherer log files located under
> > > \FTDATA\SQLServer\GatherLogs\ that can be "read" using gthrlog.vbs,
> > however,
> > > they most likely will have the same error (MSSearch service cannot be
> > > admin..), so they are of little value in this issue.
> > >
> > > Is this SQL Server installed on a Domain Controller (DC) server or is
> the
> > > MSSQLServer startup account the DOMAIN\Administrator account?
> > >
> > > While this should work, it's been my experience that with Full-Text
> Search
> > > (FTS) on DC's that this is a problem for the "Microsoft Search"
> (MSSearch)
> > > service. If you are using the DOMAIN\Administrator account, create a
> local
> > > machine account and add this account into the DC's Administrator Group
> and
> > > then change the MSSQLServer startup account in the Enterprise Manager
> > (this
> > > change MUST be done here) server's security tab. This should stop and
> > > restart SQL Server and if all is successfully completed, FTS on a DC
> > > *should* work...
> > >
> > > Regards,
> > > John
> > >
> > >
> > >
> > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > > John
> > > >
> > > > Is there a log file somewhere that i could try and see what
precisely
> is
> > > > causing this problem.
> > > >
> > > > Thanks
> > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > > Oz,
> > > > > In addition to the many things you tried below... a couple of
things
> > > > > specific to MSSearch and the MSSQLServer services...
> > > > > 1. Is the MSSearch service started and running under the System
> > > > > (LocalSystem) account? If not, then change it to LocalSystem and
> stop
> > > and
> > > > > re-start this service.
> > > > >
> > > > > 2. Have you or anyone else change the MSSQLServer account &/or
> > password
> > > > via
> > > > > Win2K's Component service? IF so, then you MUST re-change the
change
> > via
> > > > the
> > > > > Enterprise Manager's server property security tab as this is the
> only
> > > > place
> > > > > where the two services security are kept in sync. See KB article
> > 277549
> > > > > (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> > > > > MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K
> > > > Component
> > > > > Services] at
> > > > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > > >
> > > > > 3. Have you or anyone else removed or modified the
> > > BUILTIN\Administrator
> > > > > login on this server? If so, you MUST either re-add it with all of
> > it's
> > > > > normal default rights, especially sysadmin rights and with the
> default
> > > > > database as master and the default language of English or use the
> > > > following
> > > > > T-SQL code to add the correct permissions:
> > > > >
> > > > > exec sp_grantlogin N'NT Authority\System'
> > > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > > > >
> > > > > Additionally, but not necessarily related to the error in the
> subject
> > > > line,
> > > > > has this server ever been upgrade from SQL Server 7.0 or is this
SQL
> > > > Server
> > > > > 2000 a "named instance" with a default installation of SQL Server
> 7.0?
> > > As
> > > > > this might be related to a post-SP3 bug. See KB 814035 (Q814035)
> FIX:
> > A
> > > > > Full-Text Population Fails After You Apply SQL Server 2000 Service
> > Pack
> > > 3
> > > > > at:
> > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > > (80004002 -
> > > > > No such interface supported)
> > > > >
> > > > > Regards,
> > > > > John
> > > > >
> > > > >
> > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > > Hi,
> > > > > >
> > > > > > We have SQL Server private installation on which we are
developing
> > an
> > > > > > application and public installation on whict we will be
deploying
> > the
> > > > > > application. All instances have run Windows 2003 Enterprise
> Edition
> > > with
> > > > > SQL
> > > > > > 2000 SP3. However, the public installation MS Search is not
> > > functioning
> > > > > > correctly. Basically it will not full-text indeed databases and
> > > > produces
> > > > > > the following error
> > > > > >
> > > > > > 1> exec sp_fulltext_database 'enable'
> > > > > > 2> go
> > > > > > (1 row affected)
> > > > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > > > sp_fulltext_database,
> > > > > > Lin
> > > > > > e 46
> > > > > > The Microsoft Search service cannot be administered under the
> > present
> > > > user
> > > > > > account
> > > > > >
> > > > > > Now, we have tried many things to try and solve this error,
mainly
> > > based
> > > > > on
> > > > > > search newsgroups, which are itemized below:
> > > > > >
> > > > > > 1 Reboot System and reexecute sp_
> > > > > > 2 Complete reinstall of SQL on system, then reapplication of SP3
> > > > > > 3 Same as above (2) but reapply SP3a
> > > > > > 4 Remove SQL Server installation subkey in order that can
> reinstall
> > > > > > full-text search only, then reapply SP3
> > > > > > 5 Check from keys under
> > > > > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\
to
> > make
> > > > > sure
> > > > > > SQL Server was there. It wasn't, removed SQL subkey and
> reinstalled,
> > > > > > re-adding full-text search as an option (to re-install
full-text)
> > then
> > > > > > reapplied SP3
> > > > > > 6 Try reinstall, but do not reapply SP3 until have full-text
> enabled
> > > the
> > > > > > database.
> > > > > >
> > > > > > None of the above worked. We still have a none functioning
> mssearch
> > > and
> > > > > > full-text disabled database on the system.
> > > > > >
> > > > > > We have even tried enabling on a blank database. This does not
> work
> > > > > either.
> > > > > >
> > > > > > PLEASE HELP! Getting desperate as the whole application depends
on
> > > > having
> > > > > > search ability.
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > > Oz
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Identical error on pubs database John.
Thanks
"John Kane" <jt-kane@.comcast.net> wrote in message
news:uBU3C6pNEHA.1340@.TK2MSFTNGP12.phx.gbl...
> You're welcome, Oz,
> When you said "It's just occurred, to me, there is nothing in those
> directories as i cannot enable the database for full-text!"
> What directories were you referring to?
> Could you change the MSSQLServer service startup account to the system
> account (LocalSystem) via the Enterprise Manager's server property
security
> tab? This should stop and restart SQL Server and attempt to FT-enable the
> Pubs database and the authors table and let me know the result of the
that?
> Thanks,
> John
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> > Also John,
> >
> > I have always been running a local (i.e. Domain user) account as the SQL
> > account, althought it is not a member of the administrators group. This
> is
> > one of the things i tried (adding it to the admins group), but didn't
> help.
> >
> > Thanks
> > "John Kane" <jt-kane@.comcast.net> wrote in message
> > news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > > You're welcome, Oz,
> > > Yes, there are MSSearch gatherer log files located under
> > > \FTDATA\SQLServer\GatherLogs\ that can be "read" using gthrlog.vbs,
> > however,
> > > they most likely will have the same error (MSSearch service cannot be
> > > admin..), so they are of little value in this issue.
> > >
> > > Is this SQL Server installed on a Domain Controller (DC) server or is
> the
> > > MSSQLServer startup account the DOMAIN\Administrator account?
> > >
> > > While this should work, it's been my experience that with Full-Text
> Search
> > > (FTS) on DC's that this is a problem for the "Microsoft Search"
> (MSSearch)
> > > service. If you are using the DOMAIN\Administrator account, create a
> local
> > > machine account and add this account into the DC's Administrator Group
> and
> > > then change the MSSQLServer startup account in the Enterprise Manager
> > (this
> > > change MUST be done here) server's security tab. This should stop and
> > > restart SQL Server and if all is successfully completed, FTS on a DC
> > > *should* work...
> > >
> > > Regards,
> > > John
> > >
> > >
> > >
> > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > > John
> > > >
> > > > Is there a log file somewhere that i could try and see what
precisely
> is
> > > > causing this problem.
> > > >
> > > > Thanks
> > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > > Oz,
> > > > > In addition to the many things you tried below... a couple of
things
> > > > > specific to MSSearch and the MSSQLServer services...
> > > > > 1. Is the MSSearch service started and running under the System
> > > > > (LocalSystem) account? If not, then change it to LocalSystem and
> stop
> > > and
> > > > > re-start this service.
> > > > >
> > > > > 2. Have you or anyone else change the MSSQLServer account &/or
> > password
> > > > via
> > > > > Win2K's Component service? IF so, then you MUST re-change the
change
> > via
> > > > the
> > > > > Enterprise Manager's server property security tab as this is the
> only
> > > > place
> > > > > where the two services security are kept in sync. See KB article
> > 277549
> > > > > (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> > > > > MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K
> > > > Component
> > > > > Services] at
> > > > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > > >
> > > > > 3. Have you or anyone else removed or modified the
> > > BUILTIN\Administrator
> > > > > login on this server? If so, you MUST either re-add it with all of
> > it's
> > > > > normal default rights, especially sysadmin rights and with the
> default
> > > > > database as master and the default language of English or use the
> > > > following
> > > > > T-SQL code to add the correct permissions:
> > > > >
> > > > > exec sp_grantlogin N'NT Authority\System'
> > > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > > > >
> > > > > Additionally, but not necessarily related to the error in the
> subject
> > > > line,
> > > > > has this server ever been upgrade from SQL Server 7.0 or is this
SQL
> > > > Server
> > > > > 2000 a "named instance" with a default installation of SQL Server
> 7.0?
> > > As
> > > > > this might be related to a post-SP3 bug. See KB 814035 (Q814035)
> FIX:
> > A
> > > > > Full-Text Population Fails After You Apply SQL Server 2000 Service
> > Pack
> > > 3
> > > > > at:
> > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > > (80004002 -
> > > > > No such interface supported)
> > > > >
> > > > > Regards,
> > > > > John
> > > > >
> > > > >
> > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > > Hi,
> > > > > >
> > > > > > We have SQL Server private installation on which we are
developing
> > an
> > > > > > application and public installation on whict we will be
deploying
> > the
> > > > > > application. All instances have run Windows 2003 Enterprise
> Edition
> > > with
> > > > > SQL
> > > > > > 2000 SP3. However, the public installation MS Search is not
> > > functioning
> > > > > > correctly. Basically it will not full-text indeed databases and
> > > > produces
> > > > > > the following error
> > > > > >
> > > > > > 1> exec sp_fulltext_database 'enable'
> > > > > > 2> go
> > > > > > (1 row affected)
> > > > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > > > sp_fulltext_database,
> > > > > > Lin
> > > > > > e 46
> > > > > > The Microsoft Search service cannot be administered under the
> > present
> > > > user
> > > > > > account
> > > > > >
> > > > > > Now, we have tried many things to try and solve this error,
mainly
> > > based
> > > > > on
> > > > > > search newsgroups, which are itemized below:
> > > > > >
> > > > > > 1 Reboot System and reexecute sp_
> > > > > > 2 Complete reinstall of SQL on system, then reapplication of SP3
> > > > > > 3 Same as above (2) but reapply SP3a
> > > > > > 4 Remove SQL Server installation subkey in order that can
> reinstall
> > > > > > full-text search only, then reapply SP3
> > > > > > 5 Check from keys under
> > > > > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\
to
> > make
> > > > > sure
> > > > > > SQL Server was there. It wasn't, removed SQL subkey and
> reinstalled,
> > > > > > re-adding full-text search as an option (to re-install
full-text)
> > then
> > > > > > reapplied SP3
> > > > > > 6 Try reinstall, but do not reapply SP3 until have full-text
> enabled
> > > the
> > > > > > database.
> > > > > >
> > > > > > None of the above worked. We still have a none functioning
> mssearch
> > > and
> > > > > > full-text disabled database on the system.
> > > > > >
> > > > > > We have even tried enabling on a blank database. This does not
> work
> > > > > either.
> > > > > >
> > > > > > PLEASE HELP! Getting desperate as the whole application depends
on
> > > > having
> > > > > > search ability.
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > > Oz
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Oz,
When you say that the FTData directory was empty, do you mean NO files, or
just no gatherer log files?
If the former, then this is a problem as the \FTDATA directory should look
something like this (edited):
Directory of F:\MSSQL80\MSSQL\FTDATA
05/14/2003 12:45 PM <DIR> .
05/14/2003 12:45 PM <DIR> ..
12/06/2003 07:21 PM <DIR> SQL0000500005 -- FT Catalog folder
05/14/2003 12:45 PM <DIR> SQLServer
0 File(s) 0 bytes
Directory of F:\MSSQL80\MSSQL\FTDATA\SQL0000500005
Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer
05/14/2003 12:45 PM <DIR> .
05/14/2003 12:45 PM <DIR> ..
05/14/2003 12:45 PM <DIR> Config
05/10/2004 03:30 AM <DIR> GatherLogs
05/14/2003 12:45 PM <DIR> Projects
0 File(s) 0 bytes
Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\Config
05/14/2003 12:45 PM <DIR> .
05/14/2003 12:45 PM <DIR> ..
05/14/2003 12:45 PM 1,771 Gathrprm.Txt
06/16/2000 11:30 PM 1,696 noise.chs
06/16/2000 11:30 PM 1,696 noise.cht
06/16/2000 11:30 PM 687 noise.dat
06/16/2000 11:30 PM 149,848 noise.deu
06/16/2000 11:30 PM 697 noise.eng
06/16/2000 11:30 PM 697 noise.enu
06/16/2000 11:30 PM 19,684 noise.esn
06/16/2000 11:30 PM 49,196 noise.fra
06/16/2000 11:30 PM 19,616 noise.ita
06/16/2000 11:30 PM 10,724 noise.jpn
06/16/2000 11:30 PM 697 noise.kor
06/16/2000 11:30 PM 13,256 noise.nld
06/16/2000 11:30 PM 13,728 noise.sve
04/28/2000 12:06 AM 4,576 Schema.Txt
05/05/2000 04:35 PM 536 tschs.xml
05/05/2000 04:35 PM 536 tscht.xml
05/05/2000 04:35 PM 536 tsdut.xml
05/05/2000 04:35 PM 536 tseng.xml
05/05/2000 04:35 PM 536 tsenu.xml
05/05/2000 04:35 PM 536 tsfra.xml
05/05/2000 04:35 PM 536 tsger.xml
05/05/2000 04:35 PM 536 tsita.xml
05/05/2000 04:35 PM 536 tsjap.xml
05/05/2000 04:35 PM 536 tskor.xml
05/05/2000 04:35 PM 536 tsneu.xml
05/05/2000 04:35 PM 810 tsschema.xml
05/05/2000 04:35 PM 536 tsspa.xml
05/05/2000 04:35 PM 536 tsswe.xml
29 File(s) 296,347 bytes
Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\GatherLogs
05/10/2004 03:30 AM <DIR> .
05/10/2004 03:30 AM <DIR> ..
05/06/2004 04:06 AM 66 SQL0000500005.142.gthr
05/08/2004 03:30 AM 66 SQL0000500005.143.gthr
05/08/2004 06:27 PM 264 SQL0000500005.144.gthr
05/09/2004 04:04 AM 66 SQL0000500005.145.gthr
05/10/2004 03:30 AM 66 SQL0000500005.146.gthr
05/06/2004 04:06 AM 66 SQL0000600005.101.gthr
05/07/2004 03:32 AM 66 SQL0000600005.102.gthr
05/08/2004 06:27 PM 264 SQL0000600005.103.gthr
05/09/2004 04:04 AM 66 SQL0000600005.104.gthr
05/10/2004 03:30 AM 66 SQL0000600005.105.gthr
10 File(s) 1,056 bytes
While you may not have files in the GatherLog dir, you MUST have the above
files in the \FTDATA\SQLServer\Config.
If not, then this *might* be the source of this issue.
Regards,
John
"Oz" <Oz(no_spam)@.nospam.com> wrote in message
news:eTADCIrNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> Ok,
> Will do.
> I'm talking about the FTData directory. It was there, but it was blank.
So
> i couldn't check for gatherer files etc.
> Thanks
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:uBU3C6pNEHA.1340@.TK2MSFTNGP12.phx.gbl...
> > You're welcome, Oz,
> > When you said "It's just occurred, to me, there is nothing in those
> > directories as i cannot enable the database for full-text!"
> > What directories were you referring to?
> >
> > Could you change the MSSQLServer service startup account to the system
> > account (LocalSystem) via the Enterprise Manager's server property
> security
> > tab? This should stop and restart SQL Server and attempt to FT-enable
the
> > Pubs database and the authors table and let me know the result of the
> that?
> >
> > Thanks,
> > John
> >
> >
> >
> > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> > > Also John,
> > >
> > > I have always been running a local (i.e. Domain user) account as the
SQL
> > > account, althought it is not a member of the administrators group.
This
> > is
> > > one of the things i tried (adding it to the admins group), but didn't
> > help.
> > >
> > > Thanks
> > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > > > You're welcome, Oz,
> > > > Yes, there are MSSearch gatherer log files located under
> > > > \FTDATA\SQLServer\GatherLogs\ that can be "read" using gthrlog.vbs,
> > > however,
> > > > they most likely will have the same error (MSSearch service cannot
be
> > > > admin..), so they are of little value in this issue.
> > > >
> > > > Is this SQL Server installed on a Domain Controller (DC) server or
is
> > the
> > > > MSSQLServer startup account the DOMAIN\Administrator account?
> > > >
> > > > While this should work, it's been my experience that with Full-Text
> > Search
> > > > (FTS) on DC's that this is a problem for the "Microsoft Search"
> > (MSSearch)
> > > > service. If you are using the DOMAIN\Administrator account, create a
> > local
> > > > machine account and add this account into the DC's Administrator
Group
> > and
> > > > then change the MSSQLServer startup account in the Enterprise
Manager
> > > (this
> > > > change MUST be done here) server's security tab. This should stop
and
> > > > restart SQL Server and if all is successfully completed, FTS on a DC
> > > > *should* work...
> > > >
> > > > Regards,
> > > > John
> > > >
> > > >
> > > >
> > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > > > John
> > > > >
> > > > > Is there a log file somewhere that i could try and see what
> precisely
> > is
> > > > > causing this problem.
> > > > >
> > > > > Thanks
> > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > > > Oz,
> > > > > > In addition to the many things you tried below... a couple of
> things
> > > > > > specific to MSSearch and the MSSQLServer services...
> > > > > > 1. Is the MSSearch service started and running under the System
> > > > > > (LocalSystem) account? If not, then change it to LocalSystem and
> > stop
> > > > and
> > > > > > re-start this service.
> > > > > >
> > > > > > 2. Have you or anyone else change the MSSQLServer account &/or
> > > password
> > > > > via
> > > > > > Win2K's Component service? IF so, then you MUST re-change the
> change
> > > via
> > > > > the
> > > > > > Enterprise Manager's server property security tab as this is the
> > only
> > > > > place
> > > > > > where the two services security are kept in sync. See KB article
> > > 277549
> > > > > > (Q277549) PRB: Unable to Build Full-Text Catalog After You
Modify
> > > > > > MSSQLServer Logon Account Through [NT4.0) Control Panel [or
Win2K
> > > > > Component
> > > > > > Services] at
> > > > > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > > > >
> > > > > > 3. Have you or anyone else removed or modified the
> > > > BUILTIN\Administrator
> > > > > > login on this server? If so, you MUST either re-add it with all
of
> > > it's
> > > > > > normal default rights, especially sysadmin rights and with the
> > default
> > > > > > database as master and the default language of English or use
the
> > > > > following
> > > > > > T-SQL code to add the correct permissions:
> > > > > >
> > > > > > exec sp_grantlogin N'NT Authority\System'
> > > > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > > > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > > > > >
> > > > > > Additionally, but not necessarily related to the error in the
> > subject
> > > > > line,
> > > > > > has this server ever been upgrade from SQL Server 7.0 or is this
> SQL
> > > > > Server
> > > > > > 2000 a "named instance" with a default installation of SQL
Server
> > 7.0?
> > > > As
> > > > > > this might be related to a post-SP3 bug. See KB 814035 (Q814035)
> > FIX:
> > > A
> > > > > > Full-Text Population Fails After You Apply SQL Server 2000
Service
> > > Pack
> > > > 3
> > > > > > at:
> > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > > > (80004002 -
> > > > > > No such interface supported)
> > > > > >
> > > > > > Regards,
> > > > > > John
> > > > > >
> > > > > >
> > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > > > Hi,
> > > > > > >
> > > > > > > We have SQL Server private installation on which we are
> developing
> > > an
> > > > > > > application and public installation on whict we will be
> deploying
> > > the
> > > > > > > application. All instances have run Windows 2003 Enterprise
> > Edition
> > > > with
> > > > > > SQL
> > > > > > > 2000 SP3. However, the public installation MS Search is not
> > > > functioning
> > > > > > > correctly. Basically it will not full-text indeed databases
and
> > > > > produces
> > > > > > > the following error
> > > > > > >
> > > > > > > 1> exec sp_fulltext_database 'enable'
> > > > > > > 2> go
> > > > > > > (1 row affected)
> > > > > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > > > > sp_fulltext_database,
> > > > > > > Lin
> > > > > > > e 46
> > > > > > > The Microsoft Search service cannot be administered under the
> > > present
> > > > > user
> > > > > > > account
> > > > > > >
> > > > > > > Now, we have tried many things to try and solve this error,
> mainly
> > > > based
> > > > > > on
> > > > > > > search newsgroups, which are itemized below:
> > > > > > >
> > > > > > > 1 Reboot System and reexecute sp_
> > > > > > > 2 Complete reinstall of SQL on system, then reapplication of
SP3
> > > > > > > 3 Same as above (2) but reapply SP3a
> > > > > > > 4 Remove SQL Server installation subkey in order that can
> > reinstall
> > > > > > > full-text search only, then reapply SP3
> > > > > > > 5 Check from keys under
> > > > > > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\
> to
> > > make
> > > > > > sure
> > > > > > > SQL Server was there. It wasn't, removed SQL subkey and
> > reinstalled,
> > > > > > > re-adding full-text search as an option (to re-install
> full-text)
> > > then
> > > > > > > reapplied SP3
> > > > > > > 6 Try reinstall, but do not reapply SP3 until have full-text
> > enabled
> > > > the
> > > > > > > database.
> > > > > > >
> > > > > > > None of the above worked. We still have a none functioning
> > mssearch
> > > > and
> > > > > > > full-text disabled database on the system.
> > > > > > >
> > > > > > > We have even tried enabling on a blank database. This does
not
> > work
> > > > > > either.
> > > > > > >
> > > > > > > PLEASE HELP! Getting desperate as the whole application
depends
> on
> > > > > having
> > > > > > > search ability.
> > > > > > >
> > > > > > > Thanks
> > > > > > >
> > > > > > > Oz
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi John,
Yup, there are NO files at all under the FTDATA directory. what would you
say is the best way of putting them there? Can i just copy them off the
installation disk, or do they need to be installed? What i will try doing
actually removing the installation key, and re-installing Full-Text, to see
if they appear.
Thanks
"John Kane" <jt-kane@.comcast.net> wrote in message
news:u1HdIRwNEHA.892@.TK2MSFTNGP09.phx.gbl...
> Oz,
> When you say that the FTData directory was empty, do you mean NO files, or
> just no gatherer log files?
> If the former, then this is a problem as the \FTDATA directory should look
> something like this (edited):
> Directory of F:\MSSQL80\MSSQL\FTDATA
> 05/14/2003 12:45 PM <DIR> .
> 05/14/2003 12:45 PM <DIR> ..
> 12/06/2003 07:21 PM <DIR> SQL0000500005 -- FT Catalog folder
> 05/14/2003 12:45 PM <DIR> SQLServer
> 0 File(s) 0 bytes
> Directory of F:\MSSQL80\MSSQL\FTDATA\SQL0000500005
> Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer
> 05/14/2003 12:45 PM <DIR> .
> 05/14/2003 12:45 PM <DIR> ..
> 05/14/2003 12:45 PM <DIR> Config
> 05/10/2004 03:30 AM <DIR> GatherLogs
> 05/14/2003 12:45 PM <DIR> Projects
> 0 File(s) 0 bytes
> Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\Config
> 05/14/2003 12:45 PM <DIR> .
> 05/14/2003 12:45 PM <DIR> ..
> 05/14/2003 12:45 PM 1,771 Gathrprm.Txt
> 06/16/2000 11:30 PM 1,696 noise.chs
> 06/16/2000 11:30 PM 1,696 noise.cht
> 06/16/2000 11:30 PM 687 noise.dat
> 06/16/2000 11:30 PM 149,848 noise.deu
> 06/16/2000 11:30 PM 697 noise.eng
> 06/16/2000 11:30 PM 697 noise.enu
> 06/16/2000 11:30 PM 19,684 noise.esn
> 06/16/2000 11:30 PM 49,196 noise.fra
> 06/16/2000 11:30 PM 19,616 noise.ita
> 06/16/2000 11:30 PM 10,724 noise.jpn
> 06/16/2000 11:30 PM 697 noise.kor
> 06/16/2000 11:30 PM 13,256 noise.nld
> 06/16/2000 11:30 PM 13,728 noise.sve
> 04/28/2000 12:06 AM 4,576 Schema.Txt
> 05/05/2000 04:35 PM 536 tschs.xml
> 05/05/2000 04:35 PM 536 tscht.xml
> 05/05/2000 04:35 PM 536 tsdut.xml
> 05/05/2000 04:35 PM 536 tseng.xml
> 05/05/2000 04:35 PM 536 tsenu.xml
> 05/05/2000 04:35 PM 536 tsfra.xml
> 05/05/2000 04:35 PM 536 tsger.xml
> 05/05/2000 04:35 PM 536 tsita.xml
> 05/05/2000 04:35 PM 536 tsjap.xml
> 05/05/2000 04:35 PM 536 tskor.xml
> 05/05/2000 04:35 PM 536 tsneu.xml
> 05/05/2000 04:35 PM 810 tsschema.xml
> 05/05/2000 04:35 PM 536 tsspa.xml
> 05/05/2000 04:35 PM 536 tsswe.xml
> 29 File(s) 296,347 bytes
> Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\GatherLogs
> 05/10/2004 03:30 AM <DIR> .
> 05/10/2004 03:30 AM <DIR> ..
> 05/06/2004 04:06 AM 66 SQL0000500005.142.gthr
> 05/08/2004 03:30 AM 66 SQL0000500005.143.gthr
> 05/08/2004 06:27 PM 264 SQL0000500005.144.gthr
> 05/09/2004 04:04 AM 66 SQL0000500005.145.gthr
> 05/10/2004 03:30 AM 66 SQL0000500005.146.gthr
> 05/06/2004 04:06 AM 66 SQL0000600005.101.gthr
> 05/07/2004 03:32 AM 66 SQL0000600005.102.gthr
> 05/08/2004 06:27 PM 264 SQL0000600005.103.gthr
> 05/09/2004 04:04 AM 66 SQL0000600005.104.gthr
> 05/10/2004 03:30 AM 66 SQL0000600005.105.gthr
> 10 File(s) 1,056 bytes
>
> While you may not have files in the GatherLog dir, you MUST have the above
> files in the \FTDATA\SQLServer\Config.
> If not, then this *might* be the source of this issue.
> Regards,
> John
>
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:eTADCIrNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> > Ok,
> >
> > Will do.
> >
> > I'm talking about the FTData directory. It was there, but it was blank.
> So
> > i couldn't check for gatherer files etc.
> >
> > Thanks
> > "John Kane" <jt-kane@.comcast.net> wrote in message
> > news:uBU3C6pNEHA.1340@.TK2MSFTNGP12.phx.gbl...
> > > You're welcome, Oz,
> > > When you said "It's just occurred, to me, there is nothing in those
> > > directories as i cannot enable the database for full-text!"
> > > What directories were you referring to?
> > >
> > > Could you change the MSSQLServer service startup account to the system
> > > account (LocalSystem) via the Enterprise Manager's server property
> > security
> > > tab? This should stop and restart SQL Server and attempt to FT-enable
> the
> > > Pubs database and the authors table and let me know the result of the
> > that?
> > >
> > > Thanks,
> > > John
> > >
> > >
> > >
> > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> > > > Also John,
> > > >
> > > > I have always been running a local (i.e. Domain user) account as the
> SQL
> > > > account, althought it is not a member of the administrators group.
> This
> > > is
> > > > one of the things i tried (adding it to the admins group), but
didn't
> > > help.
> > > >
> > > > Thanks
> > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > > > > You're welcome, Oz,
> > > > > Yes, there are MSSearch gatherer log files located under
> > > > > \FTDATA\SQLServer\GatherLogs\ that can be "read" using
gthrlog.vbs,
> > > > however,
> > > > > they most likely will have the same error (MSSearch service cannot
> be
> > > > > admin..), so they are of little value in this issue.
> > > > >
> > > > > Is this SQL Server installed on a Domain Controller (DC) server or
> is
> > > the
> > > > > MSSQLServer startup account the DOMAIN\Administrator account?
> > > > >
> > > > > While this should work, it's been my experience that with
Full-Text
> > > Search
> > > > > (FTS) on DC's that this is a problem for the "Microsoft Search"
> > > (MSSearch)
> > > > > service. If you are using the DOMAIN\Administrator account, create
a
> > > local
> > > > > machine account and add this account into the DC's Administrator
> Group
> > > and
> > > > > then change the MSSQLServer startup account in the Enterprise
> Manager
> > > > (this
> > > > > change MUST be done here) server's security tab. This should stop
> and
> > > > > restart SQL Server and if all is successfully completed, FTS on a
DC
> > > > > *should* work...
> > > > >
> > > > > Regards,
> > > > > John
> > > > >
> > > > >
> > > > >
> > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > > > > John
> > > > > >
> > > > > > Is there a log file somewhere that i could try and see what
> > precisely
> > > is
> > > > > > causing this problem.
> > > > > >
> > > > > > Thanks
> > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > > > > Oz,
> > > > > > > In addition to the many things you tried below... a couple of
> > things
> > > > > > > specific to MSSearch and the MSSQLServer services...
> > > > > > > 1. Is the MSSearch service started and running under the
System
> > > > > > > (LocalSystem) account? If not, then change it to LocalSystem
and
> > > stop
> > > > > and
> > > > > > > re-start this service.
> > > > > > >
> > > > > > > 2. Have you or anyone else change the MSSQLServer account &/or
> > > > password
> > > > > > via
> > > > > > > Win2K's Component service? IF so, then you MUST re-change the
> > change
> > > > via
> > > > > > the
> > > > > > > Enterprise Manager's server property security tab as this is
the
> > > only
> > > > > > place
> > > > > > > where the two services security are kept in sync. See KB
article
> > > > 277549
> > > > > > > (Q277549) PRB: Unable to Build Full-Text Catalog After You
> Modify
> > > > > > > MSSQLServer Logon Account Through [NT4.0) Control Panel [or
> Win2K
> > > > > > Component
> > > > > > > Services] at
> > > > > > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > > > > >
> > > > > > > 3. Have you or anyone else removed or modified the
> > > > > BUILTIN\Administrator
> > > > > > > login on this server? If so, you MUST either re-add it with
all
> of
> > > > it's
> > > > > > > normal default rights, especially sysadmin rights and with the
> > > default
> > > > > > > database as master and the default language of English or use
> the
> > > > > > following
> > > > > > > T-SQL code to add the correct permissions:
> > > > > > >
> > > > > > > exec sp_grantlogin N'NT Authority\System'
> > > > > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > > > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > > > > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > > > > > >
> > > > > > > Additionally, but not necessarily related to the error in the
> > > subject
> > > > > > line,
> > > > > > > has this server ever been upgrade from SQL Server 7.0 or is
this
> > SQL
> > > > > > Server
> > > > > > > 2000 a "named instance" with a default installation of SQL
> Server
> > > 7.0?
> > > > > As
> > > > > > > this might be related to a post-SP3 bug. See KB 814035
(Q814035)
> > > FIX:
> > > > A
> > > > > > > Full-Text Population Fails After You Apply SQL Server 2000
> Service
> > > > Pack
> > > > > 3
> > > > > > > at:
> > > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > > > > (80004002 -
> > > > > > > No such interface supported)
> > > > > > >
> > > > > > > Regards,
> > > > > > > John
> > > > > > >
> > > > > > >
> > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > We have SQL Server private installation on which we are
> > developing
> > > > an
> > > > > > > > application and public installation on whict we will be
> > deploying
> > > > the
> > > > > > > > application. All instances have run Windows 2003 Enterprise
> > > Edition
> > > > > with
> > > > > > > SQL
> > > > > > > > 2000 SP3. However, the public installation MS Search is not
> > > > > functioning
> > > > > > > > correctly. Basically it will not full-text indeed databases
> and
> > > > > > produces
> > > > > > > > the following error
> > > > > > > >
> > > > > > > > 1> exec sp_fulltext_database 'enable'
> > > > > > > > 2> go
> > > > > > > > (1 row affected)
> > > > > > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > > > > > sp_fulltext_database,
> > > > > > > > Lin
> > > > > > > > e 46
> > > > > > > > The Microsoft Search service cannot be administered under
the
> > > > present
> > > > > > user
> > > > > > > > account
> > > > > > > >
> > > > > > > > Now, we have tried many things to try and solve this error,
> > mainly
> > > > > based
> > > > > > > on
> > > > > > > > search newsgroups, which are itemized below:
> > > > > > > >
> > > > > > > > 1 Reboot System and reexecute sp_
> > > > > > > > 2 Complete reinstall of SQL on system, then reapplication of
> SP3
> > > > > > > > 3 Same as above (2) but reapply SP3a
> > > > > > > > 4 Remove SQL Server installation subkey in order that can
> > > reinstall
> > > > > > > > full-text search only, then reapply SP3
> > > > > > > > 5 Check from keys under
> > > > > > > >
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\
> > to
> > > > make
> > > > > > > sure
> > > > > > > > SQL Server was there. It wasn't, removed SQL subkey and
> > > reinstalled,
> > > > > > > > re-adding full-text search as an option (to re-install
> > full-text)
> > > > then
> > > > > > > > reapplied SP3
> > > > > > > > 6 Try reinstall, but do not reapply SP3 until have full-text
> > > enabled
> > > > > the
> > > > > > > > database.
> > > > > > > >
> > > > > > > > None of the above worked. We still have a none functioning
> > > mssearch
> > > > > and
> > > > > > > > full-text disabled database on the system.
> > > > > > > >
> > > > > > > > We have even tried enabling on a blank database. This does
> not
> > > work
> > > > > > > either.
> > > > > > > >
> > > > > > > > PLEASE HELP! Getting desperate as the whole application
> depends
> > on
> > > > > > having
> > > > > > > > search ability.
> > > > > > > >
> > > > > > > > Thanks
> > > > > > > >
> > > > > > > > Oz
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||John,
I did that and therefore reinstalled full-text. Actually i have done this
before, but it's worth walking through it again with you as you may see
something i don't. I have not yet applied SP3 to the new full-text
installation. However, what i get now is another error.
'Execution of full-text operation failed. The parameter is incorrect'
I have also manually tried running
sp_fulltext_database 'enable'
and that is the same error generated.
I used to FT wizard to try and create the FT index.
Do you see anything here?
Thanks
"John Kane" <jt-kane@.comcast.net> wrote in message
news:u1HdIRwNEHA.892@.TK2MSFTNGP09.phx.gbl...
> Oz,
> When you say that the FTData directory was empty, do you mean NO files, or
> just no gatherer log files?
> If the former, then this is a problem as the \FTDATA directory should look
> something like this (edited):
> Directory of F:\MSSQL80\MSSQL\FTDATA
> 05/14/2003 12:45 PM <DIR> .
> 05/14/2003 12:45 PM <DIR> ..
> 12/06/2003 07:21 PM <DIR> SQL0000500005 -- FT Catalog folder
> 05/14/2003 12:45 PM <DIR> SQLServer
> 0 File(s) 0 bytes
> Directory of F:\MSSQL80\MSSQL\FTDATA\SQL0000500005
> Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer
> 05/14/2003 12:45 PM <DIR> .
> 05/14/2003 12:45 PM <DIR> ..
> 05/14/2003 12:45 PM <DIR> Config
> 05/10/2004 03:30 AM <DIR> GatherLogs
> 05/14/2003 12:45 PM <DIR> Projects
> 0 File(s) 0 bytes
> Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\Config
> 05/14/2003 12:45 PM <DIR> .
> 05/14/2003 12:45 PM <DIR> ..
> 05/14/2003 12:45 PM 1,771 Gathrprm.Txt
> 06/16/2000 11:30 PM 1,696 noise.chs
> 06/16/2000 11:30 PM 1,696 noise.cht
> 06/16/2000 11:30 PM 687 noise.dat
> 06/16/2000 11:30 PM 149,848 noise.deu
> 06/16/2000 11:30 PM 697 noise.eng
> 06/16/2000 11:30 PM 697 noise.enu
> 06/16/2000 11:30 PM 19,684 noise.esn
> 06/16/2000 11:30 PM 49,196 noise.fra
> 06/16/2000 11:30 PM 19,616 noise.ita
> 06/16/2000 11:30 PM 10,724 noise.jpn
> 06/16/2000 11:30 PM 697 noise.kor
> 06/16/2000 11:30 PM 13,256 noise.nld
> 06/16/2000 11:30 PM 13,728 noise.sve
> 04/28/2000 12:06 AM 4,576 Schema.Txt
> 05/05/2000 04:35 PM 536 tschs.xml
> 05/05/2000 04:35 PM 536 tscht.xml
> 05/05/2000 04:35 PM 536 tsdut.xml
> 05/05/2000 04:35 PM 536 tseng.xml
> 05/05/2000 04:35 PM 536 tsenu.xml
> 05/05/2000 04:35 PM 536 tsfra.xml
> 05/05/2000 04:35 PM 536 tsger.xml
> 05/05/2000 04:35 PM 536 tsita.xml
> 05/05/2000 04:35 PM 536 tsjap.xml
> 05/05/2000 04:35 PM 536 tskor.xml
> 05/05/2000 04:35 PM 536 tsneu.xml
> 05/05/2000 04:35 PM 810 tsschema.xml
> 05/05/2000 04:35 PM 536 tsspa.xml
> 05/05/2000 04:35 PM 536 tsswe.xml
> 29 File(s) 296,347 bytes
> Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\GatherLogs
> 05/10/2004 03:30 AM <DIR> .
> 05/10/2004 03:30 AM <DIR> ..
> 05/06/2004 04:06 AM 66 SQL0000500005.142.gthr
> 05/08/2004 03:30 AM 66 SQL0000500005.143.gthr
> 05/08/2004 06:27 PM 264 SQL0000500005.144.gthr
> 05/09/2004 04:04 AM 66 SQL0000500005.145.gthr
> 05/10/2004 03:30 AM 66 SQL0000500005.146.gthr
> 05/06/2004 04:06 AM 66 SQL0000600005.101.gthr
> 05/07/2004 03:32 AM 66 SQL0000600005.102.gthr
> 05/08/2004 06:27 PM 264 SQL0000600005.103.gthr
> 05/09/2004 04:04 AM 66 SQL0000600005.104.gthr
> 05/10/2004 03:30 AM 66 SQL0000600005.105.gthr
> 10 File(s) 1,056 bytes
>
> While you may not have files in the GatherLog dir, you MUST have the above
> files in the \FTDATA\SQLServer\Config.
> If not, then this *might* be the source of this issue.
> Regards,
> John
>
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:eTADCIrNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> > Ok,
> >
> > Will do.
> >
> > I'm talking about the FTData directory. It was there, but it was blank.
> So
> > i couldn't check for gatherer files etc.
> >
> > Thanks
> > "John Kane" <jt-kane@.comcast.net> wrote in message
> > news:uBU3C6pNEHA.1340@.TK2MSFTNGP12.phx.gbl...
> > > You're welcome, Oz,
> > > When you said "It's just occurred, to me, there is nothing in those
> > > directories as i cannot enable the database for full-text!"
> > > What directories were you referring to?
> > >
> > > Could you change the MSSQLServer service startup account to the system
> > > account (LocalSystem) via the Enterprise Manager's server property
> > security
> > > tab? This should stop and restart SQL Server and attempt to FT-enable
> the
> > > Pubs database and the authors table and let me know the result of the
> > that?
> > >
> > > Thanks,
> > > John
> > >
> > >
> > >
> > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> > > > Also John,
> > > >
> > > > I have always been running a local (i.e. Domain user) account as the
> SQL
> > > > account, althought it is not a member of the administrators group.
> This
> > > is
> > > > one of the things i tried (adding it to the admins group), but
didn't
> > > help.
> > > >
> > > > Thanks
> > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > > > > You're welcome, Oz,
> > > > > Yes, there are MSSearch gatherer log files located under
> > > > > \FTDATA\SQLServer\GatherLogs\ that can be "read" using
gthrlog.vbs,
> > > > however,
> > > > > they most likely will have the same error (MSSearch service cannot
> be
> > > > > admin..), so they are of little value in this issue.
> > > > >
> > > > > Is this SQL Server installed on a Domain Controller (DC) server or
> is
> > > the
> > > > > MSSQLServer startup account the DOMAIN\Administrator account?
> > > > >
> > > > > While this should work, it's been my experience that with
Full-Text
> > > Search
> > > > > (FTS) on DC's that this is a problem for the "Microsoft Search"
> > > (MSSearch)
> > > > > service. If you are using the DOMAIN\Administrator account, create
a
> > > local
> > > > > machine account and add this account into the DC's Administrator
> Group
> > > and
> > > > > then change the MSSQLServer startup account in the Enterprise
> Manager
> > > > (this
> > > > > change MUST be done here) server's security tab. This should stop
> and
> > > > > restart SQL Server and if all is successfully completed, FTS on a
DC
> > > > > *should* work...
> > > > >
> > > > > Regards,
> > > > > John
> > > > >
> > > > >
> > > > >
> > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > > > > John
> > > > > >
> > > > > > Is there a log file somewhere that i could try and see what
> > precisely
> > > is
> > > > > > causing this problem.
> > > > > >
> > > > > > Thanks
> > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > > > > Oz,
> > > > > > > In addition to the many things you tried below... a couple of
> > things
> > > > > > > specific to MSSearch and the MSSQLServer services...
> > > > > > > 1. Is the MSSearch service started and running under the
System
> > > > > > > (LocalSystem) account? If not, then change it to LocalSystem
and
> > > stop
> > > > > and
> > > > > > > re-start this service.
> > > > > > >
> > > > > > > 2. Have you or anyone else change the MSSQLServer account &/or
> > > > password
> > > > > > via
> > > > > > > Win2K's Component service? IF so, then you MUST re-change the
> > change
> > > > via
> > > > > > the
> > > > > > > Enterprise Manager's server property security tab as this is
the
> > > only
> > > > > > place
> > > > > > > where the two services security are kept in sync. See KB
article
> > > > 277549
> > > > > > > (Q277549) PRB: Unable to Build Full-Text Catalog After You
> Modify
> > > > > > > MSSQLServer Logon Account Through [NT4.0) Control Panel [or
> Win2K
> > > > > > Component
> > > > > > > Services] at
> > > > > > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > > > > >
> > > > > > > 3. Have you or anyone else removed or modified the
> > > > > BUILTIN\Administrator
> > > > > > > login on this server? If so, you MUST either re-add it with
all
> of
> > > > it's
> > > > > > > normal default rights, especially sysadmin rights and with the
> > > default
> > > > > > > database as master and the default language of English or use
> the
> > > > > > following
> > > > > > > T-SQL code to add the correct permissions:
> > > > > > >
> > > > > > > exec sp_grantlogin N'NT Authority\System'
> > > > > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > > > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > > > > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > > > > > >
> > > > > > > Additionally, but not necessarily related to the error in the
> > > subject
> > > > > > line,
> > > > > > > has this server ever been upgrade from SQL Server 7.0 or is
this
> > SQL
> > > > > > Server
> > > > > > > 2000 a "named instance" with a default installation of SQL
> Server
> > > 7.0?
> > > > > As
> > > > > > > this might be related to a post-SP3 bug. See KB 814035
(Q814035)
> > > FIX:
> > > > A
> > > > > > > Full-Text Population Fails After You Apply SQL Server 2000
> Service
> > > > Pack
> > > > > 3
> > > > > > > at:
> > > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > > > > (80004002 -
> > > > > > > No such interface supported)
> > > > > > >
> > > > > > > Regards,
> > > > > > > John
> > > > > > >
> > > > > > >
> > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > We have SQL Server private installation on which we are
> > developing
> > > > an
> > > > > > > > application and public installation on whict we will be
> > deploying
> > > > the
> > > > > > > > application. All instances have run Windows 2003 Enterprise
> > > Edition
> > > > > with
> > > > > > > SQL
> > > > > > > > 2000 SP3. However, the public installation MS Search is not
> > > > > functioning
> > > > > > > > correctly. Basically it will not full-text indeed databases
> and
> > > > > > produces
> > > > > > > > the following error
> > > > > > > >
> > > > > > > > 1> exec sp_fulltext_database 'enable'
> > > > > > > > 2> go
> > > > > > > > (1 row affected)
> > > > > > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > > > > > sp_fulltext_database,
> > > > > > > > Lin
> > > > > > > > e 46
> > > > > > > > The Microsoft Search service cannot be administered under
the
> > > > present
> > > > > > user
> > > > > > > > account
> > > > > > > >
> > > > > > > > Now, we have tried many things to try and solve this error,
> > mainly
> > > > > based
> > > > > > > on
> > > > > > > > search newsgroups, which are itemized below:
> > > > > > > >
> > > > > > > > 1 Reboot System and reexecute sp_
> > > > > > > > 2 Complete reinstall of SQL on system, then reapplication of
> SP3
> > > > > > > > 3 Same as above (2) but reapply SP3a
> > > > > > > > 4 Remove SQL Server installation subkey in order that can
> > > reinstall
> > > > > > > > full-text search only, then reapply SP3
> > > > > > > > 5 Check from keys under
> > > > > > > >
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\
> > to
> > > > make
> > > > > > > sure
> > > > > > > > SQL Server was there. It wasn't, removed SQL subkey and
> > > reinstalled,
> > > > > > > > re-adding full-text search as an option (to re-install
> > full-text)
> > > > then
> > > > > > > > reapplied SP3
> > > > > > > > 6 Try reinstall, but do not reapply SP3 until have full-text
> > > enabled
> > > > > the
> > > > > > > > database.
> > > > > > > >
> > > > > > > > None of the above worked. We still have a none functioning
> > > mssearch
> > > > > and
> > > > > > > > full-text disabled database on the system.
> > > > > > > >
> > > > > > > > We have even tried enabling on a blank database. This does
> not
> > > work
> > > > > > > either.
> > > > > > > >
> > > > > > > > PLEASE HELP! Getting desperate as the whole application
> depends
> > on
> > > > > > having
> > > > > > > > search ability.
> > > > > > > >
> > > > > > > > Thanks
> > > > > > > >
> > > > > > > > Oz
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Oz,
This seems to be an installation gone really bad... Below are the
instructions, I've posted in this newsgroup that has been very successful in
resolving a number of SQL FTS related issues. However, with the new error
(The parameter is incorrect), this re-installation may or may NOT be
successful and you may have to remove SQL Server and the MSSearch components
and re-install SQL Server again.
Re-install" the "Full-text Search" components via deleting (or renaming) the
below "tracking key" and re-install (If you're not using a named instance,
remove "<Instance_Name>\".)
NOTE: be sure to be logged on to the server as either Administrator or as a
member of the server's Admin Group!
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
Once you've done removed (renamed) the above tracking key, then delete the
MSSearch directory from either:
drive_letter:\Program Files\Common Files\Microsoft Shared\
or
drive_letter::\Program Files\Common Files\System\
Then using your SQL Server 2000 installation CD re-install via "Custom
Installation" the Full-Text Search component (it should be un-checked). When
this completes find and save these files: SearchSetup.log (usually under
\windows or \winnt folders) and sqlsp.log. If any problems, please post
these files.
Re-install SQL Server 2000 Service pack (SP3) if this service has been
applied, so that the newly installed MSSearch components are upgraded to
SP3a levels and then re-boot &/or restart the MSSearch and MSSQLServer
services.
Note, if the method above fails (and there are other methods) you might need
to open a support case with Microsoft PSS SQL Server Support...
Regards,
John
"Oz" <Oz(no_spam)@.nospam.com> wrote in message
news:O6wrjyxNEHA.3816@.TK2MSFTNGP12.phx.gbl...
> John,
> I did that and therefore reinstalled full-text. Actually i have done this
> before, but it's worth walking through it again with you as you may see
> something i don't. I have not yet applied SP3 to the new full-text
> installation. However, what i get now is another error.
> 'Execution of full-text operation failed. The parameter is incorrect'
> I have also manually tried running
> sp_fulltext_database 'enable'
> and that is the same error generated.
> I used to FT wizard to try and create the FT index.
> Do you see anything here?
> Thanks
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:u1HdIRwNEHA.892@.TK2MSFTNGP09.phx.gbl...
> > Oz,
> > When you say that the FTData directory was empty, do you mean NO files,
or
> > just no gatherer log files?
> > If the former, then this is a problem as the \FTDATA directory should
look
> > something like this (edited):
> >
> > Directory of F:\MSSQL80\MSSQL\FTDATA
> >
> > 05/14/2003 12:45 PM <DIR> .
> > 05/14/2003 12:45 PM <DIR> ..
> > 12/06/2003 07:21 PM <DIR> SQL0000500005 -- FT Catalog
folder
> > 05/14/2003 12:45 PM <DIR> SQLServer
> > 0 File(s) 0 bytes
> >
> > Directory of F:\MSSQL80\MSSQL\FTDATA\SQL0000500005
> >
> > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer
> >
> > 05/14/2003 12:45 PM <DIR> .
> > 05/14/2003 12:45 PM <DIR> ..
> > 05/14/2003 12:45 PM <DIR> Config
> > 05/10/2004 03:30 AM <DIR> GatherLogs
> > 05/14/2003 12:45 PM <DIR> Projects
> > 0 File(s) 0 bytes
> >
> > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\Config
> >
> > 05/14/2003 12:45 PM <DIR> .
> > 05/14/2003 12:45 PM <DIR> ..
> > 05/14/2003 12:45 PM 1,771 Gathrprm.Txt
> > 06/16/2000 11:30 PM 1,696 noise.chs
> > 06/16/2000 11:30 PM 1,696 noise.cht
> > 06/16/2000 11:30 PM 687 noise.dat
> > 06/16/2000 11:30 PM 149,848 noise.deu
> > 06/16/2000 11:30 PM 697 noise.eng
> > 06/16/2000 11:30 PM 697 noise.enu
> > 06/16/2000 11:30 PM 19,684 noise.esn
> > 06/16/2000 11:30 PM 49,196 noise.fra
> > 06/16/2000 11:30 PM 19,616 noise.ita
> > 06/16/2000 11:30 PM 10,724 noise.jpn
> > 06/16/2000 11:30 PM 697 noise.kor
> > 06/16/2000 11:30 PM 13,256 noise.nld
> > 06/16/2000 11:30 PM 13,728 noise.sve
> > 04/28/2000 12:06 AM 4,576 Schema.Txt
> > 05/05/2000 04:35 PM 536 tschs.xml
> > 05/05/2000 04:35 PM 536 tscht.xml
> > 05/05/2000 04:35 PM 536 tsdut.xml
> > 05/05/2000 04:35 PM 536 tseng.xml
> > 05/05/2000 04:35 PM 536 tsenu.xml
> > 05/05/2000 04:35 PM 536 tsfra.xml
> > 05/05/2000 04:35 PM 536 tsger.xml
> > 05/05/2000 04:35 PM 536 tsita.xml
> > 05/05/2000 04:35 PM 536 tsjap.xml
> > 05/05/2000 04:35 PM 536 tskor.xml
> > 05/05/2000 04:35 PM 536 tsneu.xml
> > 05/05/2000 04:35 PM 810 tsschema.xml
> > 05/05/2000 04:35 PM 536 tsspa.xml
> > 05/05/2000 04:35 PM 536 tsswe.xml
> > 29 File(s) 296,347 bytes
> >
> > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\GatherLogs
> >
> > 05/10/2004 03:30 AM <DIR> .
> > 05/10/2004 03:30 AM <DIR> ..
> > 05/06/2004 04:06 AM 66 SQL0000500005.142.gthr
> > 05/08/2004 03:30 AM 66 SQL0000500005.143.gthr
> > 05/08/2004 06:27 PM 264 SQL0000500005.144.gthr
> > 05/09/2004 04:04 AM 66 SQL0000500005.145.gthr
> > 05/10/2004 03:30 AM 66 SQL0000500005.146.gthr
> > 05/06/2004 04:06 AM 66 SQL0000600005.101.gthr
> > 05/07/2004 03:32 AM 66 SQL0000600005.102.gthr
> > 05/08/2004 06:27 PM 264 SQL0000600005.103.gthr
> > 05/09/2004 04:04 AM 66 SQL0000600005.104.gthr
> > 05/10/2004 03:30 AM 66 SQL0000600005.105.gthr
> > 10 File(s) 1,056 bytes
> >
> >
> > While you may not have files in the GatherLog dir, you MUST have the
above
> > files in the \FTDATA\SQLServer\Config.
> > If not, then this *might* be the source of this issue.
> >
> > Regards,
> > John
> >
> >
> >
> >
> > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > news:eTADCIrNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> > > Ok,
> > >
> > > Will do.
> > >
> > > I'm talking about the FTData directory. It was there, but it was
blank.
> > So
> > > i couldn't check for gatherer files etc.
> > >
> > > Thanks
> > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > news:uBU3C6pNEHA.1340@.TK2MSFTNGP12.phx.gbl...
> > > > You're welcome, Oz,
> > > > When you said "It's just occurred, to me, there is nothing in those
> > > > directories as i cannot enable the database for full-text!"
> > > > What directories were you referring to?
> > > >
> > > > Could you change the MSSQLServer service startup account to the
system
> > > > account (LocalSystem) via the Enterprise Manager's server property
> > > security
> > > > tab? This should stop and restart SQL Server and attempt to
FT-enable
> > the
> > > > Pubs database and the authors table and let me know the result of
the
> > > that?
> > > >
> > > > Thanks,
> > > > John
> > > >
> > > >
> > > >
> > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > Also John,
> > > > >
> > > > > I have always been running a local (i.e. Domain user) account as
the
> > SQL
> > > > > account, althought it is not a member of the administrators group.
> > This
> > > > is
> > > > > one of the things i tried (adding it to the admins group), but
> didn't
> > > > help.
> > > > >
> > > > > Thanks
> > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > > > > > You're welcome, Oz,
> > > > > > Yes, there are MSSearch gatherer log files located under
> > > > > > \FTDATA\SQLServer\GatherLogs\ that can be "read" using
> gthrlog.vbs,
> > > > > however,
> > > > > > they most likely will have the same error (MSSearch service
cannot
> > be
> > > > > > admin..), so they are of little value in this issue.
> > > > > >
> > > > > > Is this SQL Server installed on a Domain Controller (DC) server
or
> > is
> > > > the
> > > > > > MSSQLServer startup account the DOMAIN\Administrator account?
> > > > > >
> > > > > > While this should work, it's been my experience that with
> Full-Text
> > > > Search
> > > > > > (FTS) on DC's that this is a problem for the "Microsoft Search"
> > > > (MSSearch)
> > > > > > service. If you are using the DOMAIN\Administrator account,
create
> a
> > > > local
> > > > > > machine account and add this account into the DC's Administrator
> > Group
> > > > and
> > > > > > then change the MSSQLServer startup account in the Enterprise
> > Manager
> > > > > (this
> > > > > > change MUST be done here) server's security tab. This should
stop
> > and
> > > > > > restart SQL Server and if all is successfully completed, FTS on
a
> DC
> > > > > > *should* work...
> > > > > >
> > > > > > Regards,
> > > > > > John
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > > > > > John
> > > > > > >
> > > > > > > Is there a log file somewhere that i could try and see what
> > > precisely
> > > > is
> > > > > > > causing this problem.
> > > > > > >
> > > > > > > Thanks
> > > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > > > > > Oz,
> > > > > > > > In addition to the many things you tried below... a couple
of
> > > things
> > > > > > > > specific to MSSearch and the MSSQLServer services...
> > > > > > > > 1. Is the MSSearch service started and running under the
> System
> > > > > > > > (LocalSystem) account? If not, then change it to LocalSystem
> and
> > > > stop
> > > > > > and
> > > > > > > > re-start this service.
> > > > > > > >
> > > > > > > > 2. Have you or anyone else change the MSSQLServer account
&/or
> > > > > password
> > > > > > > via
> > > > > > > > Win2K's Component service? IF so, then you MUST re-change
the
> > > change
> > > > > via
> > > > > > > the
> > > > > > > > Enterprise Manager's server property security tab as this is
> the
> > > > only
> > > > > > > place
> > > > > > > > where the two services security are kept in sync. See KB
> article
> > > > > 277549
> > > > > > > > (Q277549) PRB: Unable to Build Full-Text Catalog After You
> > Modify
> > > > > > > > MSSQLServer Logon Account Through [NT4.0) Control Panel [or
> > Win2K
> > > > > > > Component
> > > > > > > > Services] at
> > > > > > > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > > > > > >
> > > > > > > > 3. Have you or anyone else removed or modified the
> > > > > > BUILTIN\Administrator
> > > > > > > > login on this server? If so, you MUST either re-add it with
> all
> > of
> > > > > it's
> > > > > > > > normal default rights, especially sysadmin rights and with
the
> > > > default
> > > > > > > > database as master and the default language of English or
use
> > the
> > > > > > > following
> > > > > > > > T-SQL code to add the correct permissions:
> > > > > > > >
> > > > > > > > exec sp_grantlogin N'NT Authority\System'
> > > > > > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > > > > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > > > > > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > > > > > > >
> > > > > > > > Additionally, but not necessarily related to the error in
the
> > > > subject
> > > > > > > line,
> > > > > > > > has this server ever been upgrade from SQL Server 7.0 or is
> this
> > > SQL
> > > > > > > Server
> > > > > > > > 2000 a "named instance" with a default installation of SQL
> > Server
> > > > 7.0?
> > > > > > As
> > > > > > > > this might be related to a post-SP3 bug. See KB 814035
> (Q814035)
> > > > FIX:
> > > > > A
> > > > > > > > Full-Text Population Fails After You Apply SQL Server 2000
> > Service
> > > > > Pack
> > > > > > 3
> > > > > > > > at:
> > > > > > > >
http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > > > > > (80004002 -
> > > > > > > > No such interface supported)
> > > > > > > >
> > > > > > > > Regards,
> > > > > > > > John
> > > > > > > >
> > > > > > > >
> > > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > We have SQL Server private installation on which we are
> > > developing
> > > > > an
> > > > > > > > > application and public installation on whict we will be
> > > deploying
> > > > > the
> > > > > > > > > application. All instances have run Windows 2003
Enterprise
> > > > Edition
> > > > > > with
> > > > > > > > SQL
> > > > > > > > > 2000 SP3. However, the public installation MS Search is
not
> > > > > > functioning
> > > > > > > > > correctly. Basically it will not full-text indeed
databases
> > and
> > > > > > > produces
> > > > > > > > > the following error
> > > > > > > > >
> > > > > > > > > 1> exec sp_fulltext_database 'enable'
> > > > > > > > > 2> go
> > > > > > > > > (1 row affected)
> > > > > > > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > > > > > > sp_fulltext_database,
> > > > > > > > > Lin
> > > > > > > > > e 46
> > > > > > > > > The Microsoft Search service cannot be administered under
> the
> > > > > present
> > > > > > > user
> > > > > > > > > account
> > > > > > > > >
> > > > > > > > > Now, we have tried many things to try and solve this
error,
> > > mainly
> > > > > > based
> > > > > > > > on
> > > > > > > > > search newsgroups, which are itemized below:
> > > > > > > > >
> > > > > > > > > 1 Reboot System and reexecute sp_
> > > > > > > > > 2 Complete reinstall of SQL on system, then reapplication
of
> > SP3
> > > > > > > > > 3 Same as above (2) but reapply SP3a
> > > > > > > > > 4 Remove SQL Server installation subkey in order that can
> > > > reinstall
> > > > > > > > > full-text search only, then reapply SP3
> > > > > > > > > 5 Check from keys under
> > > > > > > > >
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\
> > > to
> > > > > make
> > > > > > > > sure
> > > > > > > > > SQL Server was there. It wasn't, removed SQL subkey and
> > > > reinstalled,
> > > > > > > > > re-adding full-text search as an option (to re-install
> > > full-text)
> > > > > then
> > > > > > > > > reapplied SP3
> > > > > > > > > 6 Try reinstall, but do not reapply SP3 until have
full-text
> > > > enabled
> > > > > > the
> > > > > > > > > database.
> > > > > > > > >
> > > > > > > > > None of the above worked. We still have a none functioning
> > > > mssearch
> > > > > > and
> > > > > > > > > full-text disabled database on the system.
> > > > > > > > >
> > > > > > > > > We have even tried enabling on a blank database. This
does
> > not
> > > > work
> > > > > > > > either.
> > > > > > > > >
> > > > > > > > > PLEASE HELP! Getting desperate as the whole application
> > depends
> > > on
> > > > > > > having
> > > > > > > > > search ability.
> > > > > > > > >
> > > > > > > > > Thanks
> > > > > > > > >
> > > > > > > > > Oz
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Thanks John. Will try. Had actually tried that, but without deleting the MS
Search directory. Maybe, that is the key!
Oz
"John Kane" <jt-kane@.comcast.net> wrote in message
news:#tRBGI2NEHA.3016@.tk2msftngp13.phx.gbl...
> Oz,
> This seems to be an installation gone really bad... Below are the
> instructions, I've posted in this newsgroup that has been very successful
in
> resolving a number of SQL FTS related issues. However, with the new error
> (The parameter is incorrect), this re-installation may or may NOT be
> successful and you may have to remove SQL Server and the MSSearch
components
> and re-install SQL Server again.
> Re-install" the "Full-text Search" components via deleting (or renaming)
the
> below "tracking key" and re-install (If you're not using a named instance,
> remove "<Instance_Name>\".)
> NOTE: be sure to be logged on to the server as either Administrator or as
a
> member of the server's Admin Group!
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\<Instance_Name>\Tracking\
> {E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
> Once you've done removed (renamed) the above tracking key, then delete the
> MSSearch directory from either:
> drive_letter:\Program Files\Common Files\Microsoft Shared\
> or
> drive_letter::\Program Files\Common Files\System\
> Then using your SQL Server 2000 installation CD re-install via "Custom
> Installation" the Full-Text Search component (it should be un-checked).
When
> this completes find and save these files: SearchSetup.log (usually under
> \windows or \winnt folders) and sqlsp.log. If any problems, please post
> these files.
> Re-install SQL Server 2000 Service pack (SP3) if this service has been
> applied, so that the newly installed MSSearch components are upgraded to
> SP3a levels and then re-boot &/or restart the MSSearch and MSSQLServer
> services.
> Note, if the method above fails (and there are other methods) you might
need
> to open a support case with Microsoft PSS SQL Server Support...
> Regards,
> John
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:O6wrjyxNEHA.3816@.TK2MSFTNGP12.phx.gbl...
> > John,
> >
> > I did that and therefore reinstalled full-text. Actually i have done
this
> > before, but it's worth walking through it again with you as you may see
> > something i don't. I have not yet applied SP3 to the new full-text
> > installation. However, what i get now is another error.
> >
> > 'Execution of full-text operation failed. The parameter is incorrect'
> >
> > I have also manually tried running
> > sp_fulltext_database 'enable'
> >
> > and that is the same error generated.
> >
> > I used to FT wizard to try and create the FT index.
> >
> > Do you see anything here?
> >
> > Thanks
> >
> > "John Kane" <jt-kane@.comcast.net> wrote in message
> > news:u1HdIRwNEHA.892@.TK2MSFTNGP09.phx.gbl...
> > > Oz,
> > > When you say that the FTData directory was empty, do you mean NO
files,
> or
> > > just no gatherer log files?
> > > If the former, then this is a problem as the \FTDATA directory should
> look
> > > something like this (edited):
> > >
> > > Directory of F:\MSSQL80\MSSQL\FTDATA
> > >
> > > 05/14/2003 12:45 PM <DIR> .
> > > 05/14/2003 12:45 PM <DIR> ..
> > > 12/06/2003 07:21 PM <DIR> SQL0000500005 -- FT Catalog
> folder
> > > 05/14/2003 12:45 PM <DIR> SQLServer
> > > 0 File(s) 0 bytes
> > >
> > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQL0000500005
> > >
> > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer
> > >
> > > 05/14/2003 12:45 PM <DIR> .
> > > 05/14/2003 12:45 PM <DIR> ..
> > > 05/14/2003 12:45 PM <DIR> Config
> > > 05/10/2004 03:30 AM <DIR> GatherLogs
> > > 05/14/2003 12:45 PM <DIR> Projects
> > > 0 File(s) 0 bytes
> > >
> > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\Config
> > >
> > > 05/14/2003 12:45 PM <DIR> .
> > > 05/14/2003 12:45 PM <DIR> ..
> > > 05/14/2003 12:45 PM 1,771 Gathrprm.Txt
> > > 06/16/2000 11:30 PM 1,696 noise.chs
> > > 06/16/2000 11:30 PM 1,696 noise.cht
> > > 06/16/2000 11:30 PM 687 noise.dat
> > > 06/16/2000 11:30 PM 149,848 noise.deu
> > > 06/16/2000 11:30 PM 697 noise.eng
> > > 06/16/2000 11:30 PM 697 noise.enu
> > > 06/16/2000 11:30 PM 19,684 noise.esn
> > > 06/16/2000 11:30 PM 49,196 noise.fra
> > > 06/16/2000 11:30 PM 19,616 noise.ita
> > > 06/16/2000 11:30 PM 10,724 noise.jpn
> > > 06/16/2000 11:30 PM 697 noise.kor
> > > 06/16/2000 11:30 PM 13,256 noise.nld
> > > 06/16/2000 11:30 PM 13,728 noise.sve
> > > 04/28/2000 12:06 AM 4,576 Schema.Txt
> > > 05/05/2000 04:35 PM 536 tschs.xml
> > > 05/05/2000 04:35 PM 536 tscht.xml
> > > 05/05/2000 04:35 PM 536 tsdut.xml
> > > 05/05/2000 04:35 PM 536 tseng.xml
> > > 05/05/2000 04:35 PM 536 tsenu.xml
> > > 05/05/2000 04:35 PM 536 tsfra.xml
> > > 05/05/2000 04:35 PM 536 tsger.xml
> > > 05/05/2000 04:35 PM 536 tsita.xml
> > > 05/05/2000 04:35 PM 536 tsjap.xml
> > > 05/05/2000 04:35 PM 536 tskor.xml
> > > 05/05/2000 04:35 PM 536 tsneu.xml
> > > 05/05/2000 04:35 PM 810 tsschema.xml
> > > 05/05/2000 04:35 PM 536 tsspa.xml
> > > 05/05/2000 04:35 PM 536 tsswe.xml
> > > 29 File(s) 296,347 bytes
> > >
> > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\GatherLogs
> > >
> > > 05/10/2004 03:30 AM <DIR> .
> > > 05/10/2004 03:30 AM <DIR> ..
> > > 05/06/2004 04:06 AM 66 SQL0000500005.142.gthr
> > > 05/08/2004 03:30 AM 66 SQL0000500005.143.gthr
> > > 05/08/2004 06:27 PM 264 SQL0000500005.144.gthr
> > > 05/09/2004 04:04 AM 66 SQL0000500005.145.gthr
> > > 05/10/2004 03:30 AM 66 SQL0000500005.146.gthr
> > > 05/06/2004 04:06 AM 66 SQL0000600005.101.gthr
> > > 05/07/2004 03:32 AM 66 SQL0000600005.102.gthr
> > > 05/08/2004 06:27 PM 264 SQL0000600005.103.gthr
> > > 05/09/2004 04:04 AM 66 SQL0000600005.104.gthr
> > > 05/10/2004 03:30 AM 66 SQL0000600005.105.gthr
> > > 10 File(s) 1,056 bytes
> > >
> > >
> > > While you may not have files in the GatherLog dir, you MUST have the
> above
> > > files in the \FTDATA\SQLServer\Config.
> > > If not, then this *might* be the source of this issue.
> > >
> > > Regards,
> > > John
> > >
> > >
> > >
> > >
> > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > news:eTADCIrNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> > > > Ok,
> > > >
> > > > Will do.
> > > >
> > > > I'm talking about the FTData directory. It was there, but it was
> blank.
> > > So
> > > > i couldn't check for gatherer files etc.
> > > >
> > > > Thanks
> > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > news:uBU3C6pNEHA.1340@.TK2MSFTNGP12.phx.gbl...
> > > > > You're welcome, Oz,
> > > > > When you said "It's just occurred, to me, there is nothing in
those
> > > > > directories as i cannot enable the database for full-text!"
> > > > > What directories were you referring to?
> > > > >
> > > > > Could you change the MSSQLServer service startup account to the
> system
> > > > > account (LocalSystem) via the Enterprise Manager's server property
> > > > security
> > > > > tab? This should stop and restart SQL Server and attempt to
> FT-enable
> > > the
> > > > > Pubs database and the authors table and let me know the result of
> the
> > > > that?
> > > > >
> > > > > Thanks,
> > > > > John
> > > > >
> > > > >
> > > > >
> > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > > Also John,
> > > > > >
> > > > > > I have always been running a local (i.e. Domain user) account as
> the
> > > SQL
> > > > > > account, althought it is not a member of the administrators
group.
> > > This
> > > > > is
> > > > > > one of the things i tried (adding it to the admins group), but
> > didn't
> > > > > help.
> > > > > >
> > > > > > Thanks
> > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > > > > > > You're welcome, Oz,
> > > > > > > Yes, there are MSSearch gatherer log files located under
> > > > > > > \FTDATA\SQLServer\GatherLogs\ that can be "read" using
> > gthrlog.vbs,
> > > > > > however,
> > > > > > > they most likely will have the same error (MSSearch service
> cannot
> > > be
> > > > > > > admin..), so they are of little value in this issue.
> > > > > > >
> > > > > > > Is this SQL Server installed on a Domain Controller (DC)
server
> or
> > > is
> > > > > the
> > > > > > > MSSQLServer startup account the DOMAIN\Administrator account?
> > > > > > >
> > > > > > > While this should work, it's been my experience that with
> > Full-Text
> > > > > Search
> > > > > > > (FTS) on DC's that this is a problem for the "Microsoft
Search"
> > > > > (MSSearch)
> > > > > > > service. If you are using the DOMAIN\Administrator account,
> create
> > a
> > > > > local
> > > > > > > machine account and add this account into the DC's
Administrator
> > > Group
> > > > > and
> > > > > > > then change the MSSQLServer startup account in the Enterprise
> > > Manager
> > > > > > (this
> > > > > > > change MUST be done here) server's security tab. This should
> stop
> > > and
> > > > > > > restart SQL Server and if all is successfully completed, FTS
on
> a
> > DC
> > > > > > > *should* work...
> > > > > > >
> > > > > > > Regards,
> > > > > > > John
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > > > > > > John
> > > > > > > >
> > > > > > > > Is there a log file somewhere that i could try and see what
> > > > precisely
> > > > > is
> > > > > > > > causing this problem.
> > > > > > > >
> > > > > > > > Thanks
> > > > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > > > > > > Oz,
> > > > > > > > > In addition to the many things you tried below... a couple
> of
> > > > things
> > > > > > > > > specific to MSSearch and the MSSQLServer services...
> > > > > > > > > 1. Is the MSSearch service started and running under the
> > System
> > > > > > > > > (LocalSystem) account? If not, then change it to
LocalSystem
> > and
> > > > > stop
> > > > > > > and
> > > > > > > > > re-start this service.
> > > > > > > > >
> > > > > > > > > 2. Have you or anyone else change the MSSQLServer account
> &/or
> > > > > > password
> > > > > > > > via
> > > > > > > > > Win2K's Component service? IF so, then you MUST re-change
> the
> > > > change
> > > > > > via
> > > > > > > > the
> > > > > > > > > Enterprise Manager's server property security tab as this
is
> > the
> > > > > only
> > > > > > > > place
> > > > > > > > > where the two services security are kept in sync. See KB
> > article
> > > > > > 277549
> > > > > > > > > (Q277549) PRB: Unable to Build Full-Text Catalog After You
> > > Modify
> > > > > > > > > MSSQLServer Logon Account Through [NT4.0) Control Panel
[or
> > > Win2K
> > > > > > > > Component
> > > > > > > > > Services] at
> > > > > > > >
http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > > > > > > >
> > > > > > > > > 3. Have you or anyone else removed or modified the
> > > > > > > BUILTIN\Administrator
> > > > > > > > > login on this server? If so, you MUST either re-add it
with
> > all
> > > of
> > > > > > it's
> > > > > > > > > normal default rights, especially sysadmin rights and with
> the
> > > > > default
> > > > > > > > > database as master and the default language of English or
> use
> > > the
> > > > > > > > following
> > > > > > > > > T-SQL code to add the correct permissions:
> > > > > > > > >
> > > > > > > > > exec sp_grantlogin N'NT Authority\System'
> > > > > > > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > > > > > > exec sp_defaultlanguage N'NT
Authority\System','us_english'
> > > > > > > > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > > > > > > > >
> > > > > > > > > Additionally, but not necessarily related to the error in
> the
> > > > > subject
> > > > > > > > line,
> > > > > > > > > has this server ever been upgrade from SQL Server 7.0 or
is
> > this
> > > > SQL
> > > > > > > > Server
> > > > > > > > > 2000 a "named instance" with a default installation of SQL
> > > Server
> > > > > 7.0?
> > > > > > > As
> > > > > > > > > this might be related to a post-SP3 bug. See KB 814035
> > (Q814035)
> > > > > FIX:
> > > > > > A
> > > > > > > > > Full-Text Population Fails After You Apply SQL Server 2000
> > > Service
> > > > > > Pack
> > > > > > > 3
> > > > > > > > > at:
> > > > > > > > >
> http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > > > > > > (80004002 -
> > > > > > > > > No such interface supported)
> > > > > > > > >
> > > > > > > > > Regards,
> > > > > > > > > John
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > > > > > > Hi,
> > > > > > > > > >
> > > > > > > > > > We have SQL Server private installation on which we are
> > > > developing
> > > > > > an
> > > > > > > > > > application and public installation on whict we will be
> > > > deploying
> > > > > > the
> > > > > > > > > > application. All instances have run Windows 2003
> Enterprise
> > > > > Edition
> > > > > > > with
> > > > > > > > > SQL
> > > > > > > > > > 2000 SP3. However, the public installation MS Search is
> not
> > > > > > > functioning
> > > > > > > > > > correctly. Basically it will not full-text indeed
> databases
> > > and
> > > > > > > > produces
> > > > > > > > > > the following error
> > > > > > > > > >
> > > > > > > > > > 1> exec sp_fulltext_database 'enable'
> > > > > > > > > > 2> go
> > > > > > > > > > (1 row affected)
> > > > > > > > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > > > > > > > sp_fulltext_database,
> > > > > > > > > > Lin
> > > > > > > > > > e 46
> > > > > > > > > > The Microsoft Search service cannot be administered
under
> > the
> > > > > > present
> > > > > > > > user
> > > > > > > > > > account
> > > > > > > > > >
> > > > > > > > > > Now, we have tried many things to try and solve this
> error,
> > > > mainly
> > > > > > > based
> > > > > > > > > on
> > > > > > > > > > search newsgroups, which are itemized below:
> > > > > > > > > >
> > > > > > > > > > 1 Reboot System and reexecute sp_
> > > > > > > > > > 2 Complete reinstall of SQL on system, then
reapplication
> of
> > > SP3
> > > > > > > > > > 3 Same as above (2) but reapply SP3a
> > > > > > > > > > 4 Remove SQL Server installation subkey in order that
can
> > > > > reinstall
> > > > > > > > > > full-text search only, then reapply SP3
> > > > > > > > > > 5 Check from keys under
> > > > > > > > > >
> > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\
> > > > to
> > > > > > make
> > > > > > > > > sure
> > > > > > > > > > SQL Server was there. It wasn't, removed SQL subkey and
> > > > > reinstalled,
> > > > > > > > > > re-adding full-text search as an option (to re-install
> > > > full-text)
> > > > > > then
> > > > > > > > > > reapplied SP3
> > > > > > > > > > 6 Try reinstall, but do not reapply SP3 until have
> full-text
> > > > > enabled
> > > > > > > the
> > > > > > > > > > database.
> > > > > > > > > >
> > > > > > > > > > None of the above worked. We still have a none
functioning
> > > > > mssearch
> > > > > > > and
> > > > > > > > > > full-text disabled database on the system.
> > > > > > > > > >
> > > > > > > > > > We have even tried enabling on a blank database. This
> does
> > > not
> > > > > work
> > > > > > > > > either.
> > > > > > > > > >
> > > > > > > > > > PLEASE HELP! Getting desperate as the whole application
> > > depends
> > > > on
> > > > > > > > having
> > > > > > > > > > search ability.
> > > > > > > > > >
> > > > > > > > > > Thanks
> > > > > > > > > >
> > > > > > > > > > Oz
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi John,
Well, in case anyone searching this group has a similar problem, it may have
been drastic, but i finally got FullText to work properly.
Check out this MS Article:
http://support.microsoft.com/?kbid=827449
Thanks for ALL your help John. You really hung in their with me.
Cheers
Oz
"John Kane" <jt-kane@.comcast.net> wrote in message
news:#tRBGI2NEHA.3016@.tk2msftngp13.phx.gbl...
> Oz,
> This seems to be an installation gone really bad... Below are the
> instructions, I've posted in this newsgroup that has been very successful
in
> resolving a number of SQL FTS related issues. However, with the new error
> (The parameter is incorrect), this re-installation may or may NOT be
> successful and you may have to remove SQL Server and the MSSearch
components
> and re-install SQL Server again.
> Re-install" the "Full-text Search" components via deleting (or renaming)
the
> below "tracking key" and re-install (If you're not using a named instance,
> remove "<Instance_Name>\".)
> NOTE: be sure to be logged on to the server as either Administrator or as
a
> member of the server's Admin Group!
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\<Instance_Name>\Tracking\
> {E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
> Once you've done removed (renamed) the above tracking key, then delete the
> MSSearch directory from either:
> drive_letter:\Program Files\Common Files\Microsoft Shared\
> or
> drive_letter::\Program Files\Common Files\System\
> Then using your SQL Server 2000 installation CD re-install via "Custom
> Installation" the Full-Text Search component (it should be un-checked).
When
> this completes find and save these files: SearchSetup.log (usually under
> \windows or \winnt folders) and sqlsp.log. If any problems, please post
> these files.
> Re-install SQL Server 2000 Service pack (SP3) if this service has been
> applied, so that the newly installed MSSearch components are upgraded to
> SP3a levels and then re-boot &/or restart the MSSearch and MSSQLServer
> services.
> Note, if the method above fails (and there are other methods) you might
need
> to open a support case with Microsoft PSS SQL Server Support...
> Regards,
> John
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:O6wrjyxNEHA.3816@.TK2MSFTNGP12.phx.gbl...
> > John,
> >
> > I did that and therefore reinstalled full-text. Actually i have done
this
> > before, but it's worth walking through it again with you as you may see
> > something i don't. I have not yet applied SP3 to the new full-text
> > installation. However, what i get now is another error.
> >
> > 'Execution of full-text operation failed. The parameter is incorrect'
> >
> > I have also manually tried running
> > sp_fulltext_database 'enable'
> >
> > and that is the same error generated.
> >
> > I used to FT wizard to try and create the FT index.
> >
> > Do you see anything here?
> >
> > Thanks
> >
> > "John Kane" <jt-kane@.comcast.net> wrote in message
> > news:u1HdIRwNEHA.892@.TK2MSFTNGP09.phx.gbl...
> > > Oz,
> > > When you say that the FTData directory was empty, do you mean NO
files,
> or
> > > just no gatherer log files?
> > > If the former, then this is a problem as the \FTDATA directory should
> look
> > > something like this (edited):
> > >
> > > Directory of F:\MSSQL80\MSSQL\FTDATA
> > >
> > > 05/14/2003 12:45 PM <DIR> .
> > > 05/14/2003 12:45 PM <DIR> ..
> > > 12/06/2003 07:21 PM <DIR> SQL0000500005 -- FT Catalog
> folder
> > > 05/14/2003 12:45 PM <DIR> SQLServer
> > > 0 File(s) 0 bytes
> > >
> > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQL0000500005
> > >
> > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer
> > >
> > > 05/14/2003 12:45 PM <DIR> .
> > > 05/14/2003 12:45 PM <DIR> ..
> > > 05/14/2003 12:45 PM <DIR> Config
> > > 05/10/2004 03:30 AM <DIR> GatherLogs
> > > 05/14/2003 12:45 PM <DIR> Projects
> > > 0 File(s) 0 bytes
> > >
> > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\Config
> > >
> > > 05/14/2003 12:45 PM <DIR> .
> > > 05/14/2003 12:45 PM <DIR> ..
> > > 05/14/2003 12:45 PM 1,771 Gathrprm.Txt
> > > 06/16/2000 11:30 PM 1,696 noise.chs
> > > 06/16/2000 11:30 PM 1,696 noise.cht
> > > 06/16/2000 11:30 PM 687 noise.dat
> > > 06/16/2000 11:30 PM 149,848 noise.deu
> > > 06/16/2000 11:30 PM 697 noise.eng
> > > 06/16/2000 11:30 PM 697 noise.enu
> > > 06/16/2000 11:30 PM 19,684 noise.esn
> > > 06/16/2000 11:30 PM 49,196 noise.fra
> > > 06/16/2000 11:30 PM 19,616 noise.ita
> > > 06/16/2000 11:30 PM 10,724 noise.jpn
> > > 06/16/2000 11:30 PM 697 noise.kor
> > > 06/16/2000 11:30 PM 13,256 noise.nld
> > > 06/16/2000 11:30 PM 13,728 noise.sve
> > > 04/28/2000 12:06 AM 4,576 Schema.Txt
> > > 05/05/2000 04:35 PM 536 tschs.xml
> > > 05/05/2000 04:35 PM 536 tscht.xml
> > > 05/05/2000 04:35 PM 536 tsdut.xml
> > > 05/05/2000 04:35 PM 536 tseng.xml
> > > 05/05/2000 04:35 PM 536 tsenu.xml
> > > 05/05/2000 04:35 PM 536 tsfra.xml
> > > 05/05/2000 04:35 PM 536 tsger.xml
> > > 05/05/2000 04:35 PM 536 tsita.xml
> > > 05/05/2000 04:35 PM 536 tsjap.xml
> > > 05/05/2000 04:35 PM 536 tskor.xml
> > > 05/05/2000 04:35 PM 536 tsneu.xml
> > > 05/05/2000 04:35 PM 810 tsschema.xml
> > > 05/05/2000 04:35 PM 536 tsspa.xml
> > > 05/05/2000 04:35 PM 536 tsswe.xml
> > > 29 File(s) 296,347 bytes
> > >
> > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\GatherLogs
> > >
> > > 05/10/2004 03:30 AM <DIR> .
> > > 05/10/2004 03:30 AM <DIR> ..
> > > 05/06/2004 04:06 AM 66 SQL0000500005.142.gthr
> > > 05/08/2004 03:30 AM 66 SQL0000500005.143.gthr
> > > 05/08/2004 06:27 PM 264 SQL0000500005.144.gthr
> > > 05/09/2004 04:04 AM 66 SQL0000500005.145.gthr
> > > 05/10/2004 03:30 AM 66 SQL0000500005.146.gthr
> > > 05/06/2004 04:06 AM 66 SQL0000600005.101.gthr
> > > 05/07/2004 03:32 AM 66 SQL0000600005.102.gthr
> > > 05/08/2004 06:27 PM 264 SQL0000600005.103.gthr
> > > 05/09/2004 04:04 AM 66 SQL0000600005.104.gthr
> > > 05/10/2004 03:30 AM 66 SQL0000600005.105.gthr
> > > 10 File(s) 1,056 bytes
> > >
> > >
> > > While you may not have files in the GatherLog dir, you MUST have the
> above
> > > files in the \FTDATA\SQLServer\Config.
> > > If not, then this *might* be the source of this issue.
> > >
> > > Regards,
> > > John
> > >
> > >
> > >
> > >
> > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > news:eTADCIrNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> > > > Ok,
> > > >
> > > > Will do.
> > > >
> > > > I'm talking about the FTData directory. It was there, but it was
> blank.
> > > So
> > > > i couldn't check for gatherer files etc.
> > > >
> > > > Thanks
> > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > news:uBU3C6pNEHA.1340@.TK2MSFTNGP12.phx.gbl...
> > > > > You're welcome, Oz,
> > > > > When you said "It's just occurred, to me, there is nothing in
those
> > > > > directories as i cannot enable the database for full-text!"
> > > > > What directories were you referring to?
> > > > >
> > > > > Could you change the MSSQLServer service startup account to the
> system
> > > > > account (LocalSystem) via the Enterprise Manager's server property
> > > > security
> > > > > tab? This should stop and restart SQL Server and attempt to
> FT-enable
> > > the
> > > > > Pubs database and the authors table and let me know the result of
> the
> > > > that?
> > > > >
> > > > > Thanks,
> > > > > John
> > > > >
> > > > >
> > > > >
> > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > > Also John,
> > > > > >
> > > > > > I have always been running a local (i.e. Domain user) account as
> the
> > > SQL
> > > > > > account, althought it is not a member of the administrators
group.
> > > This
> > > > > is
> > > > > > one of the things i tried (adding it to the admins group), but
> > didn't
> > > > > help.
> > > > > >
> > > > > > Thanks
> > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > > > > > > You're welcome, Oz,
> > > > > > > Yes, there are MSSearch gatherer log files located under
> > > > > > > \FTDATA\SQLServer\GatherLogs\ that can be "read" using
> > gthrlog.vbs,
> > > > > > however,
> > > > > > > they most likely will have the same error (MSSearch service
> cannot
> > > be
> > > > > > > admin..), so they are of little value in this issue.
> > > > > > >
> > > > > > > Is this SQL Server installed on a Domain Controller (DC)
server
> or
> > > is
> > > > > the
> > > > > > > MSSQLServer startup account the DOMAIN\Administrator account?
> > > > > > >
> > > > > > > While this should work, it's been my experience that with
> > Full-Text
> > > > > Search
> > > > > > > (FTS) on DC's that this is a problem for the "Microsoft
Search"
> > > > > (MSSearch)
> > > > > > > service. If you are using the DOMAIN\Administrator account,
> create
> > a
> > > > > local
> > > > > > > machine account and add this account into the DC's
Administrator
> > > Group
> > > > > and
> > > > > > > then change the MSSQLServer startup account in the Enterprise
> > > Manager
> > > > > > (this
> > > > > > > change MUST be done here) server's security tab. This should
> stop
> > > and
> > > > > > > restart SQL Server and if all is successfully completed, FTS
on
> a
> > DC
> > > > > > > *should* work...
> > > > > > >
> > > > > > > Regards,
> > > > > > > John
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > > > > > > John
> > > > > > > >
> > > > > > > > Is there a log file somewhere that i could try and see what
> > > > precisely
> > > > > is
> > > > > > > > causing this problem.
> > > > > > > >
> > > > > > > > Thanks
> > > > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > > > > > > Oz,
> > > > > > > > > In addition to the many things you tried below... a couple
> of
> > > > things
> > > > > > > > > specific to MSSearch and the MSSQLServer services...
> > > > > > > > > 1. Is the MSSearch service started and running under the
> > System
> > > > > > > > > (LocalSystem) account? If not, then change it to
LocalSystem
> > and
> > > > > stop
> > > > > > > and
> > > > > > > > > re-start this service.
> > > > > > > > >
> > > > > > > > > 2. Have you or anyone else change the MSSQLServer account
> &/or
> > > > > > password
> > > > > > > > via
> > > > > > > > > Win2K's Component service? IF so, then you MUST re-change
> the
> > > > change
> > > > > > via
> > > > > > > > the
> > > > > > > > > Enterprise Manager's server property security tab as this
is
> > the
> > > > > only
> > > > > > > > place
> > > > > > > > > where the two services security are kept in sync. See KB
> > article
> > > > > > 277549
> > > > > > > > > (Q277549) PRB: Unable to Build Full-Text Catalog After You
> > > Modify
> > > > > > > > > MSSQLServer Logon Account Through [NT4.0) Control Panel
[or
> > > Win2K
> > > > > > > > Component
> > > > > > > > > Services] at
> > > > > > > >
http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > > > > > > >
> > > > > > > > > 3. Have you or anyone else removed or modified the
> > > > > > > BUILTIN\Administrator
> > > > > > > > > login on this server? If so, you MUST either re-add it
with
> > all
> > > of
> > > > > > it's
> > > > > > > > > normal default rights, especially sysadmin rights and with
> the
> > > > > default
> > > > > > > > > database as master and the default language of English or
> use
> > > the
> > > > > > > > following
> > > > > > > > > T-SQL code to add the correct permissions:
> > > > > > > > >
> > > > > > > > > exec sp_grantlogin N'NT Authority\System'
> > > > > > > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > > > > > > exec sp_defaultlanguage N'NT
Authority\System','us_english'
> > > > > > > > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > > > > > > > >
> > > > > > > > > Additionally, but not necessarily related to the error in
> the
> > > > > subject
> > > > > > > > line,
> > > > > > > > > has this server ever been upgrade from SQL Server 7.0 or
is
> > this
> > > > SQL
> > > > > > > > Server
> > > > > > > > > 2000 a "named instance" with a default installation of SQL
> > > Server
> > > > > 7.0?
> > > > > > > As
> > > > > > > > > this might be related to a post-SP3 bug. See KB 814035
> > (Q814035)
> > > > > FIX:
> > > > > > A
> > > > > > > > > Full-Text Population Fails After You Apply SQL Server 2000
> > > Service
> > > > > > Pack
> > > > > > > 3
> > > > > > > > > at:
> > > > > > > > >
> http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > > > > > > (80004002 -
> > > > > > > > > No such interface supported)
> > > > > > > > >
> > > > > > > > > Regards,
> > > > > > > > > John
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > > > > > > Hi,
> > > > > > > > > >
> > > > > > > > > > We have SQL Server private installation on which we are
> > > > developing
> > > > > > an
> > > > > > > > > > application and public installation on whict we will be
> > > > deploying
> > > > > > the
> > > > > > > > > > application. All instances have run Windows 2003
> Enterprise
> > > > > Edition
> > > > > > > with
> > > > > > > > > SQL
> > > > > > > > > > 2000 SP3. However, the public installation MS Search is
> not
> > > > > > > functioning
> > > > > > > > > > correctly. Basically it will not full-text indeed
> databases
> > > and
> > > > > > > > produces
> > > > > > > > > > the following error
> > > > > > > > > >
> > > > > > > > > > 1> exec sp_fulltext_database 'enable'
> > > > > > > > > > 2> go
> > > > > > > > > > (1 row affected)
> > > > > > > > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > > > > > > > sp_fulltext_database,
> > > > > > > > > > Lin
> > > > > > > > > > e 46
> > > > > > > > > > The Microsoft Search service cannot be administered
under
> > the
> > > > > > present
> > > > > > > > user
> > > > > > > > > > account
> > > > > > > > > >
> > > > > > > > > > Now, we have tried many things to try and solve this
> error,
> > > > mainly
> > > > > > > based
> > > > > > > > > on
> > > > > > > > > > search newsgroups, which are itemized below:
> > > > > > > > > >
> > > > > > > > > > 1 Reboot System and reexecute sp_
> > > > > > > > > > 2 Complete reinstall of SQL on system, then
reapplication
> of
> > > SP3
> > > > > > > > > > 3 Same as above (2) but reapply SP3a
> > > > > > > > > > 4 Remove SQL Server installation subkey in order that
can
> > > > > reinstall
> > > > > > > > > > full-text search only, then reapply SP3
> > > > > > > > > > 5 Check from keys under
> > > > > > > > > >
> > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\
> > > > to
> > > > > > make
> > > > > > > > > sure
> > > > > > > > > > SQL Server was there. It wasn't, removed SQL subkey and
> > > > > reinstalled,
> > > > > > > > > > re-adding full-text search as an option (to re-install
> > > > full-text)
> > > > > > then
> > > > > > > > > > reapplied SP3
> > > > > > > > > > 6 Try reinstall, but do not reapply SP3 until have
> full-text
> > > > > enabled
> > > > > > > the
> > > > > > > > > > database.
> > > > > > > > > >
> > > > > > > > > > None of the above worked. We still have a none
functioning
> > > > > mssearch
> > > > > > > and
> > > > > > > > > > full-text disabled database on the system.
> > > > > > > > > >
> > > > > > > > > > We have even tried enabling on a blank database. This
> does
> > > not
> > > > > work
> > > > > > > > > either.
> > > > > > > > > >
> > > > > > > > > > PLEASE HELP! Getting desperate as the whole application
> > > depends
> > > > on
> > > > > > > > having
> > > > > > > > > > search ability.
> > > > > > > > > >
> > > > > > > > > > Thanks
> > > > > > > > > >
> > > > > > > > > > Oz
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||You're welcome, Oz!
John
"Oz" <Oz(no_spam)@.nospam.com> wrote in message
news:elrLgI#OEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Hi John,
> Well, in case anyone searching this group has a similar problem, it may
have
> been drastic, but i finally got FullText to work properly.
> Check out this MS Article:
> http://support.microsoft.com/?kbid=827449
> Thanks for ALL your help John. You really hung in their with me.
> Cheers
> Oz
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:#tRBGI2NEHA.3016@.tk2msftngp13.phx.gbl...
> > Oz,
> > This seems to be an installation gone really bad... Below are the
> > instructions, I've posted in this newsgroup that has been very
successful
> in
> > resolving a number of SQL FTS related issues. However, with the new
error
> > (The parameter is incorrect), this re-installation may or may NOT be
> > successful and you may have to remove SQL Server and the MSSearch
> components
> > and re-install SQL Server again.
> >
> > Re-install" the "Full-text Search" components via deleting (or renaming)
> the
> > below "tracking key" and re-install (If you're not using a named
instance,
> > remove "<Instance_Name>\".)
> >
> > NOTE: be sure to be logged on to the server as either Administrator or
as
> a
> > member of the server's Admin Group!
> >
> > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> > Server\<Instance_Name>\Tracking\
> > {E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
> >
> > Once you've done removed (renamed) the above tracking key, then delete
the
> > MSSearch directory from either:
> >
> > drive_letter:\Program Files\Common Files\Microsoft Shared\
> > or
> > drive_letter::\Program Files\Common Files\System\
> >
> > Then using your SQL Server 2000 installation CD re-install via "Custom
> > Installation" the Full-Text Search component (it should be un-checked).
> When
> > this completes find and save these files: SearchSetup.log (usually under
> > \windows or \winnt folders) and sqlsp.log. If any problems, please post
> > these files.
> >
> > Re-install SQL Server 2000 Service pack (SP3) if this service has been
> > applied, so that the newly installed MSSearch components are upgraded to
> > SP3a levels and then re-boot &/or restart the MSSearch and MSSQLServer
> > services.
> >
> > Note, if the method above fails (and there are other methods) you might
> need
> > to open a support case with Microsoft PSS SQL Server Support...
> >
> > Regards,
> > John
> >
> >
> >
> > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > news:O6wrjyxNEHA.3816@.TK2MSFTNGP12.phx.gbl...
> > > John,
> > >
> > > I did that and therefore reinstalled full-text. Actually i have done
> this
> > > before, but it's worth walking through it again with you as you may
see
> > > something i don't. I have not yet applied SP3 to the new full-text
> > > installation. However, what i get now is another error.
> > >
> > > 'Execution of full-text operation failed. The parameter is incorrect'
> > >
> > > I have also manually tried running
> > > sp_fulltext_database 'enable'
> > >
> > > and that is the same error generated.
> > >
> > > I used to FT wizard to try and create the FT index.
> > >
> > > Do you see anything here?
> > >
> > > Thanks
> > >
> > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > news:u1HdIRwNEHA.892@.TK2MSFTNGP09.phx.gbl...
> > > > Oz,
> > > > When you say that the FTData directory was empty, do you mean NO
> files,
> > or
> > > > just no gatherer log files?
> > > > If the former, then this is a problem as the \FTDATA directory
should
> > look
> > > > something like this (edited):
> > > >
> > > > Directory of F:\MSSQL80\MSSQL\FTDATA
> > > >
> > > > 05/14/2003 12:45 PM <DIR> .
> > > > 05/14/2003 12:45 PM <DIR> ..
> > > > 12/06/2003 07:21 PM <DIR> SQL0000500005 -- FT Catalog
> > folder
> > > > 05/14/2003 12:45 PM <DIR> SQLServer
> > > > 0 File(s) 0 bytes
> > > >
> > > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQL0000500005
> > > >
> > > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer
> > > >
> > > > 05/14/2003 12:45 PM <DIR> .
> > > > 05/14/2003 12:45 PM <DIR> ..
> > > > 05/14/2003 12:45 PM <DIR> Config
> > > > 05/10/2004 03:30 AM <DIR> GatherLogs
> > > > 05/14/2003 12:45 PM <DIR> Projects
> > > > 0 File(s) 0 bytes
> > > >
> > > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\Config
> > > >
> > > > 05/14/2003 12:45 PM <DIR> .
> > > > 05/14/2003 12:45 PM <DIR> ..
> > > > 05/14/2003 12:45 PM 1,771 Gathrprm.Txt
> > > > 06/16/2000 11:30 PM 1,696 noise.chs
> > > > 06/16/2000 11:30 PM 1,696 noise.cht
> > > > 06/16/2000 11:30 PM 687 noise.dat
> > > > 06/16/2000 11:30 PM 149,848 noise.deu
> > > > 06/16/2000 11:30 PM 697 noise.eng
> > > > 06/16/2000 11:30 PM 697 noise.enu
> > > > 06/16/2000 11:30 PM 19,684 noise.esn
> > > > 06/16/2000 11:30 PM 49,196 noise.fra
> > > > 06/16/2000 11:30 PM 19,616 noise.ita
> > > > 06/16/2000 11:30 PM 10,724 noise.jpn
> > > > 06/16/2000 11:30 PM 697 noise.kor
> > > > 06/16/2000 11:30 PM 13,256 noise.nld
> > > > 06/16/2000 11:30 PM 13,728 noise.sve
> > > > 04/28/2000 12:06 AM 4,576 Schema.Txt
> > > > 05/05/2000 04:35 PM 536 tschs.xml
> > > > 05/05/2000 04:35 PM 536 tscht.xml
> > > > 05/05/2000 04:35 PM 536 tsdut.xml
> > > > 05/05/2000 04:35 PM 536 tseng.xml
> > > > 05/05/2000 04:35 PM 536 tsenu.xml
> > > > 05/05/2000 04:35 PM 536 tsfra.xml
> > > > 05/05/2000 04:35 PM 536 tsger.xml
> > > > 05/05/2000 04:35 PM 536 tsita.xml
> > > > 05/05/2000 04:35 PM 536 tsjap.xml
> > > > 05/05/2000 04:35 PM 536 tskor.xml
> > > > 05/05/2000 04:35 PM 536 tsneu.xml
> > > > 05/05/2000 04:35 PM 810 tsschema.xml
> > > > 05/05/2000 04:35 PM 536 tsspa.xml
> > > > 05/05/2000 04:35 PM 536 tsswe.xml
> > > > 29 File(s) 296,347 bytes
> > > >
> > > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\GatherLogs
> > > >
> > > > 05/10/2004 03:30 AM <DIR> .
> > > > 05/10/2004 03:30 AM <DIR> ..
> > > > 05/06/2004 04:06 AM 66 SQL0000500005.142.gthr
> > > > 05/08/2004 03:30 AM 66 SQL0000500005.143.gthr
> > > > 05/08/2004 06:27 PM 264 SQL0000500005.144.gthr
> > > > 05/09/2004 04:04 AM 66 SQL0000500005.145.gthr
> > > > 05/10/2004 03:30 AM 66 SQL0000500005.146.gthr
> > > > 05/06/2004 04:06 AM 66 SQL0000600005.101.gthr
> > > > 05/07/2004 03:32 AM 66 SQL0000600005.102.gthr
> > > > 05/08/2004 06:27 PM 264 SQL0000600005.103.gthr
> > > > 05/09/2004 04:04 AM 66 SQL0000600005.104.gthr
> > > > 05/10/2004 03:30 AM 66 SQL0000600005.105.gthr
> > > > 10 File(s) 1,056 bytes
> > > >
> > > >
> > > > While you may not have files in the GatherLog dir, you MUST have the
> > above
> > > > files in the \FTDATA\SQLServer\Config.
> > > > If not, then this *might* be the source of this issue.
> > > >
> > > > Regards,
> > > > John
> > > >
> > > >
> > > >
> > > >
> > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > news:eTADCIrNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> > > > > Ok,
> > > > >
> > > > > Will do.
> > > > >
> > > > > I'm talking about the FTData directory. It was there, but it was
> > blank.
> > > > So
> > > > > i couldn't check for gatherer files etc.
> > > > >
> > > > > Thanks
> > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > news:uBU3C6pNEHA.1340@.TK2MSFTNGP12.phx.gbl...
> > > > > > You're welcome, Oz,
> > > > > > When you said "It's just occurred, to me, there is nothing in
> those
> > > > > > directories as i cannot enable the database for full-text!"
> > > > > > What directories were you referring to?
> > > > > >
> > > > > > Could you change the MSSQLServer service startup account to the
> > system
> > > > > > account (LocalSystem) via the Enterprise Manager's server
property
> > > > > security
> > > > > > tab? This should stop and restart SQL Server and attempt to
> > FT-enable
> > > > the
> > > > > > Pubs database and the authors table and let me know the result
of
> > the
> > > > > that?
> > > > > >
> > > > > > Thanks,
> > > > > > John
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > > > Also John,
> > > > > > >
> > > > > > > I have always been running a local (i.e. Domain user) account
as
> > the
> > > > SQL
> > > > > > > account, althought it is not a member of the administrators
> group.
> > > > This
> > > > > > is
> > > > > > > one of the things i tried (adding it to the admins group), but
> > > didn't
> > > > > > help.
> > > > > > >
> > > > > > > Thanks
> > > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > > news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > > > > > > > You're welcome, Oz,
> > > > > > > > Yes, there are MSSearch gatherer log files located under
> > > > > > > > \FTDATA\SQLServer\GatherLogs\ that can be "read" using
> > > gthrlog.vbs,
> > > > > > > however,
> > > > > > > > they most likely will have the same error (MSSearch service
> > cannot
> > > > be
> > > > > > > > admin..), so they are of little value in this issue.
> > > > > > > >
> > > > > > > > Is this SQL Server installed on a Domain Controller (DC)
> server
> > or
> > > > is
> > > > > > the
> > > > > > > > MSSQLServer startup account the DOMAIN\Administrator
account?
> > > > > > > >
> > > > > > > > While this should work, it's been my experience that with
> > > Full-Text
> > > > > > Search
> > > > > > > > (FTS) on DC's that this is a problem for the "Microsoft
> Search"
> > > > > > (MSSearch)
> > > > > > > > service. If you are using the DOMAIN\Administrator account,
> > create
> > > a
> > > > > > local
> > > > > > > > machine account and add this account into the DC's
> Administrator
> > > > Group
> > > > > > and
> > > > > > > > then change the MSSQLServer startup account in the
Enterprise
> > > > Manager
> > > > > > > (this
> > > > > > > > change MUST be done here) server's security tab. This should
> > stop
> > > > and
> > > > > > > > restart SQL Server and if all is successfully completed, FTS
> on
> > a
> > > DC
> > > > > > > > *should* work...
> > > > > > > >
> > > > > > > > Regards,
> > > > > > > > John
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > > > > > > > John
> > > > > > > > >
> > > > > > > > > Is there a log file somewhere that i could try and see
what
> > > > > precisely
> > > > > > is
> > > > > > > > > causing this problem.
> > > > > > > > >
> > > > > > > > > Thanks
> > > > > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > > > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > > > > > > > Oz,
> > > > > > > > > > In addition to the many things you tried below... a
couple
> > of
> > > > > things
> > > > > > > > > > specific to MSSearch and the MSSQLServer services...
> > > > > > > > > > 1. Is the MSSearch service started and running under the
> > > System
> > > > > > > > > > (LocalSystem) account? If not, then change it to
> LocalSystem
> > > and
> > > > > > stop
> > > > > > > > and
> > > > > > > > > > re-start this service.
> > > > > > > > > >
> > > > > > > > > > 2. Have you or anyone else change the MSSQLServer
account
> > &/or
> > > > > > > password
> > > > > > > > > via
> > > > > > > > > > Win2K's Component service? IF so, then you MUST
re-change
> > the
> > > > > change
> > > > > > > via
> > > > > > > > > the
> > > > > > > > > > Enterprise Manager's server property security tab as
this
> is
> > > the
> > > > > > only
> > > > > > > > > place
> > > > > > > > > > where the two services security are kept in sync. See KB
> > > article
> > > > > > > 277549
> > > > > > > > > > (Q277549) PRB: Unable to Build Full-Text Catalog After
You
> > > > Modify
> > > > > > > > > > MSSQLServer Logon Account Through [NT4.0) Control Panel
> [or
> > > > Win2K
> > > > > > > > > Component
> > > > > > > > > > Services] at
> > > > > > > > >
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > > > > > > > >
> > > > > > > > > > 3. Have you or anyone else removed or modified the
> > > > > > > > BUILTIN\Administrator
> > > > > > > > > > login on this server? If so, you MUST either re-add it
> with
> > > all
> > > > of
> > > > > > > it's
> > > > > > > > > > normal default rights, especially sysadmin rights and
with
> > the
> > > > > > default
> > > > > > > > > > database as master and the default language of English
or
> > use
> > > > the
> > > > > > > > > following
> > > > > > > > > > T-SQL code to add the correct permissions:
> > > > > > > > > >
> > > > > > > > > > exec sp_grantlogin N'NT Authority\System'
> > > > > > > > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > > > > > > > exec sp_defaultlanguage N'NT
> Authority\System','us_english'
> > > > > > > > > > exec sp_addsrvrolemember N'NT Authority\System',
sysadmin
> > > > > > > > > >
> > > > > > > > > > Additionally, but not necessarily related to the error
in
> > the
> > > > > > subject
> > > > > > > > > line,
> > > > > > > > > > has this server ever been upgrade from SQL Server 7.0 or
> is
> > > this
> > > > > SQL
> > > > > > > > > Server
> > > > > > > > > > 2000 a "named instance" with a default installation of
SQL
> > > > Server
> > > > > > 7.0?
> > > > > > > > As
> > > > > > > > > > this might be related to a post-SP3 bug. See KB 814035
> > > (Q814035)
> > > > > > FIX:
> > > > > > > A
> > > > > > > > > > Full-Text Population Fails After You Apply SQL Server
2000
> > > > Service
> > > > > > > Pack
> > > > > > > > 3
> > > > > > > > > > at:
> > > > > > > > > >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > > > > > > > (80004002 -
> > > > > > > > > > No such interface supported)
> > > > > > > > > >
> > > > > > > > > > Regards,
> > > > > > > > > > John
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > > > > > > > Hi,
> > > > > > > > > > >
> > > > > > > > > > > We have SQL Server private installation on which we
are
> > > > > developing
> > > > > > > an
> > > > > > > > > > > application and public installation on whict we will
be
> > > > > deploying
> > > > > > > the
> > > > > > > > > > > application. All instances have run Windows 2003
> > Enterprise
> > > > > > Edition
> > > > > > > > with
> > > > > > > > > > SQL
> > > > > > > > > > > 2000 SP3. However, the public installation MS Search
is
> > not
> > > > > > > > functioning
> > > > > > > > > > > correctly. Basically it will not full-text indeed
> > databases
> > > > and
> > > > > > > > > produces
> > > > > > > > > > > the following error
> > > > > > > > > > >
> > > > > > > > > > > 1> exec sp_fulltext_database 'enable'
> > > > > > > > > > > 2> go
> > > > > > > > > > > (1 row affected)
> > > > > > > > > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > > > > > > > > sp_fulltext_database,
> > > > > > > > > > > Lin
> > > > > > > > > > > e 46
> > > > > > > > > > > The Microsoft Search service cannot be administered
> under
> > > the
> > > > > > > present
> > > > > > > > > user
> > > > > > > > > > > account
> > > > > > > > > > >
> > > > > > > > > > > Now, we have tried many things to try and solve this
> > error,
> > > > > mainly
> > > > > > > > based
> > > > > > > > > > on
> > > > > > > > > > > search newsgroups, which are itemized below:
> > > > > > > > > > >
> > > > > > > > > > > 1 Reboot System and reexecute sp_
> > > > > > > > > > > 2 Complete reinstall of SQL on system, then
> reapplication
> > of
> > > > SP3
> > > > > > > > > > > 3 Same as above (2) but reapply SP3a
> > > > > > > > > > > 4 Remove SQL Server installation subkey in order that
> can
> > > > > > reinstall
> > > > > > > > > > > full-text search only, then reapply SP3
> > > > > > > > > > > 5 Check from keys under
> > > > > > > > > > >
> > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\
> > > > > to
> > > > > > > make
> > > > > > > > > > sure
> > > > > > > > > > > SQL Server was there. It wasn't, removed SQL subkey
and
> > > > > > reinstalled,
> > > > > > > > > > > re-adding full-text search as an option (to re-install
> > > > > full-text)
> > > > > > > then
> > > > > > > > > > > reapplied SP3
> > > > > > > > > > > 6 Try reinstall, but do not reapply SP3 until have
> > full-text
> > > > > > enabled
> > > > > > > > the
> > > > > > > > > > > database.
> > > > > > > > > > >
> > > > > > > > > > > None of the above worked. We still have a none
> functioning
> > > > > > mssearch
> > > > > > > > and
> > > > > > > > > > > full-text disabled database on the system.
> > > > > > > > > > >
> > > > > > > > > > > We have even tried enabling on a blank database. This
> > does
> > > > not
> > > > > > work
> > > > > > > > > > either.
> > > > > > > > > > >
> > > > > > > > > > > PLEASE HELP! Getting desperate as the whole
application
> > > > depends
> > > > > on
> > > > > > > > > having
> > > > > > > > > > > search ability.
> > > > > > > > > > >
> > > > > > > > > > > Thanks
> > > > > > > > > > >
> > > > > > > > > > > Oz
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Oh oh, John,
Developed other errors now. Please see this message.
Any ideans what's causing this now?
Hi,
We can successfully create catalogs on a database on our server. However,
we can never get any data from any of the searches. We have since
discovered a few errors in the Application log.
Version of SQL running is:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copy
right (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows
NT 5.2 (Build 3790: )
SP3 has been applied and re-applied.
Errors are as follows:
The crawl on project <SQLServer SQL0000700005> cannot be started. All of the
crawl seeds have been ignored because of host, extension, or other URL
restrictions. Error: 80040d07 - The specified URL is excluded and will not
be cataloged. The URL restriction rules may have to be modified to include
this URL.
One or more warnings or errors for Gatherer project <SQLServer
SQL0000700005> were logged to file <C:\Program Files\Microsoft SQL
Server\MSSQL\FTDATA\SQLServer\GatherLogs\SQL0000700005.1.gthr>. If you are
interested in these messages, please, look at the file using the gatherer
log query object (gthrlog.vbs, log viewer web page).
The crawl on project <SQLServer SQL0000700005> cannot be started. All of the
crawl seeds have been ignored because of host, extension, or other URL
restrictions. Error: 80040d07 - The specified URL is excluded and will not
be cataloged. The URL restriction rules may have to be modified to include
this URL.
Error from the gthrlog.vbs file reveals the following:
C:\Program Files\Common Files\System\MSSearch\Bin>cscript gthrlog.vbs
"C:\Progra
m Files\Microsoft SQL
Server\MSSQL\FTDATA\SQLServer\GatherLogs\SQL0000700005.1.g
thr"
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
5/18/2004 11:26:44 AM Add The gatherer has started
5/18/2004 11:26:48 AM Add The initialization has completed
5/18/2004 11:27:16 AM Add Started Full crawl
5/18/2004 11:27:16 AM MSSQL75://SQLServer/75d7831f Add URL is
excluded
because the URL protocol is not recognized or restricted
5/18/2004 11:27:16 AM Add Completed Full crawl
C:\Program Files\Common Files\System\MSSearch\Bin>
Yours desperately.
Os
"John Kane" <jt-kane@.comcast.net> wrote in message
news:#u9X4nBPEHA.2468@.TK2MSFTNGP11.phx.gbl...
> You're welcome, Oz!
> John
>
> "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> news:elrLgI#OEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > Hi John,
> >
> > Well, in case anyone searching this group has a similar problem, it may
> have
> > been drastic, but i finally got FullText to work properly.
> >
> > Check out this MS Article:
> >
> > http://support.microsoft.com/?kbid=827449
> >
> > Thanks for ALL your help John. You really hung in their with me.
> >
> > Cheers
> >
> > Oz
> >
> >
> > "John Kane" <jt-kane@.comcast.net> wrote in message
> > news:#tRBGI2NEHA.3016@.tk2msftngp13.phx.gbl...
> > > Oz,
> > > This seems to be an installation gone really bad... Below are the
> > > instructions, I've posted in this newsgroup that has been very
> successful
> > in
> > > resolving a number of SQL FTS related issues. However, with the new
> error
> > > (The parameter is incorrect), this re-installation may or may NOT be
> > > successful and you may have to remove SQL Server and the MSSearch
> > components
> > > and re-install SQL Server again.
> > >
> > > Re-install" the "Full-text Search" components via deleting (or
renaming)
> > the
> > > below "tracking key" and re-install (If you're not using a named
> instance,
> > > remove "<Instance_Name>\".)
> > >
> > > NOTE: be sure to be logged on to the server as either Administrator or
> as
> > a
> > > member of the server's Admin Group!
> > >
> > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> > > Server\<Instance_Name>\Tracking\
> > > {E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
> > >
> > > Once you've done removed (renamed) the above tracking key, then delete
> the
> > > MSSearch directory from either:
> > >
> > > drive_letter:\Program Files\Common Files\Microsoft Shared\
> > > or
> > > drive_letter::\Program Files\Common Files\System\
> > >
> > > Then using your SQL Server 2000 installation CD re-install via "Custom
> > > Installation" the Full-Text Search component (it should be
un-checked).
> > When
> > > this completes find and save these files: SearchSetup.log (usually
under
> > > \windows or \winnt folders) and sqlsp.log. If any problems, please
post
> > > these files.
> > >
> > > Re-install SQL Server 2000 Service pack (SP3) if this service has been
> > > applied, so that the newly installed MSSearch components are upgraded
to
> > > SP3a levels and then re-boot &/or restart the MSSearch and MSSQLServer
> > > services.
> > >
> > > Note, if the method above fails (and there are other methods) you
might
> > need
> > > to open a support case with Microsoft PSS SQL Server Support...
> > >
> > > Regards,
> > > John
> > >
> > >
> > >
> > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > news:O6wrjyxNEHA.3816@.TK2MSFTNGP12.phx.gbl...
> > > > John,
> > > >
> > > > I did that and therefore reinstalled full-text. Actually i have
done
> > this
> > > > before, but it's worth walking through it again with you as you may
> see
> > > > something i don't. I have not yet applied SP3 to the new full-text
> > > > installation. However, what i get now is another error.
> > > >
> > > > 'Execution of full-text operation failed. The parameter is
incorrect'
> > > >
> > > > I have also manually tried running
> > > > sp_fulltext_database 'enable'
> > > >
> > > > and that is the same error generated.
> > > >
> > > > I used to FT wizard to try and create the FT index.
> > > >
> > > > Do you see anything here?
> > > >
> > > > Thanks
> > > >
> > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > news:u1HdIRwNEHA.892@.TK2MSFTNGP09.phx.gbl...
> > > > > Oz,
> > > > > When you say that the FTData directory was empty, do you mean NO
> > files,
> > > or
> > > > > just no gatherer log files?
> > > > > If the former, then this is a problem as the \FTDATA directory
> should
> > > look
> > > > > something like this (edited):
> > > > >
> > > > > Directory of F:\MSSQL80\MSSQL\FTDATA
> > > > >
> > > > > 05/14/2003 12:45 PM <DIR> .
> > > > > 05/14/2003 12:45 PM <DIR> ..
> > > > > 12/06/2003 07:21 PM <DIR> SQL0000500005 -- FT Catalog
> > > folder
> > > > > 05/14/2003 12:45 PM <DIR> SQLServer
> > > > > 0 File(s) 0 bytes
> > > > >
> > > > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQL0000500005
> > > > >
> > > > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer
> > > > >
> > > > > 05/14/2003 12:45 PM <DIR> .
> > > > > 05/14/2003 12:45 PM <DIR> ..
> > > > > 05/14/2003 12:45 PM <DIR> Config
> > > > > 05/10/2004 03:30 AM <DIR> GatherLogs
> > > > > 05/14/2003 12:45 PM <DIR> Projects
> > > > > 0 File(s) 0 bytes
> > > > >
> > > > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\Config
> > > > >
> > > > > 05/14/2003 12:45 PM <DIR> .
> > > > > 05/14/2003 12:45 PM <DIR> ..
> > > > > 05/14/2003 12:45 PM 1,771 Gathrprm.Txt
> > > > > 06/16/2000 11:30 PM 1,696 noise.chs
> > > > > 06/16/2000 11:30 PM 1,696 noise.cht
> > > > > 06/16/2000 11:30 PM 687 noise.dat
> > > > > 06/16/2000 11:30 PM 149,848 noise.deu
> > > > > 06/16/2000 11:30 PM 697 noise.eng
> > > > > 06/16/2000 11:30 PM 697 noise.enu
> > > > > 06/16/2000 11:30 PM 19,684 noise.esn
> > > > > 06/16/2000 11:30 PM 49,196 noise.fra
> > > > > 06/16/2000 11:30 PM 19,616 noise.ita
> > > > > 06/16/2000 11:30 PM 10,724 noise.jpn
> > > > > 06/16/2000 11:30 PM 697 noise.kor
> > > > > 06/16/2000 11:30 PM 13,256 noise.nld
> > > > > 06/16/2000 11:30 PM 13,728 noise.sve
> > > > > 04/28/2000 12:06 AM 4,576 Schema.Txt
> > > > > 05/05/2000 04:35 PM 536 tschs.xml
> > > > > 05/05/2000 04:35 PM 536 tscht.xml
> > > > > 05/05/2000 04:35 PM 536 tsdut.xml
> > > > > 05/05/2000 04:35 PM 536 tseng.xml
> > > > > 05/05/2000 04:35 PM 536 tsenu.xml
> > > > > 05/05/2000 04:35 PM 536 tsfra.xml
> > > > > 05/05/2000 04:35 PM 536 tsger.xml
> > > > > 05/05/2000 04:35 PM 536 tsita.xml
> > > > > 05/05/2000 04:35 PM 536 tsjap.xml
> > > > > 05/05/2000 04:35 PM 536 tskor.xml
> > > > > 05/05/2000 04:35 PM 536 tsneu.xml
> > > > > 05/05/2000 04:35 PM 810 tsschema.xml
> > > > > 05/05/2000 04:35 PM 536 tsspa.xml
> > > > > 05/05/2000 04:35 PM 536 tsswe.xml
> > > > > 29 File(s) 296,347 bytes
> > > > >
> > > > > Directory of F:\MSSQL80\MSSQL\FTDATA\SQLServer\GatherLogs
> > > > >
> > > > > 05/10/2004 03:30 AM <DIR> .
> > > > > 05/10/2004 03:30 AM <DIR> ..
> > > > > 05/06/2004 04:06 AM 66 SQL0000500005.142.gthr
> > > > > 05/08/2004 03:30 AM 66 SQL0000500005.143.gthr
> > > > > 05/08/2004 06:27 PM 264 SQL0000500005.144.gthr
> > > > > 05/09/2004 04:04 AM 66 SQL0000500005.145.gthr
> > > > > 05/10/2004 03:30 AM 66 SQL0000500005.146.gthr
> > > > > 05/06/2004 04:06 AM 66 SQL0000600005.101.gthr
> > > > > 05/07/2004 03:32 AM 66 SQL0000600005.102.gthr
> > > > > 05/08/2004 06:27 PM 264 SQL0000600005.103.gthr
> > > > > 05/09/2004 04:04 AM 66 SQL0000600005.104.gthr
> > > > > 05/10/2004 03:30 AM 66 SQL0000600005.105.gthr
> > > > > 10 File(s) 1,056 bytes
> > > > >
> > > > >
> > > > > While you may not have files in the GatherLog dir, you MUST have
the
> > > above
> > > > > files in the \FTDATA\SQLServer\Config.
> > > > > If not, then this *might* be the source of this issue.
> > > > >
> > > > > Regards,
> > > > > John
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > news:eTADCIrNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> > > > > > Ok,
> > > > > >
> > > > > > Will do.
> > > > > >
> > > > > > I'm talking about the FTData directory. It was there, but it was
> > > blank.
> > > > > So
> > > > > > i couldn't check for gatherer files etc.
> > > > > >
> > > > > > Thanks
> > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > news:uBU3C6pNEHA.1340@.TK2MSFTNGP12.phx.gbl...
> > > > > > > You're welcome, Oz,
> > > > > > > When you said "It's just occurred, to me, there is nothing in
> > those
> > > > > > > directories as i cannot enable the database for full-text!"
> > > > > > > What directories were you referring to?
> > > > > > >
> > > > > > > Could you change the MSSQLServer service startup account to
the
> > > system
> > > > > > > account (LocalSystem) via the Enterprise Manager's server
> property
> > > > > > security
> > > > > > > tab? This should stop and restart SQL Server and attempt to
> > > FT-enable
> > > > > the
> > > > > > > Pubs database and the authors table and let me know the result
> of
> > > the
> > > > > > that?
> > > > > > >
> > > > > > > Thanks,
> > > > > > > John
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > > > > Also John,
> > > > > > > >
> > > > > > > > I have always been running a local (i.e. Domain user)
account
> as
> > > the
> > > > > SQL
> > > > > > > > account, althought it is not a member of the administrators
> > group.
> > > > > This
> > > > > > > is
> > > > > > > > one of the things i tried (adding it to the admins group),
but
> > > > didn't
> > > > > > > help.
> > > > > > > >
> > > > > > > > Thanks
> > > > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > > > news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > > > > > > > > You're welcome, Oz,
> > > > > > > > > Yes, there are MSSearch gatherer log files located under
> > > > > > > > > \FTDATA\SQLServer\GatherLogs\ that can be "read" using
> > > > gthrlog.vbs,
> > > > > > > > however,
> > > > > > > > > they most likely will have the same error (MSSearch
service
> > > cannot
> > > > > be
> > > > > > > > > admin..), so they are of little value in this issue.
> > > > > > > > >
> > > > > > > > > Is this SQL Server installed on a Domain Controller (DC)
> > server
> > > or
> > > > > is
> > > > > > > the
> > > > > > > > > MSSQLServer startup account the DOMAIN\Administrator
> account?
> > > > > > > > >
> > > > > > > > > While this should work, it's been my experience that with
> > > > Full-Text
> > > > > > > Search
> > > > > > > > > (FTS) on DC's that this is a problem for the "Microsoft
> > Search"
> > > > > > > (MSSearch)
> > > > > > > > > service. If you are using the DOMAIN\Administrator
account,
> > > create
> > > > a
> > > > > > > local
> > > > > > > > > machine account and add this account into the DC's
> > Administrator
> > > > > Group
> > > > > > > and
> > > > > > > > > then change the MSSQLServer startup account in the
> Enterprise
> > > > > Manager
> > > > > > > > (this
> > > > > > > > > change MUST be done here) server's security tab. This
should
> > > stop
> > > > > and
> > > > > > > > > restart SQL Server and if all is successfully completed,
FTS
> > on
> > > a
> > > > DC
> > > > > > > > > *should* work...
> > > > > > > > >
> > > > > > > > > Regards,
> > > > > > > > > John
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > > > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > > > > > > > > John
> > > > > > > > > >
> > > > > > > > > > Is there a log file somewhere that i could try and see
> what
> > > > > > precisely
> > > > > > > is
> > > > > > > > > > causing this problem.
> > > > > > > > > >
> > > > > > > > > > Thanks
> > > > > > > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > > > > > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > > > > > > > > Oz,
> > > > > > > > > > > In addition to the many things you tried below... a
> couple
> > > of
> > > > > > things
> > > > > > > > > > > specific to MSSearch and the MSSQLServer services...
> > > > > > > > > > > 1. Is the MSSearch service started and running under
the
> > > > System
> > > > > > > > > > > (LocalSystem) account? If not, then change it to
> > LocalSystem
> > > > and
> > > > > > > stop
> > > > > > > > > and
> > > > > > > > > > > re-start this service.
> > > > > > > > > > >
> > > > > > > > > > > 2. Have you or anyone else change the MSSQLServer
> account
> > > &/or
> > > > > > > > password
> > > > > > > > > > via
> > > > > > > > > > > Win2K's Component service? IF so, then you MUST
> re-change
> > > the
> > > > > > change
> > > > > > > > via
> > > > > > > > > > the
> > > > > > > > > > > Enterprise Manager's server property security tab as
> this
> > is
> > > > the
> > > > > > > only
> > > > > > > > > > place
> > > > > > > > > > > where the two services security are kept in sync. See
KB
> > > > article
> > > > > > > > 277549
> > > > > > > > > > > (Q277549) PRB: Unable to Build Full-Text Catalog After
> You
> > > > > Modify
> > > > > > > > > > > MSSQLServer Logon Account Through [NT4.0) Control
Panel
> > [or
> > > > > Win2K
> > > > > > > > > > Component
> > > > > > > > > > > Services] at
> > > > > > > > > >
> > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > > > > > > > > >
> > > > > > > > > > > 3. Have you or anyone else removed or modified the
> > > > > > > > > BUILTIN\Administrator
> > > > > > > > > > > login on this server? If so, you MUST either re-add it
> > with
> > > > all
> > > > > of
> > > > > > > > it's
> > > > > > > > > > > normal default rights, especially sysadmin rights and
> with
> > > the
> > > > > > > default
> > > > > > > > > > > database as master and the default language of English
> or
> > > use
> > > > > the
> > > > > > > > > > following
> > > > > > > > > > > T-SQL code to add the correct permissions:
> > > > > > > > > > >
> > > > > > > > > > > exec sp_grantlogin N'NT Authority\System'
> > > > > > > > > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > > > > > > > > exec sp_defaultlanguage N'NT
> > Authority\System','us_english'
> > > > > > > > > > > exec sp_addsrvrolemember N'NT Authority\System',
> sysadmin
> > > > > > > > > > >
> > > > > > > > > > > Additionally, but not necessarily related to the error
> in
> > > the
> > > > > > > subject
> > > > > > > > > > line,
> > > > > > > > > > > has this server ever been upgrade from SQL Server 7.0
or
> > is
> > > > this
> > > > > > SQL
> > > > > > > > > > Server
> > > > > > > > > > > 2000 a "named instance" with a default installation of
> SQL
> > > > > Server
> > > > > > > 7.0?
> > > > > > > > > As
> > > > > > > > > > > this might be related to a post-SP3 bug. See KB 814035
> > > > (Q814035)
> > > > > > > FIX:
> > > > > > > > A
> > > > > > > > > > > Full-Text Population Fails After You Apply SQL Server
> 2000
> > > > > Service
> > > > > > > > Pack
> > > > > > > > > 3
> > > > > > > > > > > at:
> > > > > > > > > > >
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > > > > > > > > (80004002 -
> > > > > > > > > > > No such interface supported)
> > > > > > > > > > >
> > > > > > > > > > > Regards,
> > > > > > > > > > > John
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > > > > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > > > > > > > > Hi,
> > > > > > > > > > > >
> > > > > > > > > > > > We have SQL Server private installation on which we
> are
> > > > > > developing
> > > > > > > > an
> > > > > > > > > > > > application and public installation on whict we will
> be
> > > > > > deploying
> > > > > > > > the
> > > > > > > > > > > > application. All instances have run Windows 2003
> > > Enterprise
> > > > > > > Edition
> > > > > > > > > with
> > > > > > > > > > > SQL
> > > > > > > > > > > > 2000 SP3. However, the public installation MS
Search
> is
> > > not
> > > > > > > > > functioning
> > > > > > > > > > > > correctly. Basically it will not full-text indeed
> > > databases
> > > > > and
> > > > > > > > > > produces
> > > > > > > > > > > > the following error
> > > > > > > > > > > >
> > > > > > > > > > > > 1> exec sp_fulltext_database 'enable'
> > > > > > > > > > > > 2> go
> > > > > > > > > > > > (1 row affected)
> > > > > > > > > > > > Msg 7635, Level 16, State 1, Server SIMP001,
Procedure
> > > > > > > > > > > sp_fulltext_database,
> > > > > > > > > > > > Lin
> > > > > > > > > > > > e 46
> > > > > > > > > > > > The Microsoft Search service cannot be administered
> > under
> > > > the
> > > > > > > > present
> > > > > > > > > > user
> > > > > > > > > > > > account
> > > > > > > > > > > >
> > > > > > > > > > > > Now, we have tried many things to try and solve this
> > > error,
> > > > > > mainly
> > > > > > > > > based
> > > > > > > > > > > on
> > > > > > > > > > > > search newsgroups, which are itemized below:
> > > > > > > > > > > >
> > > > > > > > > > > > 1 Reboot System and reexecute sp_
> > > > > > > > > > > > 2 Complete reinstall of SQL on system, then
> > reapplication
> > > of
> > > > > SP3
> > > > > > > > > > > > 3 Same as above (2) but reapply SP3a
> > > > > > > > > > > > 4 Remove SQL Server installation subkey in order
that
> > can
> > > > > > > reinstall
> > > > > > > > > > > > full-text search only, then reapply SP3
> > > > > > > > > > > > 5 Check from keys under
> > > > > > > > > > > >
> > > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\
> > > > > > to
> > > > > > > > make
> > > > > > > > > > > sure
> > > > > > > > > > > > SQL Server was there. It wasn't, removed SQL subkey
> and
> > > > > > > reinstalled,
> > > > > > > > > > > > re-adding full-text search as an option (to
re-install
> > > > > > full-text)
> > > > > > > > then
> > > > > > > > > > > > reapplied SP3
> > > > > > > > > > > > 6 Try reinstall, but do not reapply SP3 until have
> > > full-text
> > > > > > > enabled
> > > > > > > > > the
> > > > > > > > > > > > database.
> > > > > > > > > > > >
> > > > > > > > > > > > None of the above worked. We still have a none
> > functioning
> > > > > > > mssearch
> > > > > > > > > and
> > > > > > > > > > > > full-text disabled database on the system.
> > > > > > > > > > > >
> > > > > > > > > > > > We have even tried enabling on a blank database.
This
> > > does
> > > > > not
> > > > > > > work
> > > > > > > > > > > either.
> > > > > > > > > > > >
> > > > > > > > > > > > PLEASE HELP! Getting desperate as the whole
> application
> > > > > depends
> > > > > > on
> > > > > > > > > > having
> > > > > > > > > > > > search ability.
> > > > > > > > > > > >
> > > > > > > > > > > > Thanks
> > > > > > > > > > > >
> > > > > > > > > > > > Oz
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||"Oz" <Oz(no_spam)@.nospam.com> wrote in message
news:u%23MU3YrNEHA.3744@.TK2MSFTNGP11.phx.gbl...
> Identical error on pubs database John.
> Thanks
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:uBU3C6pNEHA.1340@.TK2MSFTNGP12.phx.gbl...
> > You're welcome, Oz,
> > When you said "It's just occurred, to me, there is nothing in those
> > directories as i cannot enable the database for full-text!"
> > What directories were you referring to?
> >
> > Could you change the MSSQLServer service startup account to the system
> > account (LocalSystem) via the Enterprise Manager's server property
> security
> > tab? This should stop and restart SQL Server and attempt to FT-enable
the
> > Pubs database and the authors table and let me know the result of the
> that?
> >
> > Thanks,
> > John
> >
> >
> >
> > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > news:usHda6lNEHA.3944@.tk2msftngp13.phx.gbl...
> > > Also John,
> > >
> > > I have always been running a local (i.e. Domain user) account as the
SQL
> > > account, althought it is not a member of the administrators group.
This
> > is
> > > one of the things i tried (adding it to the admins group), but didn't
> > help.
> > >
> > > Thanks
> > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > news:OeY1j4QNEHA.2144@.TK2MSFTNGP10.phx.gbl...
> > > > You're welcome, Oz,
> > > > Yes, there are MSSearch gatherer log files located under
> > > > \FTDATA\SQLServer\GatherLogs\ that can be "read" using gthrlog.vbs,
> > > however,
> > > > they most likely will have the same error (MSSearch service cannot
be
> > > > admin..), so they are of little value in this issue.
> > > >
> > > > Is this SQL Server installed on a Domain Controller (DC) server or
is
> > the
> > > > MSSQLServer startup account the DOMAIN\Administrator account?
> > > >
> > > > While this should work, it's been my experience that with Full-Text
> > Search
> > > > (FTS) on DC's that this is a problem for the "Microsoft Search"
> > (MSSearch)
> > > > service. If you are using the DOMAIN\Administrator account, create a
> > local
> > > > machine account and add this account into the DC's Administrator
Group
> > and
> > > > then change the MSSQLServer startup account in the Enterprise
Manager
> > > (this
> > > > change MUST be done here) server's security tab. This should stop
and
> > > > restart SQL Server and if all is successfully completed, FTS on a DC
> > > > *should* work...
> > > >
> > > > Regards,
> > > > John
> > > >
> > > >
> > > >
> > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > news:OqqhS1ONEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > > > > John
> > > > >
> > > > > Is there a log file somewhere that i could try and see what
> precisely
> > is
> > > > > causing this problem.
> > > > >
> > > > > Thanks
> > > > > "John Kane" <jt-kane@.comcast.net> wrote in message
> > > > > news:eaSiYlKNEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > > > > > Oz,
> > > > > > In addition to the many things you tried below... a couple of
> things
> > > > > > specific to MSSearch and the MSSQLServer services...
> > > > > > 1. Is the MSSearch service started and running under the System
> > > > > > (LocalSystem) account? If not, then change it to LocalSystem and
> > stop
> > > > and
> > > > > > re-start this service.
> > > > > >
> > > > > > 2. Have you or anyone else change the MSSQLServer account &/or
> > > password
> > > > > via
> > > > > > Win2K's Component service? IF so, then you MUST re-change the
> change
> > > via
> > > > > the
> > > > > > Enterprise Manager's server property security tab as this is the
> > only
> > > > > place
> > > > > > where the two services security are kept in sync. See KB article
> > > 277549
> > > > > > (Q277549) PRB: Unable to Build Full-Text Catalog After You
Modify
> > > > > > MSSQLServer Logon Account Through [NT4.0) Control Panel [or
Win2K
> > > > > Component
> > > > > > Services] at
> > > > > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
> > > > > >
> > > > > > 3. Have you or anyone else removed or modified the
> > > > BUILTIN\Administrator
> > > > > > login on this server? If so, you MUST either re-add it with all
of
> > > it's
> > > > > > normal default rights, especially sysadmin rights and with the
> > default
> > > > > > database as master and the default language of English or use
the
> > > > > following
> > > > > > T-SQL code to add the correct permissions:
> > > > > >
> > > > > > exec sp_grantlogin N'NT Authority\System'
> > > > > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > > > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > > > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > > > > >
> > > > > > Additionally, but not necessarily related to the error in the
> > subject
> > > > > line,
> > > > > > has this server ever been upgrade from SQL Server 7.0 or is this
> SQL
> > > > > Server
> > > > > > 2000 a "named instance" with a default installation of SQL
Server
> > 7.0?
> > > > As
> > > > > > this might be related to a post-SP3 bug. See KB 814035 (Q814035)
> > FIX:
> > > A
> > > > > > Full-Text Population Fails After You Apply SQL Server 2000
Service
> > > Pack
> > > > 3
> > > > > > at:
> > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;814035
> > > > (80004002 -
> > > > > > No such interface supported)
> > > > > >
> > > > > > Regards,
> > > > > > John
> > > > > >
> > > > > >
> > > > > > "Oz" <Oz(no_spam)@.nospam.com> wrote in message
> > > > > > news:eytulHGNEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > > > > > > Hi,
> > > > > > >
> > > > > > > We have SQL Server private installation on which we are
> developing
> > > an
> > > > > > > application and public installation on whict we will be
> deploying
> > > the
> > > > > > > application. All instances have run Windows 2003 Enterprise
> > Edition
> > > > with
> > > > > > SQL
> > > > > > > 2000 SP3. However, the public installation MS Search is not
> > > > functioning
> > > > > > > correctly. Basically it will not full-text indeed databases
and
> > > > > produces
> > > > > > > the following error
> > > > > > >
> > > > > > > 1> exec sp_fulltext_database 'enable'
> > > > > > > 2> go
> > > > > > > (1 row affected)
> > > > > > > Msg 7635, Level 16, State 1, Server SIMP001, Procedure
> > > > > > sp_fulltext_database,
> > > > > > > Lin
> > > > > > > e 46
> > > > > > > The Microsoft Search service cannot be administered under the
> > > present
> > > > > user
> > > > > > > account
> > > > > > >
> > > > > > > Now, we have tried many things to try and solve this error,
> mainly
> > > > based
> > > > > > on
> > > > > > > search newsgroups, which are itemized below:
> > > > > > >
> > > > > > > 1 Reboot System and reexecute sp_
> > > > > > > 2 Complete reinstall of SQL on system, then reapplication of
SP3
> > > > > > > 3 Same as above (2) but reapply SP3a
> > > > > > > 4 Remove SQL Server installation subkey in order that can
> > reinstall
> > > > > > > full-text search only, then reapply SP3
> > > > > > > 5 Check from keys under
> > > > > > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\
> to
> > > make
> > > > > > sure
> > > > > > > SQL Server was there. It wasn't, removed SQL subkey and
> > reinstalled,
> > > > > > > re-adding full-text search as an option (to re-install
> full-text)
> > > then
> > > > > > > reapplied SP3
> > > > > > > 6 Try reinstall, but do not reapply SP3 until have full-text
> > enabled
> > > > the
> > > > > > > database.
> > > > > > >
> > > > > > > None of the above worked. We still have a none functioning
> > mssearch
> > > > and
> > > > > > > full-text disabled database on the system.
> > > > > > >
> > > > > > > We have even tried enabling on a blank database. This does
not
> > work
> > > > > > either.
> > > > > > >
> > > > > > > PLEASE HELP! Getting desperate as the whole application
depends
> on
> > > > > having
> > > > > > > search ability.
> > > > > > >
> > > > > > > Thanks
> > > > > > >
> > > > > > > Oz
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Friday, March 30, 2012

Microsoft SQL Server 2005 Express Edition Toolkit Is not in my Add Remove Programs how do I unin

Wednesday, March 28, 2012

Microsoft SQL Express 2005 Installation Failure

Microsoft SQL Express 2005 Installation Failure

Microsoft search service kills SQL 2000 server

Microsoft Search service can't start after SQL2005 installation!

Microsoft Search service can't start after SQL2005 installation!

Microsoft Search service can't start after SQL2005 installation!

'Microsoft Search service cannot be administered under the present user error' SP3

'Microsoft Search service cannot be administered under the present user error' SP3

'Microsoft Search service cannot be administered under the present user error' SP3

'Microsoft Search service cannot be administered under the present user error' SP3

Merging two dbs

Blog Archive

About Me