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

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;pa ssword=pass;integra
ted security=SSPI;persist security info=False;Integrated Security=tr e;" /
</appSettingsRemove 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;pa ssword=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 before
>?
>Moe <><
>
><appSettings>
><add key="ConnectionString"
>value="server=202.60.XX.XXX;database=db_name;uid=user1;pa ssword=pass;integra
>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 before
> ?
> Moe <><
>
> <appSettings>
> <add key="ConnectionString"
> value="server=202.60.XX.XXX;database=db_name;uid=user1;pa ssword=pass;integra
> ted security=SSPI;persist security info=False;Integrated Security=tr e;" />
> </appSettings>