SSRS Authentication

  • Is it possible to pass SQL Server Reporting Services independant credentials to impersonate a Windows domain account? I have users that do not have a Windows domain account that need access to SSRS, however I must be able to filter their visible reports so Anonymous login isn't exactly an option. Basically, I'm looking for any options to impersonate or bypass Windows Authentication entirely.

    As always, any and all help is greatly appreciated!

    ~Ruprecht

  • Books online really describes the securty pretty clearly.

    http://msdn.microsoft.com/en-us/library/bb283249(SQL.90).aspx

    Can't really give you a clear answer because it really depends on what your trying to do in the long run.

    This may be a point of reference for you also.

    http://blogs.msdn.com/bimusings/archive/2005/11/04/489100.aspx

  • Thanks so much for the reply. Forms authentication is really what I was after and it looks like the MSDN post will do the trick. I'm going to do a bit more research and then I'll let you know if it works for us.

    Thanks again,

    Ruprecht

Viewing 3 posts - 1 through 2 (of 2 total)

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