By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,880 Members | 2,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,880 IT Pros & Developers. It's quick & easy.

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

P: n/a
We are using impersonation so that a user on our domain will login into our
SQL Server using their own domain login and/or associated domain groups. To
do this, we've added:

<authentication mode="Windows" />
<identity impersonate="true"/>

to our web.config file. In IIS, annonymous access is unchecked, digest
authentication is unchecked, basic authentication is unchecked, and
Integrated Windows Authentication is checked.

The problem: This works like a charm on my local pc running IIS and
connecting to SQL Server A, but the momemnt I load it up on our development
web site with the same web.config file and same IIS settings, the connection
to SQL Server A bombs with the error message:
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection." Note that the rest of the site that does not use a
connection to SQL Server works just fine.

Any ideas?? Thanks in advance for your help! We appreciate it.

Mark
fi******@umn.edu

Nov 15 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Hello, Mark!
We are using impersonation so that a user on our domain will login into our SQL Server using their own domain login and/or associated domain groups. To do this, we've added:

<authentication mode="Windows" />
<identity impersonate="true"/>

to our web.config file. In IIS, annonymous access is unchecked, digest
authentication is unchecked, basic authentication is unchecked, and
Integrated Windows Authentication is checked.

The problem: This works like a charm on my local pc running IIS and
connecting to SQL Server A, but the momemnt I load it up on our development web site with the same web.config file and same IIS settings, the connection to SQL Server A bombs with the error message:
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection." Note that the rest of the site that does not use a
connection to SQL Server works just fine.

Any ideas?? Thanks in advance for your help! We appreciate it.

Use the Integrated Security keyword for Connection String, set to a value of
SSPI, to specify Windows Authentication

--
WBR, Roman S. Golubin
ICQ UIN 63253392
go****************@arhcity.ru
Nov 15 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.