I can not login SQL Server

Hi everybody,
I'm a newbe on SQL Server;
Here my problem is:
In Server Explorer I create a Data Connection to Nortwind. After Creating
the connection I can reach tables of this database.
But: When I want to configure the dataAdapter the problem occurs:
In the configure wizard "Data Soure Login" window comes.
Altought I know the user "sa" password This error comes:
"Login Failed:Not Associated With a Trusted SQL Server Connection. Invalid
Connection String Attribute."
How can I overcome with this problem.
What may be the reason of this problem.
Thanks for any help.
Arif imen
Prowise Software.The most likely reason is that your server is configured for
Windows Authentication only. When you try to use the sa
login for the data source login, you are using SQL Server
authentication. Use Windows Authentication for your
connection. If you need to connect with a SQL login, you
need to change SQL Server's authentication mode to use
Windows and SQL authentication.
-Sue
On Wed, 16 Mar 2005 18:28:53 +0200, "news.microsoft.com"
<arif_cimen@.hotmail.com> wrote:

>Hi everybody,
>I'm a newbe on SQL Server;
>Here my problem is:
>In Server Explorer I create a Data Connection to Nortwind. After Creating
>the connection I can reach tables of this database.
>But: When I want to configure the dataAdapter the problem occurs:
>In the configure wizard "Data Soure Login" window comes.
>Altought I know the user "sa" password This error comes:
>"Login Failed:Not Associated With a Trusted SQL Server Connection. Invalid
>Connection String Attribute."
>How can I overcome with this problem.
>What may be the reason of this problem.
>Thanks for any help.
>Arif imen
>Prowise Software.
>|||Thaks a lot. It works.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:tdmh31llcr09lvf0pa3ihh0d7oiolv0v1c@.
4ax.com...
> The most likely reason is that your server is configured for
> Windows Authentication only. When you try to use the sa
> login for the data source login, you are using SQL Server
> authentication. Use Windows Authentication for your
> connection. If you need to connect with a SQL login, you
> need to change SQL Server's authentication mode to use
> Windows and SQL authentication.
> -Sue
> On Wed, 16 Mar 2005 18:28:53 +0200, "news.microsoft.com"
> <arif_cimen@.hotmail.com> wrote:
>
>