windows authentication problem

23 Sep 2005 7:55 AM

Filip De Backer

Hi everyone,

I've got the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

In my webconfig file I use:
<authentication mode="Windows"/>
<identity impersonate="true"/>

My connectionstring is:
data source=SAN-SRV4; initial catalog=LessiusData; Integrated Security=SSPI;

And when I check my login it is lessius\filip.debacker
So that is correct

I check it with
System.Security.Principal.WindowsIdentity.GetCurrent().Name;

So what do you think the problem is?

thanks!

Filip

23 Sep 2005 10:55 AM

Dominick Baier [DevelopMentor]

Hello Filip,

classical double hop problem.

check this:
http://msdn.microsoft.com/msdnmag/issues/05/09/SecurityBriefs/default.aspx

---------------------------------------
Dominick Baier - DevelopMentor
http://www.leastprivilege.com

Show quoteHide quote

> Hi everyone,
>
> I've got the following error:
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL
> Server connection.
> In my webconfig file I use:
> <authentication mode="Windows"/>
> <identity impersonate="true"/>
> My connectionstring is:
> data source=SAN-SRV4; initial catalog=LessiusData; Integrated
> Security=SSPI;
> And when I check my login it is lessius\filip.debacker So that is
> correct
>
> I check it with
> System.Security.Principal.WindowsIdentity.GetCurrent().Name;
> So what do you think the problem is?
>
> thanks!
>
> Filip
>

26 Sep 2005 12:28 PM

synsoft

Try Windows and SQL Authentication in the SQL Server

Show quoteHide quote

"Filip De Backer" <FilipDeBac***@discussions.microsoft.com> wrote in message
news:B0BD22F9-4EEF-432B-AACE-328BFAA04568@microsoft.com...
> Hi everyone,
>
> I've got the following error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> In my webconfig file I use:
> <authentication mode="Windows"/>
> <identity impersonate="true"/>
>
> My connectionstring is:
> data source=SAN-SRV4; initial catalog=LessiusData; Integrated
Security=SSPI;
>
> And when I check my login it is lessius\filip.debacker
> So that is correct
>
> I check it with
> System.Security.Principal.WindowsIdentity.GetCurrent().Name;
>
> So what do you think the problem is?
>
> thanks!
>
> Filip

26 Sep 2005 12:32 PM

synsoft

Try Windows and SQL Authentication in the SQL Server

Show quoteHide quote

"Filip De Backer" <FilipDeBac***@discussions.microsoft.com> wrote in message
news:B0BD22F9-4EEF-432B-AACE-328BFAA04568@microsoft.com...
> Hi everyone,
>
> I've got the following error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> In my webconfig file I use:
> <authentication mode="Windows"/>
> <identity impersonate="true"/>
>
> My connectionstring is:
> data source=SAN-SRV4; initial catalog=LessiusData; Integrated
Security=SSPI;
>
> And when I check my login it is lessius\filip.debacker
> So that is correct
>
> I check it with
> System.Security.Principal.WindowsIdentity.GetCurrent().Name;
>
> So what do you think the problem is?
>
> thanks!
>
> Filip