October 15, 2009 at 11:58 am
I'm trying to figure out why the IIS server that holds the Reporting Services application keeps reporting the following error: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication?
October 15, 2009 at 1:10 pm
Laura Schmalzbauer (10/15/2009)
I'm trying to figure out why the IIS server that holds the Reporting Services application keeps reporting the following error: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication?
That may be related to double hop if you are in W2k you need to add the Asp.net user account into SQL Server on the server level and in the database with enough permissions to execute your reports because SSRS before 2008 is Asp.net dependent. If you are in Win2003 then you need to add the Network Service account.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply