SQL Server Performance

Need to change the account on which the SQL server

Discussion in 'SQL Server 2005 General DBA Questions' started by satya.sqldba, Mar 1, 2007.

  1. satya.sqldba New Member

    Hello DBA's

    I have a situation where I need to change the account on which the SQL server agent is running on production. Can you tell me what are the steps that can be best practise to do so and care to be taken at any particular step

    Thanks
    Satya
  2. madhuottapalam New Member

    SQL Configuration manager is the tool to Administer different Services in SQL Server.


    Madhu
  3. thomas New Member

    Also ensure the new service account has all the rights it needs.
  4. satya.sqldba New Member

    Ok Got it

    But how do I create a new user account ? and next make sure it has all previlages.

    Thanks
    Satya
  5. thomas New Member

    You got Active Directory? If you have, you need to go into the mmc snap-in, AD Users and Computers, and create it in there. Ensure it has the same rights (group membership) of the existing account.

    If you server is stand-alone, not on an AD domain, you'll need to create a local account. This can be done in Computer Management.. Local Users and Groups.
  6. satya.sqldba New Member

    Thomas

    Thank you. But I am not familiar with configuring the AD domain. CAn you help me out with that?

    Thanks
    Satya
  7. thomas New Member

    not really, because your AD will be set up differently to mine. Have you got a network admin who can help you?
  8. satya.sqldba New Member

    This is in production. So can anyone advise me steps to follow?

    Do I have to schedule some pre - planned downtime and something like that?

    Do I have to stop the agent and then change the account?

    Thanks
    Satya
  9. thomas New Member

    Yes it needs to be restarted. This usually isn't an issue with SQL Server agent, even in production, as users aren't affected by it restarting. You just have to ensure no jobs are running at the time of the restart.
  10. satya.sqldba New Member

    Ok Thomas

    Thanks, that helped a lot, just to double check before I do this, we really don't need to bring down the whole server to do this process according to you, and you say we have to restart the SQL server agent and we are done with it.

    I am asking this because there are a whole lot of services (Reporting Services, Analysis Services, Int Services)that are right now running under a different account and all need to be changed. Does restarting the SQL server agent set all these services allright or do we have to change all the services that are using the old account?

    Thanks
    Satya
  11. thomas New Member

    You have to change each account separately.
  12. satya.sqldba New Member

    Thanks Thomas

    I got the answer for my second question but not for the first one.I am pasting it once again below:

    just to double check before I do this, we really don't need to bring down the whole server to do this process according to you, and you say we have to restart the SQL server agent and we are done with it.


    Thanks
    Satya


  13. satya.sqldba New Member

    I have one more clarification:

    Currently the whole security is configured in Windows authentication right now. And our whole system uses both web and windows applications. Is it a good practise to change everything to SQL Server authentication or not?

    Thanks
    Satya
  14. MohammedU New Member

  15. satya Moderator

    IMHO, no as Window authentication is better in terms of trustworthy security.

    quote:Originally posted by satya.sqldba

    I have one more clarification:

    Currently the whole security is configured in Windows authentication right now. And our whole system uses both web and windows applications. Is it a good practise to change everything to SQL Server authentication or not?

    Thanks
    Satya

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page