I was using XX account to run SQL service, integration service and SQL agent. This XX account was assigned to run these services during the SQL server installation. It was also given ssyadmin rights on the SQl server. Recently due to some security concerns
I had to change xx account to a new yy account. Both are AD accounts. Now I did not include this YY account anywhere on the sql server but it can still run the SQl service, integration service and Agent. I always that the account used to run these service
should be included in the SQL server logins with some kind of permissions. Is it not.
By the way I am using SQL 2008
View Complete Post