When you setup a service account for sql server services, do you use a domain account or MSA account or virtual account. Most of our SQl servers has SSIS, so it needs to access other resources on other SQL servers.
In this case what is the best option for the service, a domain account, msa or virtual account.
Currently we are using SQL 2008, we use domain account for the SQL server serivce.
I am a little confused a bout MSA account, it says :
When resources external to the SQL Server computer are needed, Microsoft recommends using a Managed Service Account (MSA), configured with the minimum privileges necessary.
it also says:
You cannot use a MSA to log into a computer, but a computer can use a MSA to start a Windows service.
So if it cannot login to a computer, how the SSIS to connect to another server using SQL agent service using a msa account?