February 3, 2009 at 8:23 pm
I'm using vista OS
I have a SSIS package.When i 'm in Vstudio i can run the package.
If i run SQL server Management studio as an Administrator(I mean right clikc and click Run As Admin)
and i import the package and run it.
It works.
If i don't run SQL server Management studio as an Administrator the package fails
I'm using ProtectionLevel = EncryptSensitiveWithPassword
When i look at the job history i see:
The job was invoked by user DOMAIN\username
Executed as user DOMAIN\COMPUTERNAME
Why is this?
Any ideas?
Thanks
February 3, 2009 at 10:24 pm
Hello,
Under which Account does the SQL Agent Service run? Perhaps it is set up as Local System?
Did you already spot this MSDN Article on setting the SQL Agent Service Account?
http://msdn.microsoft.com/en-us/library/ms191543.aspx
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
February 4, 2009 at 3:56 am
Hi,
the SQL Agent Service is running under NETWORK SERVICE.
Is Local System the way to go?
Please elaborate
Thanks
----------------------------------------------------------------------------
Hello,
Under which Account does the SQL Agent Service run? Perhaps it is set up as Local System?
Did you already spot this MSDN Article on setting the SQL Agent Service Account?
February 4, 2009 at 4:14 am
Hello again,
The best is to create a Windows Account specifically for the SQL Agent Service to run under. That way you can assign exactly the rights required. The MSDN article describes the permissions that you need to grant to the Account.
http://msdn.microsoft.com/en-us/library/ms191543.aspx
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply