Hi all!
I have an asp.net web application that is configured for dynamic
impersonation via web.config (identity impersonate=true). The corresponding
virtual directory is protected by integrated windows authentication via IIS.
Some pages within my web application access a MS SQL Server database hosted
on a separate server. The database connection string is set to use a trusted
connection. Now the problem is, that sometimes the user's context is not
passed to the SQL server - in this case, I receive the following error
message: "Login for user (null) failed, not associated with a trusted
connection". The problem only occurs for some users, for the majorty of the
users there are no problems.
What might be the problem? In Active Directory, the servers are set to
"trusted for delegation", the web server runs IIS 6 on a Win2003 Server.
Thanks in advance
Thomas 4 1400
Check your SQL server to see if those users with login problems exist in the
database.
Lenny
"Thomas" <pi******************@web.de> wrote in message
news:OJ*************@TK2MSFTNGP10.phx.gbl... Hi all!
I have an asp.net web application that is configured for dynamic impersonation via web.config (identity impersonate=true). The
corresponding virtual directory is protected by integrated windows authentication via
IIS. Some pages within my web application access a MS SQL Server database
hosted on a separate server. The database connection string is set to use a
trusted connection. Now the problem is, that sometimes the user's context is not passed to the SQL server - in this case, I receive the following error message: "Login for user (null) failed, not associated with a trusted connection". The problem only occurs for some users, for the majorty of
the users there are no problems.
What might be the problem? In Active Directory, the servers are set to "trusted for delegation", the web server runs IIS 6 on a Win2003 Server.
Thanks in advance
Thomas
"L. L." <ll**@cyence.com> wrote in message
news:uN**************@tk2msftngp13.phx.gbl... Check your SQL server to see if those users with login problems exist in
the database.
Lenny
In my database I only have user groups and roles for these groups. The
affected users are members of the appropriate groups.
Thomas "Thomas" <pi******************@web.de> wrote in message news:OJ*************@TK2MSFTNGP10.phx.gbl... Hi all!
I have an asp.net web application that is configured for dynamic impersonation via web.config (identity impersonate=true). The corresponding virtual directory is protected by integrated windows authentication via IIS. Some pages within my web application access a MS SQL Server database
hosted on a separate server. The database connection string is set to use a trusted connection. Now the problem is, that sometimes the user's context is not passed to the SQL server - in this case, I receive the following error message: "Login for user (null) failed, not associated with a trusted connection". The problem only occurs for some users, for the majorty of the users there are no problems.
What might be the problem? In Active Directory, the servers are set to "trusted for delegation", the web server runs IIS 6 on a Win2003 Server.
Thanks in advance
Thomas
I am sure that it is SQL Server is denying those affected users. Maybe those
users belong to more than one groups or assigned to more than one roles And
if the database denies any one of the groups or any one of the roles does
not have the access to the db then it will fail on the connection.
L.L.
"Thomas" <pi******************@web.de> wrote in message
news:e8**************@TK2MSFTNGP11.phx.gbl... "L. L." <ll**@cyence.com> wrote in message news:uN**************@tk2msftngp13.phx.gbl... Check your SQL server to see if those users with login problems exist in the database.
Lenny
In my database I only have user groups and roles for these groups. The affected users are members of the appropriate groups.
Thomas
"Thomas" <pi******************@web.de> wrote in message news:OJ*************@TK2MSFTNGP10.phx.gbl... Hi all!
I have an asp.net web application that is configured for dynamic impersonation via web.config (identity impersonate=true). The corresponding virtual directory is protected by integrated windows authentication
via IIS. Some pages within my web application access a MS SQL Server database
hosted on a separate server. The database connection string is set to use a trusted connection. Now the problem is, that sometimes the user's context is
not passed to the SQL server - in this case, I receive the following error message: "Login for user (null) failed, not associated with a trusted connection". The problem only occurs for some users, for the majorty
of the users there are no problems.
What might be the problem? In Active Directory, the servers are set to "trusted for delegation", the web server runs IIS 6 on a Win2003
Server.
Thanks in advance
Thomas
"L. L." <ll**@cyence.com> wrote in message
news:Oo**************@TK2MSFTNGP11.phx.gbl... I am sure that it is SQL Server is denying those affected users. Maybe
those users belong to more than one groups or assigned to more than one roles
And if the database denies any one of the groups or any one of the roles does not have the access to the db then it will fail on the connection.
L.L.
Currently I think it's a delegation problem - the affected users cannot
connect from a specific computer while it works from another one. And for
95% of the users it works perfectly, although there are some users among
them that are part of the same groups as the affected ones. That's why I
think it's not a role or group problem.
Thomas
"Thomas" <pi******************@web.de> wrote in message news:e8**************@TK2MSFTNGP11.phx.gbl... "L. L." <ll**@cyence.com> wrote in message news:uN**************@tk2msftngp13.phx.gbl... Check your SQL server to see if those users with login problems exist
in the database.
Lenny
In my database I only have user groups and roles for these groups. The affected users are members of the appropriate groups.
Thomas
"Thomas" <pi******************@web.de> wrote in message news:OJ*************@TK2MSFTNGP10.phx.gbl... > Hi all! > > I have an asp.net web application that is configured for dynamic > impersonation via web.config (identity impersonate=true). The corresponding > virtual directory is protected by integrated windows authentication via IIS. > > Some pages within my web application access a MS SQL Server database hosted > on a separate server. The database connection string is set to use a trusted > connection. Now the problem is, that sometimes the user's context is not > passed to the SQL server - in this case, I receive the following
error > message: "Login for user (null) failed, not associated with a
trusted > connection". The problem only occurs for some users, for the majorty
of the > users there are no problems. > > What might be the problem? In Active Directory, the servers are set
to > "trusted for delegation", the web server runs IIS 6 on a Win2003 Server. > > > Thanks in advance > > Thomas > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Stephane Belzile |
last post by:
Hi,
I've seen a lot of people having that same problem trying to
instantiate a word.application com object from an asp.net application.
I have built a WEB application that is used to manage the...
|
by: Robm |
last post by:
I have a super simple asp.net web (hello world plus the current time) which
works fine on my development system. When copied to the target server an
error is reported in that a file cannot be...
|
by: Stephane Belzile |
last post by:
Hi,
I've seen a lot of people having that same problem trying to
instantiate a word.application com object from an asp.net application.
I have built a WEB application that is used to manage the...
|
by: Rob Roberts |
last post by:
I have developed an ASP.NET 2.0 application using localhost on my Windows XP
workstation, and it all works fine there. I tried to copy it to my test web
server, which is a domain controller...
|
by: velvet.graham |
last post by:
I'm having a difficult time with impersonation. I've created an
impersonation class. Here is the code below:
******Impersonation Class Code*********
Imports System
Imports System.Web.Security...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |