Re: changing sql server account using sem ...

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Anthony Thomas (ALThomas_at_kc.rr.com)
Date: 01/24/05 

Date: Sun, 23 Jan 2005 22:18:20 -0600

Yes, but the recommended approach is to do it through EM. This way all of
the necessary permissions and user rights assingments will be given
appropriately. However, using the services msc is an alternative as long as
you follow the KB article that describes manually setting all of the other
requirements.

http://support.microsoft.com/default.aspx?scid=kb;en-us;283811

Sincerely,

Anthony Thomas 

-- 
"mark baekdal" <markbaekdal@discussions.microsoft.com> wrote in message
news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@microsoft.com...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:
> when trying to change the sql server and sql server agent accounts using
the
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username,
etc... )
> ?  when attempting to add an existing domain account an error message
keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system
account
> instead of a domain account ) even though sql server is installed on the
pdc.
>  tia ...

Relevant Pages

  • Re: Problems changing the password for the service account in SQL
    ... Adding the domain account which runs SQL Server into SQL Server doesn't ... Server if it is running under the domain account. ... Admin-SQL, Logon Exec - exception from ...
    (microsoft.public.sqlserver.security)
  • Re: Problems changing the password for the service account in SQL
    ... It is because there is BULTIN\Administrstors Login that alllow access to ... You have a domaim account group that SQL Server ... this domain account in SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Get "credentials not valid" message installing SQL2008 Failver
    ... The user account (domain account) has to be pre-created. ... The network name gets created during the install process. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • SQL services failing on startup
    ... The services are set to autostart using a windows account. ... The account is restricted to logon only to computers ... for several months, the last two weekends, SQL Server has failed to startup ... The domain account was a member of the local admin group. ...
    (microsoft.public.sqlserver.server)
  • Re: Connections errors
    ... Jasper Smith (SQL Server MVP) ... accounts and not the NT domain account. ... >> been observing connection errors that we can trace back ...
    (microsoft.public.sqlserver.security)