Hi,
I need to change the "startup service account" for one of my instances.
I go to:
EM, right-click on server name > properties > security tab
But the section "startup service account" is all grayed out and I can't select the radio button, or add the name of the new domain acct.
My understanding that it's a bad idea to change the service account from windows "services"... that you should only use EM to change service accounts, see below:
“If you want to change the service account used by the SQL Server and SQL Server Agent services, you must use the SQL Server Enterprise Manager to ensure proper functioning of these SQL Server services and SQL Server 2000… this ensures that the proper permissions are set in the NTFS file system and in the Windows registry for this new service account… also ensures this service account is granted the following user privileges: log on as a service, lock pages in memory, and enable trusted delegation… is required for the proper use and administration of the Microsoft search service.”
So, if I can't change it in EM, what am I supposed to do?
Thanks
I need to change the "startup service account" for one of my instances.
I go to:
EM, right-click on server name > properties > security tab
But the section "startup service account" is all grayed out and I can't select the radio button, or add the name of the new domain acct.
My understanding that it's a bad idea to change the service account from windows "services"... that you should only use EM to change service accounts, see below:
“If you want to change the service account used by the SQL Server and SQL Server Agent services, you must use the SQL Server Enterprise Manager to ensure proper functioning of these SQL Server services and SQL Server 2000… this ensures that the proper permissions are set in the NTFS file system and in the Windows registry for this new service account… also ensures this service account is granted the following user privileges: log on as a service, lock pages in memory, and enable trusted delegation… is required for the proper use and administration of the Microsoft search service.”
So, if I can't change it in EM, what am I supposed to do?
Thanks