May 1, 2012 at 1:35 pm
I know that you are not supposed to use the Local System Account to run packages.
Even if I did I have an SSIS Package and if I change the SQL Server Agent Account to run as the Local System Account the Job fails because it disabled the AS400 Account, I assume because it could not authenticate?
There is not a SQL Server Domain Account that I can use, I have to request one.
Listed is an article on the permissions that an Account for SQL Server Service Accounts.
http://msdn.microsoft.com/en-us/library/ms191543.aspx
Any thoughts or ideas would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 1, 2012 at 2:20 pm
Local System Account does not have access to network resources, iirc.
May 4, 2012 at 7:30 am
Did you try giving permission to [DomainName\MachineName$] on AS400?
This is not a good practice but I think this should work
May 4, 2012 at 7:41 am
The AS400 is hosted by a Vendor.
I can't wait until it goes away.
I was having trouble with an OpenQuery Statement that referenced two tables with a WHERE EXISTS.
I gave them the partial syntax and there wanted to bill me $200.:w00t:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply