Re: guideline for service account user

You'll need to change it manually and restart your services when you change service account details. This applies to all services.

--
Ekrem Önsoy



<bntgoogle@xxxxxxxxx> wrote in message news:1194642599.170349.119710@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Under the MSSQLSERVER and Agent services properties, there is a 'Log
On' which shows that service's user and a password field. If a Domain
Account is used, does the password on this tab need to be changed
separately, or does changing the Domain password automatically flow to
this service tab?

Thanks,

B


On Nov 9, 2:22 am, Ekrem Önsoy <ek...@xxxxxxxxxxxx> wrote:
1) If your SQL Server will run under a domain and need access to network
then you should use a Domain Account as a service account. Local account
would not work in the scenario.

2) Don't know about this.

--
Ekrem Önsoy

"AHartman" <Hoosbr...@xxxxxxxxxxxx> wrote in message

news:6MudnSZbP__RMa7anZ2dnUVZ_oCvnZ2d@xxxxxxxxxxxxxxx

> 1) Looking for some good info on what user should be used for the
> sqlservice account as well as agent.

> Local vs Domain Account

> This user will need to be to access Network shares for DTS file loading.

> 2) We use Samba shares from our Unix system where we dump extract files > to
> be picked up by a Sql load process. Is there any reason why we can't run
> more than one Load process at a time. If we try and run 2 together we > get
> a collision on making the Samba connection. The second process gets a
> failed login attempt seeing how the first one is active and has dropped
> it's connection. These processes are launched from the same BOX.

> Thanks


.

Relevant Pages

  • Re: guideline for service account user
    ... Ekrem Önsoy ... Account is used, does the password on this tab need to be changed ... >> 2) We use Samba shares from our Unix system where we dump extract ... >> more than one Load process at a time. ...
    (microsoft.public.sqlserver.security)
  • Re: "Edit Users..." Menu Item Disabled in Telephony Management Sna
    ... On the member server, make sure the domain account you are using to log on ... Running "tapicfg show" revealed that I had no Active Directory TAPI ...
    (microsoft.public.win32.programmer.tapi)
  • Re: Domain could not be contacted problem
    ... > can either make the process run under a domain account, ... > To impersonate a domain account, you generally do this by enabling ... > impersonating the authenticated user in IIS. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: Domain could not be contacted problem
    ... > can either make the process run under a domain account, ... > To impersonate a domain account, you generally do this by enabling ... > impersonating the authenticated user in IIS. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Kerberos Problem with App Pool running as Domain Account
    ... account, perhaps IIS itself has to as well (instead of the IUSR_IISSERVER ... An error occurred during logon ... Caller User Name: IISSERVER$ ... had to change this to use a domain account because our DR server needed ...
    (microsoft.public.inetserver.iis.security)