Service accounts, local admin, and sysadmin question!

Hi,

Re: SQL Server 2005

We have defined a local administrator to be the SQL Server and SQL Server Agent services user, and is also the job step owner for some SSIS packages I am running.

My question is, isn't by default a local administrator ALSO granted sysadmin in SQL Server According to this link, it seems to imply this:

http://msdn2.microsoft.com/en-us/library/ms143504.aspx

However, I am having some permissions problems with the local adminstrator account (i.e. SQL Server agent account) when it runs the job. The error is that it doesn't have execute permissions on sp_dts_addlogentry.

How can this be, if it's granted sysadmin

Thanks

Yes, there is a BUILTIN\Administrators login on the server, with sysadmin privs. There is also a separate login for the SQL Server agent local administrator account.

Perhaps this is the problem, the fact that the administrator account has its own login AND is part of the BUILTIN\Administrators group

Because the separate login does not have sysadmin privs checked off. I think this separate login got added by accident when I scripted all the logins from a 2000 box to the 2005 server, and even though it in 2000 it is clear it is a login via group membership, the script added it like a separate login.

Q. I suppose it would be safe to remove this login, yes

Thanks