December 13, 2007 at 8:03 am
Hi all,
I am trying to configure SSIS on server1 with Database on server 2.
I changed the ini file for ssis with servername/instance name
but still i get following error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
How can i solve it!!
Thanks
Pat
December 13, 2007 at 8:50 am
What account is SSIS running under?
Tommy
Follow @sqlscribeDecember 13, 2007 at 8:57 am
It runs under specifice id which is part of Admin group on the server!!
December 13, 2007 at 9:06 am
Does this account also have access to the database server? Is Kerberos working? Have you enabled the SSIS server for delegation?
http://support.microsoft.com/kb/319723
Tommy
Follow @sqlscribeDecember 13, 2007 at 9:24 am
Hi thanks for the reply, how can i enable the SSIS for Delegation? also what do i need to do for Kerberos setup!? what part do i need to tell sercurity group to change!!
Thanks
Pat
December 13, 2007 at 9:32 am
You would trust the server SSIS is running on for delegation. Review the article in the previous post, there are several steps you will need to take to ensure Kerberos authentication is enabled between the host running SSIS and the host running the database server. I've run into the same situations with SSRS/SSAS as well.
Tommy
Follow @sqlscribeDecember 13, 2007 at 3:58 pm
Hi,
do i need to set kerberos to both server or only through SSIS server?
Thanks
Pat
December 14, 2007 at 6:56 am
Hi Pat,
>It runs under specifice id which is part of Admin group on the server!!
Is that id a domain account? It's local admin on which server? SSIS or DB or both?
Norman
DTS Package Search
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply