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...
> 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 ?
> >
> >
> >|||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...
> >
> > 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 ?
> > >
> > >
> > >
>
>|||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...
> 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...
> > >
> > > 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 ?
> > > >
> > > >
> > > >
> >
> >
> >|||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
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...
> >
> > 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...
> > > >
> > > > 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 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
> 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...
> > >
> > > 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...
> > > > >
> > > > > 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
?
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||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 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
> > 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...
> > > >
> > > > 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...
> > > > > >
> > > > > > 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,
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...
> >
> > 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
> > 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...
> > > >
> > > > 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...
> > > > > >
> > > > > > 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,
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...
> 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
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
> > > 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...
> > > > >
> > > > > 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...
> > > > > > >
> > > > > > > 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
> > ?
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Alan,
Read my previous messages carefully. 'Edit SQL Server Registration
Properties' do not change the service account but the account you are using
to connect.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> 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...
> > >
> > > 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
> > > 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...
> > > > >
> > > > > 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...
> > > > > > >
> > > > > > > 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,
My machine name is 'ATSE', windows login is 'Alan Tse'.
What I did again:
1) Goto EM, right click the server instance, select properties
2) On Security tab
3) Check Windows authentication
4) On Startup service account groupbox, select the 'This account", fill in
ATSE\Alan Tse with password.
5) An error comes up saying Logon failure: unkown user name or bad password.
I am not understand why I got this error, I double checked in the EM that I
actully have this login. This is the domain\user. This 'ATSE\Alan Tse' is
the login I use everytime I start up my pc.
I think you gave me guidances very near the solution.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:B8082948-C346-4110-9A36-5340F21D6A38@.microsoft.com...
> Alan,
> Read my previous messages carefully. 'Edit SQL Server Registration
> Properties' do not change the service account but the account you are
using
> to connect.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > 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...
> > > >
> > > > 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
> > > > 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...
> > > > > >
> > > > > > 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...
> > > > > > > >
> > > > > > > > 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
> > > ?
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> >
> >
> >|||If this is a local account just type .\Alan Tse
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> Hi Ben,
> My machine name is 'ATSE', windows login is 'Alan Tse'.
> What I did again:
> 1) Goto EM, right click the server instance, select properties
> 2) On Security tab
> 3) Check Windows authentication
> 4) On Startup service account groupbox, select the 'This account", fill in
> ATSE\Alan Tse with password.
> 5) An error comes up saying Logon failure: unkown user name or bad password.
> I am not understand why I got this error, I double checked in the EM that I
> actully have this login. This is the domain\user. This 'ATSE\Alan Tse' is
> the login I use everytime I start up my pc.
> I think you gave me guidances very near the solution.
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:B8082948-C346-4110-9A36-5340F21D6A38@.microsoft.com...
> >
> > Alan,
> >
> > Read my previous messages carefully. 'Edit SQL Server Registration
> > Properties' do not change the service account but the account you are
> using
> > to connect.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Alan" wrote:
> >
> > > 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...
> > > > >
> > > > > 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
> > > > > 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...
> > > > > > >
> > > > > > > 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...
> > > > > > > > >
> > > > > > > > > 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
> > > > ?
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > >
> > >
> > >
>
>|||Alan,
I need to leave. You should have all the instructions on these messages.
Good luck.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Ben Nevarez" wrote:
> If this is a local account just type .\Alan Tse
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > Hi Ben,
> >
> > My machine name is 'ATSE', windows login is 'Alan Tse'.
> > What I did again:
> > 1) Goto EM, right click the server instance, select properties
> > 2) On Security tab
> > 3) Check Windows authentication
> > 4) On Startup service account groupbox, select the 'This account", fill in
> > ATSE\Alan Tse with password.
> > 5) An error comes up saying Logon failure: unkown user name or bad password.
> >
> > I am not understand why I got this error, I double checked in the EM that I
> > actully have this login. This is the domain\user. This 'ATSE\Alan Tse' is
> > the login I use everytime I start up my pc.
> >
> > I think you gave me guidances very near the solution.
> >
> > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > news:B8082948-C346-4110-9A36-5340F21D6A38@.microsoft.com...
> > >
> > > Alan,
> > >
> > > Read my previous messages carefully. 'Edit SQL Server Registration
> > > Properties' do not change the service account but the account you are
> > using
> > > to connect.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "Alan" wrote:
> > >
> > > > 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...
> > > > > >
> > > > > > 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
> > > > > > 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...
> > > > > > > >
> > > > > > > > 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...
> > > > > > > > > >
> > > > > > > > > > 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,
Now I can use my local account, ATSE\Alan Tse as 'Log On As' in the MSSQL
Server service and SQLAgent service.
Then execute the T-SQL to add to a sysadmin role
exec sp_addsrvrolemember N'ATSE\Alan Tse', sysadmin
and
select * from master.dbo.syslogins where loginname = N'ATSE\Alan Tse'
showing sysadmin is 1.
But the catalog still idle and not populated.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:69236D8A-C417-4D82-8B51-FB9E3FCCDEAA@.microsoft.com...
> Alan,
> I need to leave. You should have all the instructions on these messages.
> Good luck.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Ben Nevarez" wrote:
> >
> > If this is a local account just type .\Alan Tse
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Alan" wrote:
> >
> > > Hi Ben,
> > >
> > > My machine name is 'ATSE', windows login is 'Alan Tse'.
> > > What I did again:
> > > 1) Goto EM, right click the server instance, select properties
> > > 2) On Security tab
> > > 3) Check Windows authentication
> > > 4) On Startup service account groupbox, select the 'This account",
fill in
> > > ATSE\Alan Tse with password.
> > > 5) An error comes up saying Logon failure: unkown user name or bad
password.
> > >
> > > I am not understand why I got this error, I double checked in the EM
that I
> > > actully have this login. This is the domain\user. This 'ATSE\Alan Tse'
is
> > > the login I use everytime I start up my pc.
> > >
> > > I think you gave me guidances very near the solution.
> > >
> > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > news:B8082948-C346-4110-9A36-5340F21D6A38@.microsoft.com...
> > > >
> > > > Alan,
> > > >
> > > > Read my previous messages carefully. 'Edit SQL Server Registration
> > > > Properties' do not change the service account but the account you
are
> > > using
> > > > to connect.
> > > >
> > > > Ben Nevarez, MCDBA, OCP
> > > > Database Administrator
> > > >
> > > >
> > > > "Alan" wrote:
> > > >
> > > > > 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...
> > > > > > >
> > > > > > > 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
> > > > > > > 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...
> > > > > > > > >
> > > > > > > > > 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...
> > > > > > > > > > >
> > > > > > > > > > > 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
> > > > > > ?
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >|||Alan wrote:
> Hi Ben,
> Now I can use my local account, ATSE\Alan Tse as 'Log On As' in the MSSQL
> Server service and SQLAgent service.
> Then execute the T-SQL to add to a sysadmin role
> exec sp_addsrvrolemember N'ATSE\Alan Tse', sysadmin
> and
> select * from master.dbo.syslogins where loginname = N'ATSE\Alan Tse'
> showing sysadmin is 1.
> But the catalog still idle and not populated.
>
Hi Alan
Could this article has something to do with your problem :
http://support.microsoft.com/kb/317746/
It's mentioned in the link I send you in another thread regarding your
account change problems.
--
Regards
Steen Schlüter Persson
DBA|||Hi Steen,
I found the NT Authority\System is already in SQL Server "Security ->
Logins".
I executed the T-SQL from the article and repopulated the Catalog again, the
status is still idle after refresh. The item count is 0.
By the way, where is the event log stored so that I can look at that?
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:OMIPHiUhGHA.4276@.TK2MSFTNGP03.phx.gbl...
> Alan wrote:
> > Hi Ben,
> > Now I can use my local account, ATSE\Alan Tse as 'Log On As' in the
MSSQL
> > Server service and SQLAgent service.
> > Then execute the T-SQL to add to a sysadmin role
> > exec sp_addsrvrolemember N'ATSE\Alan Tse', sysadmin
> > and
> > select * from master.dbo.syslogins where loginname = N'ATSE\Alan Tse'
> > showing sysadmin is 1.
> >
> > But the catalog still idle and not populated.
> >
> Hi Alan
> Could this article has something to do with your problem :
> http://support.microsoft.com/kb/317746/
> It's mentioned in the link I send you in another thread regarding your
> account change problems.
> --
> Regards
> Steen Schlüter Persson
> DBA