changing sql server account using sem ...  
Author Message
RCampos





PostPosted: Sun Jan 23 02:05:02 CST 2005 Top

SQL Server >> changing sql server account using sem ...

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 ...

SQL Server221  
 
 
markbaekdal





PostPosted: Sun Jan 23 02:05:02 CST 2005 Top

SQL Server >> changing sql server account using sem ... 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






> 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 ...
 
 
Anthony





PostPosted: Sun Jan 23 22:18:20 CST 2005 Top

SQL Server >> changing sql server account using sem ... 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


--



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






> 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 ...


 
 
markbaekdal





PostPosted: Mon Jan 24 02:03:02 CST 2005 Top

SQL Server >> changing sql server account using sem ... Thanks Anthony.



regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server






> 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
>
>
> --
>


> 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
>
>
>
>

>
> > 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 ...
>
>
>