Post reply

SSIS + SSRS help

  • June 4, 2008 at 10:54 am

    #187613

    Does anyone have any help they could provide with the following situation: I have an SSIS package and I want to run it through SSRS, however there seems to be a problem with my login credentials. I use windows authentication, so if anyone has any input it'd be most appreciated.

    Thanks

  • June 4, 2008 at 11:19 am

    #824363

    Is it running on a different server than the one it was created on?

    Is it running the job under a proxy account?

    Does the account SSRS is running under have the necessary rights?

    Those are the first things I can think of.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • June 4, 2008 at 11:54 am

    #824399

    1) No

    2) No

    3) Yes, it is running under the same account at the moment. However in an ideal app I want it to run as a separate service.

    Thanks

  • June 4, 2008 at 12:18 pm

    #824416

    Is there a data source in the SSIS package that is using NT authentication and not the server SSRS and SSIS are running on?

    If your package is pulling data from another server, or even using a file share, you have to use kerberos authentication to make the hop to the additional server with your client windows login.

  • June 4, 2008 at 12:24 pm

    #824423

    Well I should have mentioned this and hopefully this helps clarify, it is just a flat file source that I am using..

  • June 4, 2008 at 1:07 pm

    #824456

    Is it on a file share that is not on the SSIS / SSRS server? This too requires authentication unless you set the security group on the sahre and the folder to "Everyone"

  • June 4, 2008 at 1:37 pm

    #824487

    Thanks for the input, but the file is stored on my local drive. I am using SQL Server 2005 SP2 and Windows XP pro SP2.

    Also if anyone has any good links that put me into combining SSIS/SSRS please send them my way, or better yet if you have a basic tutorial or explanation on how to do this it would be most appreciated.

  • June 5, 2008 at 6:55 am

    #824760

    I'm going to bump this to see if any early morning people can provide some insight. Thanks

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply