Posted by Damien on 11/15/06 08:31

Mad Scientist Jr wrote:

> I am getting the following error when trying to access a database with
> a trusted connection:
>
> "Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection."
>
> My connection string is:
>
> "Server=MyServer; Database=MyCatalog; Trusted_Connection=True;"
>
> Note that Anonymous Access is off in IIS, and I am able to read my
> Windows login with:
>
> Textbox1.text =
> System.Web.HttpContext.Current.User.Identity.Name.Substring(System.Web.HttpContext.Current.User.Identity.Name.IndexOf("\")
> + 1).ToLower()
>
> Can anyone explain how to query the db using a trusted connection?
>
> PS Is there a way to dynamically retrieve a list of databases the
> current user has SQL rights on, by specifying only the server, again
> using trusted connection?
>
> Thanks...

You're almost certainly encountering the "double hop" issue. This
arises when IIS and SQL Server are on separate servers. If that isn't
true in your circumstance, then ignore the rest of this post.

The problem arises because your client machine authenticates you to the
IIS server, but the IIS server has no means of authenticating you to
the SQL Server box (It can't make the second "hop" of authentication).
There was a superb MSDN Magazine article some time back that describes
this, but I can't seem to find it right now. I have found this
knowledge base article:

http://support.microsoft.com/kb/810572

which seems to cover the same areas.

Damien

• Next in forum: I want to revert back to original state of database before i performed restore database
• Prev in forum: newbie: telnet localhost 1433 fails
• Thread view: Re: problem with trusted connection (asp.net)

[Reply to this message]