March 7, 2012 at 4:01 pm
I have a ssis package scheduled to run under SQL server agent service account.
Our SQL agent service account is setup to run using a domain account, for example I use mydomain\mysqlsvcuser,
The package includes tasks like drop table, recreate table, create roles, create users through stored procedures in a database.
But I see in SSMS the account is not a user in that database. So now I got confused how the serivce account user has the permissions, and all the time, the package runs successfully?
Also I don't want to talk about proxy account for this case in case someone recommend to use proxy account.
Thanks
March 7, 2012 at 6:59 pm
Take a look at the permisions service account under security for the server. It sounds like it may have sysadmin privledges which means it doesn't have to be a user of the database.
March 8, 2012 at 9:22 am
That is what I thought.
When we install SQL server, at the step to choose an account for SQL server services, agent services, we use a domain account and entered there.
But the account doesnot show in anywhere in SSMS login and users.
My question now is , is that account a sysadmin, how can I know that?
March 8, 2012 at 9:46 am
IIRC, SQL Server installation sets up some groups. Find out what groups and check those permissions.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply