Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marconi8
Yak Posting Veteran
73 Posts |
 Posted - 2003-05-04 : 05:37:06
|
| i want to make some fields of table using full-text index, but before that i must to enable sp_fulltext_database on this database,after batch has finish execute USE myDBEXEC sp_fulltext_database 'enable'i get the error like = The Full-Text Service (Microsoft Search) is not available. The system administrator must start this service.what this error realy mean, and how to correct thisthanks1) microsoft search service is running under local sys accountEdited by - marconi8 on 05/04/2003 05:40:04 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-04 : 10:54:42
|
| Does your local sys account have admister rights? |
 |
|
|
marconi8
Yak Posting Veteran
73 Posts |
Posted - 2003-05-04 : 12:54:06
|
| hm, in service is checked, start as local system accountin local users and groups, only one is enabled, this is me, i have administrator and all rights on my home pc, but others, like administrator are disabledi have disabled administrator account in my systemmaybe you know some usefull links, because in this thinkgs i something dont understand, i must something to read, but what exactly ? |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-04 : 13:43:58
|
| well you either give the local account sys admin rights or start the service using your account.Whatever account you use will have to have permissions to start services.Edited by - ValterBorges on 05/04/2003 13:49:05 |
|
|
|
marconi8
Yak Posting Veteran
73 Posts |
Posted - 2003-05-04 : 15:35:07
|
| at this moment i'am in panic, readeed all installation steps about 2000 mssql server i have noticed that each installation manual is different, and i realy dont know how to normally install mssql 2000 server, some minutes ago i have deinstalled my mssql server, and all about installation i have readed from microsoft.com, at this moment i cannot access sql server...i really try to get from you help, help is like = give me please a link where will be described normall mssql server installationi am newbie to mssql server administration and some things i cannot understand, because all installation steps that i have downloaded are different. :( one of my problem during installation is, that i cannot use user account that i have created in windows, mssql installation always write to me that i must to check account, i realy dont undestand why ? :( |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-04 : 17:42:16
|
| When you installed sql server did you specify mixed mode login (SQL and Windows Integration). ?Some links for you.http://www.microsoft.com/sql/support/default.asphttp://support.microsoft.com/default.aspx?scid=kb;en-us;q257716 |
|
|
|
marconi8
Yak Posting Veteran
73 Posts |
Posted - 2003-05-05 : 02:44:50
|
| thanks, for links, i have readed also some manuals and my problem was successfully solved |
|
|
|
|
|
|
|
|
sp_fulltext_database, i get the error using that f