Account under SQL Server

How do I know which account under which the SQL Server 2000 runs ?On Enterprise Manager, select your server, right-click, Properties and
Security tab.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:

> How do I know which account under which the SQL Server 2000 runs ?
>
>|||Hi Ben,
I am asking this question because I still stuck in my full-text search
problem.
I tried to do many thing to get around it like to change user account to
start up SQLServer.
I just posted a thread regarding changing the account start up the
SQLServer, if you can help me that would be great.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...[vbcol=seagreen]
> On Enterprise Manager, select your server, right-click, Properties and
> Security tab.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
>|||Full-Text Search is another Windows service. What is the problem?
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:

> Hi Ben,
> I am asking this question because I still stuck in my full-text search
> problem.
> I tried to do many thing to get around it like to change user account to
> start up SQLServer.
> I just posted a thread regarding changing the account start up the
> SQLServer, if you can help me that would be great.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
>
>|||I created a catalog in SQL Server 2000 but cannot get results from this
catalog by issuing the SQL with CONTAINS. It just return empty set with
headers only.
The status of the catalog is always idle even after full population.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...[vbcol=seagreen]
> Full-Text Search is another Windows service. What is the problem?
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
>|||Probably Full-Text Search is running as System Local and has no permissions
to SQL Server. Try running the Full-Text Search using the same service
account as SQL Server. This time use the Control Panel / Services applet. Th
e
service must be named MSSearch or something similar.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:

> I created a catalog in SQL Server 2000 but cannot get results from this
> catalog by issuing the SQL with CONTAINS. It just return empty set with
> headers only.
> The status of the catalog is always idle even after full population.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
>
>|||Hi Ben,
I go to EM, right click my server instance, select the "Edit Registered SQL
Server Properties" knowing that I checked the
"Use SQL Server authentication".
Am I going to use that account in the Control Panel - Services ?
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> Probably Full-Text Search is running as System Local and has no
permissions
> to SQL Server. Try running the Full-Text Search using the same service
> account as SQL Server. This time use the Control Panel / Services applet.
The[vbcol=seagreen]
> service must be named MSSearch or something similar.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
>
search[vbcol=seagreen]
account to[vbcol=seagreen]
and[vbcol=seagreen]
?[vbcol=seagreen]|||Right-click the server and select 'Properties', follow the instructions I
already sent.
Do not select 'Edit SQL Server Registration Properties'.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:

> Hi Ben,
> I go to EM, right click my server instance, select the "Edit Registered SQ
L
> Server Properties" knowing that I checked the
> "Use SQL Server authentication".
> Am I going to use that account in the Control Panel - Services ?
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> permissions
> The
> search
> account to
> and
> ?
>
>|||Hi Ben,
A little progress, at least, in EM, the catalog is in recovering status.
What I did was:
1) Goto edit SQL Server registration info
2) My account in SQL Server is 'alan', this is just the login for SQL
Server, so I changed to Windows Authentication
3) Then goto Control Panel - Services - Microsoft Search
4) Double click
5) LogOn tab
6) I change to use my Windows machine login, ie 'Alan Tse'.
This 'Alan Tse' is the login that I use to login to my pc everyday when
I start up my pc.
7) Click OK
8) Then I checked the Control Panel - Services - Microsoft Search, the user
is .\Alan Tse
Are SQL Server and Microsoft Search using the same login, .\Alan Tse?
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OA0$IAHhGHA.4864@.TK2MSFTNGP03.phx.gbl...
> Hi Ben,
> I go to EM, right click my server instance, select the "Edit Registered
SQL
> Server Properties" knowing that I checked the
> "Use SQL Server authentication".
> Am I going to use that account in the Control Panel - Services ?
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> permissions
applet.[vbcol=seagreen]
> The
this[vbcol=seagreen]
with[vbcol=seagreen]
> search
> account to
Properties[vbcol=seagreen]
> and
runs[vbcol=seagreen]
> ?
>|||Hi Ben,
What account should I use on the Security Tab? Use Windows login or SQL
Server login ?
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:FCFB7F64-56BD-4C94-A87B-AC0894AA585B@.microsoft.com...[vbcol=seagreen]
> Right-click the server and select 'Properties', follow the instructions I
> already sent.
> Do not select 'Edit SQL Server Registration Properties'.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
>
SQL[vbcol=seagreen]
applet.[vbcol=seagreen]
this[vbcol=seagreen]
with[vbcol=seagreen]
the[vbcol=seagreen]
Properties[vbcol=seagreen]
runs[vbcol=seagreen]