Intranet access to SQL Server security issue

Discussion in 'ASP .Net Security' started by chris.nolan@feltex.com, Mar 29, 2006.

  1. Guest

    I've lost count of the number of postings I have read on this subject
    yet I can not find an answer.

    I've set up my config file with impersonation as true, IIS is set to
    Basic and Integrated authentication. The web page works fine on my
    local machine, but on the intranet server I get the error Login
    failed for user '(null)'. Reason: Not associated with a trusted SQL
    Server connection.

    The SQL server security is set as Windows and SQL Server. I have added
    the Domain Users group to SQL Server and given it access to the
    database.

    Anybody have any ideas?

    My local machine uses IIS 5.1 and the intranet server uses IIS 6.0 .
    Could this be the issue?
     
    , Mar 29, 2006
    #1
    1. Advertising

  2. Guest

    Sorry, I meant IIS is set to Anonymous and Integrated authentication.
     
    , Mar 29, 2006
    #2
    1. Advertising

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

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

    > I've lost count of the number of postings I have read on this subject
    > yet I can not find an answer.
    >
    > I've set up my config file with impersonation as true, IIS is set to
    > Basic and Integrated authentication. The web page works fine on my
    > local machine, but on the intranet server I get the error Login
    > failed for user '(null)'. Reason: Not associated with a trusted SQL
    > Server connection.
    >
    > The SQL server security is set as Windows and SQL Server. I have added
    > the Domain Users group to SQL Server and given it access to the
    > database.
    >
    > Anybody have any ideas?
    >
    > My local machine uses IIS 5.1 and the intranet server uses IIS 6.0 .
    > Could this be the issue?
    >
     
    Dominick Baier [DevelopMentor], Mar 29, 2006
    #3
  4. Guest

    I thought I was there for a second. Unfortunately we are not running
    AD. How do I get around this?
     
    , Mar 29, 2006
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Patrick.O.Ige
    Replies:
    0
    Views:
    397
    Patrick.O.Ige
    Sep 30, 2005
  2. andy
    Replies:
    2
    Views:
    619
  3. =?Utf-8?B?a21jY29za2V5?=

    ACCESS AN ACCESS DATABASE FROM ASP.NET INTRANET SCENARIO

    =?Utf-8?B?a21jY29za2V5?=, Apr 24, 2007, in forum: ASP .Net
    Replies:
    7
    Views:
    474
    =?Utf-8?B?a21jY29za2V5?=
    Apr 30, 2007
  4. K Viltersten
    Replies:
    2
    Views:
    704
    K Viltersten
    Oct 6, 2008
  5. kmccoskey
    Replies:
    2
    Views:
    266
    Paul Clement
    Apr 27, 2007
Loading...

Share This Page