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 active
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 active
> 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:
> > 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 active
> > directory or on the database server? How?
> >
> > Thanks much in advance for any help.
> >
> > Bing
> Are you a local administrator on Server B?
> John
How should I tell?
Bing|||"bing" wrote:
>
> "John Bell" wrote:
> > Hi
> >
> > "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 active
> > > directory or on the database server? How?
> > >
> > > Thanks much in advance for any help.
> > >
> > > Bing
> >
> > Are you a local administrator on Server B?
> >
> > John
> How should I tell?
> Bing
Never mind. I figured it out.|||"bing" wrote:
>
> "bing" wrote:
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > "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 active
> > > > directory or on the database server? How?
> > > >
> > > > Thanks much in advance for any help.
> > > >
> > > > Bing
> > >
> > > Are you a local administrator on Server B?
> > >
> > > John
> >
> > How should I tell?
> >
> > Bing
> 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:
> >
> >
> > "bing" wrote:
> >
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > "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 active
> > > > > directory or on the database server? How?
> > > > >
> > > > > Thanks much in advance for any help.
> > > > >
> > > > > Bing
> > > >
> > > > Are you a local administrator on Server B?
> > > >
> > > > John
> > >
> > > How should I tell?
> > >
> > > Bing
> >
> > 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
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:
> >
> >
> > "bing" wrote:
> >
> > >
> > >
> > > "bing" wrote:
> > >
> > > >
> > > >
> > > > "John Bell" wrote:
> > > >
> > > > > Hi
> > > > >
> > > > > "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 active
> > > > > > directory or on the database server? How?
> > > > > >
> > > > > > Thanks much in advance for any help.
> > > > > >
> > > > > > Bing
> > > > >
> > > > > Are you a local administrator on Server B?
> > > > >
> > > > > John
> > > >
> > > > How should I tell?
> > > >
> > > > Bing
> > >
> > > 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
> 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 so
far, changing service account in EM should be the right way to go.
Bing|||Hi
"bing" wrote:
>
> "John Bell" wrote:
> > Hi
> >
> > "bing" wrote:
> >
> > >
> > >
> > > "bing" wrote:
> > >
> > > >
> > > >
> > > > "bing" wrote:
> > > >
> > > > >
> > > > >
> > > > > "John Bell" wrote:
> > > > >
> > > > > > Hi
> > > > > >
> > > > > > "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 active
> > > > > > > directory or on the database server? How?
> > > > > > >
> > > > > > > Thanks much in advance for any help.
> > > > > > >
> > > > > > > Bing
> > > > > >
> > > > > > Are you a local administrator on Server B?
> > > > > >
> > > > > > John
> > > > >
> > > > > How should I tell?
> > > > >
> > > > > Bing
> > > >
> > > > 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
> >
> > 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 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:
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > "bing" wrote:
> > >
> > > >
> > > >
> > > > "bing" wrote:
> > > >
> > > > >
> > > > >
> > > > > "bing" wrote:
> > > > >
> > > > > >
> > > > > >
> > > > > > "John Bell" wrote:
> > > > > >
> > > > > > > Hi
> > > > > > >
> > > > > > > "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 active
> > > > > > > > directory or on the database server? How?
> > > > > > > >
> > > > > > > > Thanks much in advance for any help.
> > > > > > > >
> > > > > > > > Bing
> > > > > > >
> > > > > > > Are you a local administrator on Server B?
> > > > > > >
> > > > > > > John
> > > > > >
> > > > > > How should I tell?
> > > > > >
> > > > > > Bing
> > > > >
> > > > > 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
> > >
> > > 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 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
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|||Hi
> > 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
It looks like Server a was renamed from TECUMSEH to PC200, but that is the
one that works? If you type SET COMPUTERNAME at a command prompt does it come
up with the same name as SELECT @.@.SERVERNAME?
If the server was renamed you would need to change the SQL Server's name
using the instructions in http://support.microsoft.com/default.aspx/kb/303774
John|||"John Bell" wrote:
> Hi
> >
> > > 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
> It looks like Server a was renamed from TECUMSEH to PC200, but that is the
> one that works? If you type SET COMPUTERNAME at a command prompt does it come
> up with the same name as SELECT @.@.SERVERNAME?
> If the server was renamed you would need to change the SQL Server's name
> using the instructions in http://support.microsoft.com/default.aspx/kb/303774
> John
Yeah, A works. B doesn't.
On A:
'set computername' returns pc200.
'SELECT @.@.SERVERNAME' returns TECUMSEH.
'select @.@.version" returns
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 1)
On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
'select @.@.version' returns
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
Bing|||Hi
> Yeah, A works. B doesn't.
> On A:
> 'set computername' returns pc200.
> 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> 'select @.@.version" returns
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 1)
> On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> 'select @.@.version' returns
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
> Bing
>
So that does not get you any further with the original issue! Have you tried
changing the service account in services to localsystem for server B and then
see if you can change it to a domain account in EM?
John|||"John Bell" wrote:
> Hi
> > Yeah, A works. B doesn't.
> >
> > On A:
> > 'set computername' returns pc200.
> > 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> > 'select @.@.version" returns
> > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> > 5.2 (Build 3790: Service Pack 1)
> >
> > On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> > 'select @.@.version' returns
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> > NT 5.2 (Build 3790: Service Pack 1)
> >
> > Bing
> >
> So that does not get you any further with the original issue! Have you tried
> changing the service account in services to localsystem for server B and then
> see if you can change it to a domain account in EM?
> John
I just tried, but it didn't make any difference.
Actually, that put the issue back to its original state. In the very
beginning, I noticed my personal domain account (in the local administrators
group) could not change the service account in EM on B. But I was able to
change the service account to a domain account in services in control panel.
This domain account is also in the local administrators group. I tried to
log on B using both my personal domain account and the desired service
account I wanted to change to, but neither works. In services, the 'Log on
As' is local system for both MSSQLSERVER and SQLSERVERAGENT now.
Bing|||Hi
"bing" wrote:
>
> "John Bell" wrote:
> > Hi
> >
> > > Yeah, A works. B doesn't.
> > >
> > > On A:
> > > 'set computername' returns pc200.
> > > 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> > > 'select @.@.version" returns
> > > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> > > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> > > 5.2 (Build 3790: Service Pack 1)
> > >
> > > On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> > > 'select @.@.version' returns
> > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > > Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> > > NT 5.2 (Build 3790: Service Pack 1)
> > >
> > > Bing
> > >
> > So that does not get you any further with the original issue! Have you tried
> > changing the service account in services to localsystem for server B and then
> > see if you can change it to a domain account in EM?
> >
> > John
> I just tried, but it didn't make any difference.
> Actually, that put the issue back to its original state. In the very
> beginning, I noticed my personal domain account (in the local administrators
> group) could not change the service account in EM on B. But I was able to
> change the service account to a domain account in services in control panel.
> This domain account is also in the local administrators group. I tried to
> log on B using both my personal domain account and the desired service
> account I wanted to change to, but neither works. In services, the 'Log on
> As' is local system for both MSSQLSERVER and SQLSERVERAGENT now.
> Bing
If you are able to log on as the local administrator or domain administrator
do these work?
John|||"John Bell" wrote:
> Hi
> "bing" wrote:
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > > Yeah, A works. B doesn't.
> > > >
> > > > On A:
> > > > 'set computername' returns pc200.
> > > > 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> > > > 'select @.@.version" returns
> > > > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> > > > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> > > > 5.2 (Build 3790: Service Pack 1)
> > > >
> > > > On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> > > > 'select @.@.version' returns
> > > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > > > Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> > > > NT 5.2 (Build 3790: Service Pack 1)
> > > >
> > > > Bing
> > > >
> > > So that does not get you any further with the original issue! Have you tried
> > > changing the service account in services to localsystem for server B and then
> > > see if you can change it to a domain account in EM?
> > >
> > > John
> >
> > I just tried, but it didn't make any difference.
> > Actually, that put the issue back to its original state. In the very
> > beginning, I noticed my personal domain account (in the local administrators
> > group) could not change the service account in EM on B. But I was able to
> > change the service account to a domain account in services in control panel.
> > This domain account is also in the local administrators group. I tried to
> > log on B using both my personal domain account and the desired service
> > account I wanted to change to, but neither works. In services, the 'Log on
> > As' is local system for both MSSQLSERVER and SQLSERVERAGENT now.
> >
> > Bing
> If you are able to log on as the local administrator or domain administrator
> do these work?
> John
OK, I tried to log on 'Administrator' on B, Startup service account in EM
still grays out. What the heck!
Bing|||Hi
"bing" wrote:
>
> "John Bell" wrote:
> > Hi
> >
> > "bing" wrote:
> >
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > > Yeah, A works. B doesn't.
> > > > >
> > > > > On A:
> > > > > 'set computername' returns pc200.
> > > > > 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> > > > > 'select @.@.version" returns
> > > > > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> > > > > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> > > > > 5.2 (Build 3790: Service Pack 1)
> > > > >
> > > > > On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> > > > > 'select @.@.version' returns
> > > > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > > > > Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> > > > > NT 5.2 (Build 3790: Service Pack 1)
> > > > >
> > > > > Bing
> > > > >
> > > > So that does not get you any further with the original issue! Have you tried
> > > > changing the service account in services to localsystem for server B and then
> > > > see if you can change it to a domain account in EM?
> > > >
> > > > John
> > >
> > > I just tried, but it didn't make any difference.
> > > Actually, that put the issue back to its original state. In the very
> > > beginning, I noticed my personal domain account (in the local administrators
> > > group) could not change the service account in EM on B. But I was able to
> > > change the service account to a domain account in services in control panel.
> > > This domain account is also in the local administrators group. I tried to
> > > log on B using both my personal domain account and the desired service
> > > account I wanted to change to, but neither works. In services, the 'Log on
> > > As' is local system for both MSSQLSERVER and SQLSERVERAGENT now.
> > >
> > > Bing
> >
> > If you are able to log on as the local administrator or domain administrator
> > do these work?
> >
> > John
> OK, I tried to log on 'Administrator' on B, Startup service account in EM
> still grays out. What the heck!
> Bing
If the administrator is not allowed then there is something seriously wrong!
It isn't something daft like you are not checking the This Account radio
button.
John|||Hi
"bing" wrote:
>
> "John Bell" wrote:
> > Hi
> >
> > "bing" wrote:
> >
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > > Yeah, A works. B doesn't.
> > > > >
> > > > > On A:
> > > > > 'set computername' returns pc200.
> > > > > 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> > > > > 'select @.@.version" returns
> > > > > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> > > > > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> > > > > 5.2 (Build 3790: Service Pack 1)
> > > > >
> > > > > On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> > > > > 'select @.@.version' returns
> > > > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > > > > Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> > > > > NT 5.2 (Build 3790: Service Pack 1)
> > > > >
> > > > > Bing
> > > > >
> > > > So that does not get you any further with the original issue! Have you tried
> > > > changing the service account in services to localsystem for server B and then
> > > > see if you can change it to a domain account in EM?
> > > >
> > > > John
> > >
> > > I just tried, but it didn't make any difference.
> > > Actually, that put the issue back to its original state. In the very
> > > beginning, I noticed my personal domain account (in the local administrators
> > > group) could not change the service account in EM on B. But I was able to
> > > change the service account to a domain account in services in control panel.
> > > This domain account is also in the local administrators group. I tried to
> > > log on B using both my personal domain account and the desired service
> > > account I wanted to change to, but neither works. In services, the 'Log on
> > > As' is local system for both MSSQLSERVER and SQLSERVERAGENT now.
> > >
> > > Bing
> >
> > If you are able to log on as the local administrator or domain administrator
> > do these work?
> >
> > John
> OK, I tried to log on 'Administrator' on B, Startup service account in EM
> still grays out. What the heck!
> Bing
If the administrator is not allowed then there is something seriously wrong!
It isn't something daft like you are not checking the This Account radio
button?
John