March 21, 2017 at 10:30 am
Hi!
I can run the package with success but when running the package of created job it gives me some permission error with local hostname/$.
The account associated with the job is system admin and local admin,
Help is appreciated,
Thanks & Regards,
Bubby
March 21, 2017 at 10:44 am
bubby - Tuesday, March 21, 2017 10:30 AMHi!
I can run the package with success but when running the package of created job it gives me some permission error with local hostname/$.The account associated with the job is system admin and local admin,
Help is appreciated,
Thanks & Regards,
Bubby
Please post the exact error message and briefly describe what the package is doing - such as is it accessing external files, is it just executing queries on the same server, is it executing an external program, etc.
Sue
March 21, 2017 at 10:49 am
Message
Executed as user: TF\AYLIDB$. Microsoft (R) SQL Server Execute Package Utility Version 10.50.6000.34 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:21:26 PM Error: 2017-03-21 12:21:26.89 Code: 0xC0047062 Source: BranchContactFromICSPOS ADO NET Source [1] Description: System.Data.SqlClient.SqlException: Login failed for user 'TF\AYLIDB$'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction) at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction) End Error Error: 2017-03-21 12:21:26.89 Code: 0xC0047017 Source: BranchContactFromICSPOS SSIS.Pipeline Description: component "ADO NET Source" (1) failed validation and returned error code 0x80131904. End Error Error: 2017-03-21 12:21:26.89 Code: 0xC004700C Source: BranchContactFromICSPOS SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2017-03-21 12:21:26.89 Code: 0xC0024107 Source: BranchContactFromICSPOS Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:21:26 PM Finished: 12:21:26 PM Elapsed: 0.733 seconds. The package execution failed. The step failed.
March 21, 2017 at 10:49 am
AYLIDB is the local server hostname
March 21, 2017 at 11:19 am
bubby - Tuesday, March 21, 2017 10:49 AMAYLIDB is the local server hostname
The login failure is for the machine account so I would guess your using a trusted connection, windows authentication and that service account for that instance may be running as network service or something along those lines.
To run the package using another account or a proxy account, follow the steps in this article:
Run an SSIS Package Under a Different Account
That account will need permissions/access to whatever it is the package does or accesses.
Sue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply