On some of our servers, we don't have sa account enabled.

For this purpose then, I need to enable it.

I read for Brad Mcgehee's best practice, never use sa to...

This makes a lot of sense.

I hope there is a microsoft article explains this in detail. Because we are planning upgrade all our sql 2005 to 2008 on windows 2008,...

No, I had to ask our network people to do that. No access to AD. and I don't think the group NT SERVICE\SQLSERVERAGENT is in AD, it is a...

Thanks a lot, I will give it a try.

I did a check in AD, the SID of our domain account doesn't match the one in the group above mentioned.

So that didn't explain the relationship.

I cannot find it either.

So there should be a relationship between maintence plan and their jobs, not sure what table to use to query?

Thanks

Thanks, is there a way also include the job name and its owner in the query too?

Also is there a query for me to pull all the maintenace plan name, owner name, and jobs for both sql 2005 and 2008?

Thanks

This is good to know.

I wonder if using sa is a good practice, read from somewhere, sa account should be disabled for best security.

Thanks.

"If I understand this stuff correctly, installation will create three sql users: NT AUTHORITY\SYSTEM, NT SERVICE\MSSQLSERVER, and NT SERVICE\SQLSERVERAGENT all of whicy will be made sysadmins. "

Is it also a...

"Then you should understand by now that you cannot see your userid from any screen to which you have access. Your user account is a part of that group and...

"The bolded section next to the NT Service is the SID.

Beyond that, you will not be able to see your service account from the local group nor from SQL Server....

Thanks.

"And again the relation to the service account that is a domain account, you will NOT see it listed anywhere in those groups. YOU WILL ONLY see the SID for...

You are using configuration manager to change service account. But I'm asking when the firsttime you install it, is it a manual process?

For @SQLDCH answer about the group, he...

And Is it a manual process after installation to add the service account in my case is a windows domain account to the windows local group called:SQLServerSQLAgentUser$Mycomputername$MSSQLSERVER