Solved

Changing SQL Server Service Accounts?

Posted on 2011-02-23
3
182 Views
Last Modified: 2012-06-21
Greetings,

I have a question in regards to changing the SQL Server services account and SQL Server Agent service account. I have a change request that involves changing the SQL Server Service account and SQL Server Agent Service accounts to a new created domain account to replace the existing domain account. We have a very active environment which involves jobs that use SQL Server Agent service so my question is if I change the SQL Server Services account and SQL Server Agent Service account without restarting and wait until after  business hours to restart the services will that cause an issue with any jobs until I restart the services?
0
Comment
Question by:Omega002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 7

Accepted Solution

by:
kemi67 earned 250 total points
ID: 34962676
If the services keep running, you will not get any issue. Pay attention that the Agent will not being restarted by some application
0
 

Author Comment

by:Omega002
ID: 34963022
So current jobs will use the existing domain account to authenicate until I restart the service correct?
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 34963324
>>So current jobs will use the existing domain account to authenicate until I restart the service correct? <<
That is correct.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question