Re: guideline for service account user

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" <Hoosbruin@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

  • Controls for client machines
    ... I am trying to assess the risks that this causes to local data files and network security in general. ... For NT workstations it would be possible to use a NTFSDOS boot disk to ... allows the password of any local account to be set. ... domain account while disconnected from the network. ...
    (microsoft.public.security)
  • Re: domain cache credential corrupted
    ... using a domain account on a workstation or member server, ... administrator account. ... Then you login try to login using the domain ... since you did not mention plugging the network back in, ...
    (microsoft.public.security)
  • Re: Forcing users to log into Domain account when in workplace
    ... All laptops have two general accounts created, ... The local account is for the users to work on when at ... while the domain account is for them to use when in the office. ... You will not get any security by doing what you plan and you will open your corporate network to viruses and other malware. ...
    (microsoft.public.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)