Link to home
Start Free TrialLog in
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
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

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
Avatar of CHI-LTD

ASKER

Not the startup mode.  I meant changing the account from domain admin to a SA acc
>> 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..
Just specify it, when you asked to log in.
Avatar of CHI-LTD

ASKER

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.
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.
>> 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?
Avatar of CHI-LTD

ASKER

Standard domain user.  No permissions in AD.  Sysadmin added in SQL
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.
Avatar of CHI-LTD

ASKER

Thanks, seems to only cover sql 2014, not 2005...
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
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial