SQL Service accounts

Hi
Any links/tips people can share with me for changing the sql services on sql 2005 standard from admin to service?
Thanks
LVL 1
CHI-LTDAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Simple, just right click the service from either SQL Server Configuration manager or services.msc and then change the Startup account..
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/scm-services-change-the-service-startup-account?view=sql-server-2017
0
CHI-LTDAuthor Commented:
Not the startup mode.  I meant changing the account from domain admin to a SA acc
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> I meant changing the account from domain admin to a SA acc

Can you explain more on what you referred as SA account.
As per your current explanation, I understand that the startup account is currently a Domain account and let us know which account you want that to be changed..
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

ste5anSenior DeveloperCommented:
Just specify it, when you asked to log in.
0
CHI-LTDAuthor Commented:
For the windows services.  I've tried a new account but it fails to start.   Only the domain admin account seems to work with the windows sql services.
0
arnoldCommented:
The service account you create in ad, must be granted run as service right, make sure you add this account to the folder sevurity permissions where the database files are. You may also have to grant lock pages in memory. This is usually done through GPO, computer configuration, security setting.......
The service account would also need to be added into the sevurity section of the database server, or a member of the local server SQL related group.

Please clarify what you are really after, if you are dealing with SQL jobs, created by a Windows login user, and need to switch it to sa, properties of job, then look at who owns/created it, there you can change ownership from a Windows logon, to sa.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> I've tried a new account but it fails to start

What kind of account is this and what are all the permissions you have granted to this account?
0
CHI-LTDAuthor Commented:
Standard domain user.  No permissions in AD.  Sysadmin added in SQL
0
arnoldCommented:
you have to grant a service account rights to run as a service.
without this right, when you try to start the service it will error out ....
the run as a service right needs to be available on the local system where the service runs.  This potentially is covered in the link provided earlier.
0
CHI-LTDAuthor Commented:
Thanks, seems to only cover sql 2014, not 2005...
0
ste5anSenior DeveloperCommented:
Just a comment:
SQL Server 2005 is out of support since more than two years.

Did you tell this your management? This is a sever security issue. Upgrade to SQL Server 2016+.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Comment mentioned by Arnold should help, if not, then check the steps mentioned in the below link..

https://blogs.msdn.microsoft.com/sqlblog/2006/09/17/how-to-change-the-startup-accounts-for-sql-server-services/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.