Re: Error 0x80070534 when changing service account

Hi Alex,
Managing this on a domain controller can be a pain. The
permissions don't always get set correctly due to security
issues - it's a different risk when you install SQL Server
on a domain controller.
You'll need to start by walking through all the permissions
for the service account. The following link is probably the
best resource on this:
http://support.microsoft.com/?id=283811

-Sue

On Mon, 26 Feb 2007 08:11:08 -0800, Alex Luna
<AlexLuna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Sue

If I use the prefix, I got error 0x80070534, if I don't use the prefix I got
the error 0x80070056, incorrect network password, but I'm sure the password
is correct. Something similar happens when I use RUN AS command (or screen)
on the DC, if I type the user with domain prefix, it starts the app as that
user (the same I want SQL services start with), but if I don't use the prefix
at RUN AS window or command, the password error appears. Maybe, I have a
misconfiguration at domain level...???

Thank you for your help
-Alex

"Sue Hoegemeier" wrote:

Which same error? One error you are getting due to running
SQL Server on a domain controller is using the domain
prefix. When you removed the prefix, the error was:
"The specified network password is not correct."
Which means the password you used for the account was
incorrect.

-Sue

On Thu, 22 Feb 2007 13:02:47 -0800, Alex Luna
<AlexLuna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Thank you Sue, but still got the same error at Configuration Manager.

The account has granted Logon as Service right in the domain and in Domain
Controllers. I had set the same permissions for that account in both SQL
Server. The only difference I see is that the SQL Server where the account is
able to start the service is not a domain controller, and the other SQL
Server it is.

-Alex

"Sue Hoegemeier" wrote:

When you create a new account, make sure to set the correct
settings for the service account. Then add the account to
the sysadmins server role in SQL Server. Then change the
service account using the Configuration Manager.

-Sue


.

Relevant Pages

  • Re: Help with Software/Hardware decision....
    ... SQL server on DC question has two aspects such as performance and security. ... the computer running SQL Server as a domain controller will work (and it ... MSSQLServer service must run within the security context of an NT account. ... This configuration lets users assign permissions and rights to a service by ...
    (microsoft.public.windows.server.networking)
  • Re: Local Admin account and SA account
    ... would I be able to log into the SQL Server? ... >But the previlages will be based on the account. ... >> So if I log into a SQL Server machine under the standard Windows Admin ... >> there is no domain controller (the computers are in the same ...
    (microsoft.public.sqlserver.server)
  • Re: Error 0x80070534 when changing service account
    ... When you removed the prefix, ... The account has granted Logon as Service right in the domain and in Domain ... The only difference I see is that the SQL Server where the account is ... service account using the Configuration Manager. ...
    (microsoft.public.sqlserver.security)
  • Startup account in Domain Controller
    ... I need to change SQL Server & SQL Server agent's service ... startup account to use SQL Mail feature. ... The SQL Server machine is also used as domain controller. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 7 Server does not seam to respect NTFS permissions.....
    ... The permissions of the OS are the responsibility of the account that sql ... server is running under and not the user within sql server. ... > What are the default NTFS permissions for the Data directory and files? ... > started using SQL 7 Server with the .NET SDK on my domain controller. ...
    (microsoft.public.sqlserver.security)