Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Can't execute SSIS package from remote machine Expand / Collapse
Posted Tuesday, March 19, 2013 4:26 AM


Group: General Forum Members
Last Login: Monday, December 16, 2013 6:50 AM
Points: 139, Visits: 269
OS: Windows 2012, standard, 64-bit
SQL: 2012 + SP1 + CU2 = 11.0.3339

We recently decided to "break apart" our BI environment. We used to have everything on one box, DB Engine, SSIS, SSAS & SSRS. Everything has been running fine, but we now have other projects using these services, so we decided to break them apart into their own boxes.

We now have DB Engine on one Server, SSIS & SSRS on another server and SSAS on yet another server, so we now have three boxes that replaced one box. All are Windows 2012, standard, 64-bit with SQL Server 2012 + SP1 + CU2.

Since some of our SSIS packages have to access external resources, we used a domain account for it's service account. The DB Engine and SSAS box are using the default service accounts when installed. I can execute the packages fine on the SSIS server, I can even execute them via SQL Agent jobs on the SSIS box (we did install a default instance of SQL on the SSIS box), however when I try to execute a package from my laptop, it fails with the ugly "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'". I immediately double checked my SPNs and they all looked correct for the SSIS server and the service account we are using (and we had no duplicates). I also double checked the User Rights Assignment in the Local policy editor and all the correct Rights have been assigned (Log on as a service, Bypass traverse checking, Impersonate a client after authentication).

I'm stumped here. Anybody have anything else I can check or that I have overlooked?


Post #1432555
Posted Tuesday, August 13, 2013 6:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 4:17 PM
Points: 1, Visits: 2
Have you figured this one out?

Post #1484038
Posted Wednesday, August 14, 2013 9:20 AM

Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 07, 2014 7:35 AM
Points: 1,172, Visits: 2,413
Ivan.Huter (8/13/2013)
Have you figured this one out?


Whatever method the OP was using to try to execute an SSIS package on a remote server from a laptop was probably attempting to log in to the server hosting the SSIS instance with a local account on the laptop, quite likely the NetworkService account. If so, the server was rejecting the login attempt because it didn't come from a domain account or a recognized local account (local to the server, that is), thus its designation as an anonymous login attempt. The OP probably needs to reconfigure the process to use a domain account with appropriate permissions to log in to the remote server.

Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1484363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse