September 23, 2004 at 10:21 am
i hav 2 databases on an sqlserver. the 1st one contains fulltext catalogs, the 2nd one has a stored proc with a bulk insert statement which access a remote csv file.
for full text indexing to work i think sqlserver needs to be started by a local user, but for the bulk insert statement to work, sqlserver needs to be started by a domain user who has read access to the remote file.
can i solve the problem by starting two sqlserver instances, one by the local user and the second one by a domain user, and hav the two databases on the two instances.
am not sure whether this is the right solution for my problem.
please help.
renjith
September 23, 2004 at 11:51 am
It's not true that SQL Server must be started by a local user for full-text indexing to work. We use full-text indexes on serveral databases on a server whose service is started by a domain account.
Greg
Greg
September 24, 2004 at 1:19 am
Greg is correct. SQL Server 2000 Full-text Search (FTS) can functionally successfully with the MSSQLServer service running under the system account (LocalSystem - your "local user"?) as well as under a DOMAIN\account. However, the DOMAIN\Account should be a member of the server's local Admin. group and the BUILTIN\Administrator login should exist and have Sysadmin rights and the master database as the default database.
However, there can be an issue with using the Enterpise Manager when the MSSQLServer service is started with "local accounts", see KB article 270671 (Q270671) "PRB: Full Text Search Menus Are Not Enabled for Local Windows NT Accounts" at
http://support.microsoft.com/default.aspx?scid=KB;en-us;q270671 for details. Perhaps this is what you are referring to as your "local user"?
Regards,
John T. Kane
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply