Avatar of CHI-LTD
CHI-LTDFlag for United Kingdom of Great Britain and Northern Ireland asked on

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
DatabasesSQL

Avatar of undefined
Last Comment
Raja Jegan R

8/22/2022 - Mon
Raja Jegan R

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
ASKER
CHI-LTD

Not the startup mode.  I meant changing the account from domain admin to a SA acc
Raja Jegan R

>> 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..
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ste5an

Just specify it, when you asked to log in.
ASKER
CHI-LTD

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.
arnold

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Raja Jegan R

>> 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?
ASKER
CHI-LTD

Standard domain user.  No permissions in AD.  Sysadmin added in SQL
arnold

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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
CHI-LTD

Thanks, seems to only cover sql 2014, not 2005...
ste5an

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+.
ASKER CERTIFIED SOLUTION
Raja Jegan R

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question