CHI-LTD
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
Any links/tips people can share with me for changing the sql services on sql 2005 standard from admin to service?
Thanks
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..
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.
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.
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?
What kind of account is this and what are all the permissions you have granted to this account?
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.
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.
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+.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/scm-services-change-the-service-startup-account?view=sql-server-2017