login failed for user (null)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mecn - 13 Nov 2007 17:33 GMT

Hi

I have .net app got this error below,
Connection failed: sqlstate:28000 sql server error: 18452 login failed for
user(null). reason: not associated with a trusted SQL server connection

Any ideas

thanks

Reply to this Message

Ekrem Önsoy - 13 Nov 2007 20:07 GMT

Your SQL Server Authenticaton could be Windows Authentication and a user
tries to connect using his\her SQL Server login.

Another possibility, that user might not be a member of your domain and
tries to connect to your SQL Server instance.

Signature

Ekrem Önsoy

> Hi
>
[quoted text clipped - 5 lines]
>
> thanks

Reply to this Message

Sean McCown - 27 Nov 2007 15:25 GMT

Yeah, he's right. It's trying to connect with a windows acct that doesn't
have rights in the DB. Either give it rights, or switch to sql auth.

> Hi
>
[quoted text clipped - 5 lines]
>
> thanks

Reply to this Message

Rick Byham, (MSFT) - 30 Nov 2007 22:41 GMT

Or the application is trying to connect using Windows Authentication when no
one is logged in, and it doesn't have a user context. I've seen this when
people set it up using Windows Authentication when they are logged in, and
expect it to work when no one is logged in.

Signature

Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

> Yeah, he's right. It's trying to connect with a windows acct that doesn't
> have rights in the DB. Either give it rights, or switch to sql auth.
[quoted text clipped - 9 lines]
>>
>> thanks

Reply to this Message

Ekrem Önsoy - 30 Nov 2007 23:18 GMT

Hmm.. Good point!

Thanks for sharing.

Signature

Ekrem Önsoy

> Or the application is trying to connect using Windows Authentication when
> no one is logged in, and it doesn't have a user context. I've seen this
[quoted text clipped - 14 lines]
>>>
>>> thanks

Reply to this Message