One of our users had me change the targeted environment on an SSIS package.
The package runs in production, but he wanted to alter its targeted DB from the production SQL instance and have it target Dev.
Did as directed and left as is.
Few later he had me run the SQL Server Agent job.
And, informed him that it errored out.
He checked SSIS Logs and came back with this message :-
Login failed for user ‘LAB\webService’
I am not sure why would that happen. Can you explain?
The error message :-
Login failed for user ‘LAB\webService’. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 192.168.12.17]
basically states that the identified principal lacks SQL Server Instance access.
In this case our principal is an Active Directory account.
I think traditional SQL principals have clearer error messages.
To remediate, please grant SQL Server Instance access.
Create Login – Syntax
CREATE LOGIN [domainName]\[login_name] FROM WINDOWS;
Create Login – Sample
create login [LAB\webService] from windows;