How to enable a domain account to change service account?

Hi,
We're running two SQL server 2000, SP3 A and B. On A, the service account
for both the SQL server and agent is a domain account. On B, the service
account is local system account. On A in enterprise manager, my personal
domain account can change the service account to whatever I want. But on B,
in security of enterprise manager, the 'Startup service account' grays out
for my domain account. How should I allow my domain account to modify
startup service account? Is it something that needs to be done in the activ
e
directory or on the database server? How?
Thanks much in advance for any help.
BingHi
"bing" wrote:

> Hi,
> We're running two SQL server 2000, SP3 A and B. On A, the service account
> for both the SQL server and agent is a domain account. On B, the service
> account is local system account. On A in enterprise manager, my personal
> domain account can change the service account to whatever I want. But on
B,
> in security of enterprise manager, the 'Startup service account' grays out
> for my domain account. How should I allow my domain account to modify
> startup service account? Is it something that needs to be done in the act
ive
> directory or on the database server? How?
> Thanks much in advance for any help.
> Bing
Are you a local administrator on Server B?
John|||"John Bell" wrote:

> Hi
> "bing" wrote:
>
> Are you a local administrator on Server B?
> John
How should I tell?
Bing|||"bing" wrote:

>
> "John Bell" wrote:
>
> How should I tell?
> Bing
Never mind. I figured it out.|||"bing" wrote:

>
> "bing" wrote:
>
> Never mind. I figured it out.
Well, I figured out how to figure out if my personal domain account is in
the local Administrators group on the database server. Yes, it is. But my
original question still remains. Now that, my domain account is a local
administrator on both the SQL server 2000 A and B, why I can change the
service account on A but not on B (service account section in EM->Security
grays out). What else should I check?
Thanks,
Bing|||Hi
"bing" wrote:

>
> "bing" wrote:
>
> Well, I figured out how to figure out if my personal domain account is in
> the local Administrators group on the database server. Yes, it is. But m
y
> original question still remains. Now that, my domain account is a local
> administrator on both the SQL server 2000 A and B, why I can change the
> service account on A but not on B (service account section in EM->Security
> grays out). What else should I check?
> Thanks,
> Bing
As a local administrator you should have enough permissions. Were you
connected to the server itself?
John|||
> As a local administrator you should have enough permissions. Were you
> connected to the server itself?
> John
I mean logged on locally to the server in question!
John|||"John Bell" wrote:

> Hi
> "bing" wrote:
>
> As a local administrator you should have enough permissions. Were you
> connected to the server itself?
> John
Thanks much for taking time helping.
Yes, I logged on both A and B using my domain account via remote desktop
connection. I can change the service account in control panel->services.
But seems like that method is discouraged. From the advices I've gathered s
o
far, changing service account in EM should be the right way to go.
Bing|||Hi
"bing" wrote:

>
> "John Bell" wrote:
>
> Thanks much for taking time helping.
> Yes, I logged on both A and B using my domain account via remote desktop
> connection. I can change the service account in control panel->services.
> But seems like that method is discouraged. From the advices I've gathered
so
> far, changing service account in EM should be the right way to go.
> Bing
If the account you are logged into the server with is a local windows
administrator then it should be fine and you should be able to change the
service account. To access the property pages you need to be a SQL Server
sysadmin. I assume that SELECT @.@.SERVERNAME will return the same name the
machine, you don't have any aliases set up and the server is registered as
(LOCAL) ?
John|||"John Bell" wrote:

> Hi
> "bing" wrote:
>
> If the account you are logged into the server with is a local windows
> administrator then it should be fine and you should be able to change the
> service account. To access the property pages you need to be a SQL Server
> sysadmin. I assume that SELECT @.@.SERVERNAME will return the same name the
> machine, you don't have any aliases set up and the server is registered as
> (LOCAL) ?
> John
Hm. Sorry I don't quite understand the question. Here is what SELECT
@.@.SERVERNAME returns on A and B respectively.
A. TECUMSEH
B. HAMMERHEAD
And here are A's and B's host name in DNS:
A. pc200.dept.some.edu
B. hammerhead.dept.some.edu
Any problems with that?
Bing