Re: Service account in cluster sql 2008

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi
In most cases people define a domain account with an appropriate permissions
( to backup to ohter computer and etc..) I have only seen people have added
this domain account into a Administrators group on the computer which runs
SQL Server.

"Amirullail" <Amirullail@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2A4D0D35-EF67-44CC-827D-A8DD4E7FF834@xxxxxxxxxxxxxxxx
Hi

Can somebody show me (step by step) on how to create account to assign to
every service in sql 2008 clustering...

I find many notes but there are in sql 2005. In Wizard at "Server
Configuration" part, i'm really dont have any idea how to assign
appropriate
account for every service in there.

There are 3 service which are :

SQL Server Agent
SQL Server Database Engine
SQL Server Integration Service 10.0




.

Relevant Pages

  • Re: Database Backup
    ... domain account here and it should have the permissions to ... write to the folder, it always did before. ... running a repair on the SQL server OS. ... > I am trying to backup the database, ...
    (microsoft.public.sqlserver.security)
  • Re: Linked Server Connection Problem
    ... Use SQL authentication to connect to the SQL server from the client, ... set the domain account used to start SQL Server to have permissions in the ... Establish a SPN for your domain account which will enable Kerberos ... Load the Active Directory Users and Computers MMC snap-in. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Services account question...
    ... I wish you'd say the reason of not using a domain account as a service account for the SQL Server. ... Backup operations are performed by SQL Server service, at this point I don't know what goes on under hood exactly but SQL Server service may be needed to communicate to the AD for validation of the database owner and as the SQL Server service is a local one, it can't achieve this task. ... > Source: Security Event ID: 537 ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for user NT AUTHORITYANONYMOUS LOGON
    ... >>I've enabled anonymous access, setting it to the correct domain account, ... >> the correct permissions in sql server ... > That means the local user permissions, the SQL Server, etc. ... >> c) I've enabled anonymous access, setting it to the correct domain account, ...
    (microsoft.public.dotnet.framework.aspnet)
  • 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)