Database Authentication Error in FP

Hi,
I am trying to add a Data view to a sharepoint site. When I try to create a
connection to the SQL database I get an Authentication error.
I have tried both the Windows Authentication and a Username. I am a DB
administrator and have full access to the database and its server.
Thanks!It's hard to say without detailed error information. But try
turning on failure audits in SQL Server and check the SQL
Server log to see what account is failing. That should help
you track it down. You also want the entire error message -
there are different types of authentication errors that can
point to different problems.
-Sue
On Fri, 14 Oct 2005 13:04:02 -0700, "Slim"
<Slim@.discussions.microsoft.com> wrote:

>Hi,
>I am trying to add a Data view to a sharepoint site. When I try to create a
>connection to the SQL database I get an Authentication error.
>I have tried both the Windows Authentication and a Username. I am a DB
>administrator and have full access to the database and its server.
>Thanks!