Problem Authenticating (SQL Server 2008)

On Oct 9, 11:49 pm, "bass_player" <bass_pla...@do-not-
reply.messages.com> wrote:
> Try running SQL Profiler to find out why you are getting this error - just
> to validate that it is indeed the service account and not the IIS account
> configured on your Application Pool for your Reporting Services web
> application.
>
> wrote in message
>
>
>
> > I am having an issues when i run reports on SQL Server 2008 Reporting
> > Services and when running Maintenance plans with in the database
> > engine.  My database engine,reporting and agent are all running as the
> > same domain account and it is for the same domain that the server and
> > all client machines are on.
>
> > I get the following error when ever I try to run a report or execute a
> > maintenance plan:
>
> > "Login failed. The login is from an untrusted domain and cannot be
> > used with Windows authentication."
>
> > I do not know whey it would be reporting that the domain is
> > untrusted...it is the domain that the system belongs to so there
> > should be a trust relationship there and there is only the single
> > domain in our environment.
>
> > Thanks for your help,
> > Patrick

bass_player,

Thank you for your reply. When I start trace and then log into the
reporting services site, everything shows up as being done with the
service account.

It seems that everytime I try to do something that specifically is set
to use Windows credentials, I get the error message described in my
first post. The same is true for when ever I run a maintenance plan
either scheduled or manually run.

- Patrick
 >> Stay informed about: Problem Authenticating (SQL Server 2008) 

This is the exact error message I am getting...


Date 10/10/2008 2:43:53 PM
Log Job History (Daily Full User DB Backups.Subplan_1)

Step ID 1
Server SQL08-TEST
Job Name Daily Full User DB Backups.Subplan_1
Step Name Subplan_1
Duration 00:00:04
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: ADS\dbact. Microsoft (R) SQL Server Execute Package
Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp
1984-2005. All rights reserved. Started: 2:43:53 PM Error:
2008-10-10 14:43:56.87 Code: 0xC00291EC Source:
{4E3EF9A8-5D21-46F6-AAA9-AC6918845FD4} Execute SQL Task
Description: Failed to acquire connection "Local server connection".
Connection may not be configured correctly or you may not have the
right permissions on this connection. End Error Warning: 2008-10-10
14:43:56.87 Code: 0x80019002 Source: OnPreExecute
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The
Execution method succeeded, but the number of errors raised (1)
reached the maximum allowed (1); resulting in failure. This occurs
when the number of errors reaches the number specified in
MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning Error: 2008-10-10 14:43:57.21 Code: 0xC0024104
Source: Back Up Database Task Description: The Execute method on
the task returned error code 0x80131904 (Login failed. The login is
from an untrusted domain and cannot be used with Windows
authentication.). The Execute method must succeed, and indicate the
result using an "out" parameter. End Error Error: 2008-10-10
14:43:57.24 Code: 0xC0024104 Source: {4B65BEDE-D274-4B06-8CA7-
A7DB4DE235C3} Description: The Execute method on the task
returned error code 0x80131904 (Login failed. The login is from an
untrusted domain and cannot be used with Windows authentication.). The
Execute method must succeed, and indicate the result using an "out"
parameter. End Error Warning: 2008-10-10 14:43:57.24 Code:
0x80019002 Source: OnPostExecute Description: SSIS Warning
Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded,
but the number of errors raised (2) reached the maximum allowed (1);
resulting in failure. This occurs when the number of errors reaches
the number specified in MaximumErrorCount. Change the
MaximumErrorCount or fix the errors. End Warning DTExec: The package
execution returned DTSER_FAILURE (1). Started: 2:43:53 PM Finished:
2:43:57 PM Elapsed: 3.421 seconds. The package execution failed.
The step failed.
 >> Stay informed about: Problem Authenticating (SQL Server 2008) 

I created a new SQL Login (not a domain or local machine account) and
made it part of the sysadmin role. Then I went into the connection
properties for my db connection in the Maintenance Plan and changed
the log in credientials from using Windows NT Integrated
Authentication to using the new user i just created. After doing so
everything worked as it should.

I am really confused...
 >> Stay informed about: Problem Authenticating (SQL Server 2008)