No, it's not in local admin group.

I don't see 'problems' (not sure if it's a problem) like this in our SQL 2005 box.

But I checked in two our SQL 2008,...

It's a domain account.

So the installation doesn't add the account automatically to the login list?

Is this a manual step that I have to do after installation?

How come all...

Thanks, I know the service account name, but it is not listed in security login list.

We are using sql server 2008 on windows 2008

Thanks, the easy query works better.

Thanks, this maintence plan job does only differential backup.

It has been running fine for 3 months, not aware of any permission change.

But what I posted is in detail panel. And there is no error in maintenance history for this job.

no errors in sql log too, I tried what you suggest...

Thank you, i got it.

Thanks, I will give it a try.

And I will pay attention to other factors that databases may not be used for some time.

Is there an easier way, for example to see some modified date some where to check?

1. I thought when intalling, it will automatically add this account to the group, SQLServerSQLAgentUser$computername $MSSQLSERVER

2. does it mean we now need to manually add this account to the above...

You said, "If the service account is part of the group that you had mentioned, then it would have sysadmin rights on the instance."

No, I can only see NT...

But we specifically add the account to the login on this server and make it dbowner for the other server to access data on this server. but if it is...

But we use that the same service account on another server, and in the ETL run on that server will use this account to access data on this server.

I just found out we have a group in the login list called NT service\SQLServerAgent. It has sysamin role in it.

Then I become more confused. A couple of days ago...

Thank you,

Is there a way I can do a query or somewhere in management studio, I can know the service account is a sysadmin role?

Thanks