Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn

Hi There,
I can't connect to SQL Server, has anyone received this error message before
?
Moe <><
<appSettings>
<add key="ConnectionString"
value="server=202.60.XX. XXX;database=db_name;uid=user1;password=
pass;integra
ted security=SSPI;persist security info=False;Integrated Security=tr e;" />
</appSettings>Remove the integrated security info from the connection string. The
"Integrated Security=tr e;" portion of the connection string is telling SQL
Server to use Windows Authentication, not SQL Server Authentication.
"Moe Sizlak" <moe@.moe.com> wrote in message
news:Ouj6DrSaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> Hi There,
> I can't connect to SQL Server, has anyone received this error message
before
> ?
> Moe <><
>
> <appSettings>
> <add key="ConnectionString"
>
value="server=202.60.XX. XXX;database=db_name;uid=user1;password=
pass;integra
> ted security=SSPI;persist security info=False;Integrated Security=tr e;"
/>
> </appSettings>
>
Hi Moe:
Use either integrated security or the uid/password combination - you
have both in the connection string and it should be one or the other.
Judgine by the error message, I'd remove Integrated Security=SSPI
first because it sounds as if you environment is not setup to operate
that way.
Scott
http://www.OdeToCode.com
On Wed, 14 Jul 2004 08:43:05 +1000, "Moe Sizlak" <moe@.moe.com> wrote:

>Hi There,
>I can't connect to SQL Server, has anyone received this error message befor
e
>?
>Moe <><
>
><appSettings>
><add key="ConnectionString"
>value="server=202.60.XX. XXX;database=db_name;uid=user1;password=
pass;integr
a
>ted security=SSPI;persist security info=False;Integrated Security=tr e;" />
></appSettings>
>
Try this KB article:
http://support.microsoft.com/suppor...s/Q307/0/02.asp
"Moe Sizlak" <moe@.moe.com> wrote in message news:<Ouj6DrSaEHA.3996@.TK2MSFTNGP12.phx.gbl>...

> Hi There,
> I can't connect to SQL Server, has anyone received this error message befo
re
> ?
> Moe <><
>
> <appSettings>
> <add key="ConnectionString"
> value="server=202.60.XX. XXX;database=db_name;uid=user1;password=
pass;integ
ra
> ted security=SSPI;persist security info=False;Integrated Security=tr e;" /
>
> </appSettings>