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

From: Brian Fulford (brian_fulford_at_newsgroup.nospam)
Date: 08/30/04

  • Next message: Matias Woloski: "Re: authorization different paths and roles" 
    Date: Mon, 30 Aug 2004 16:30:12 -0500

    I am losing lots of hair over this issue. We are trying to implement windows
    authentication from a web server to a database server.
    The web server is on a domain; the db server is not... does this matter?
    the IUSR_machinename user from the web server has been added as an account
    on the db server and also been to added to db logins and given access to the
    databases that it will need access to.

    My web.config has the following:
    <authentication mode="Windows"/>

    <sessionState mode="SQLServer" sqlConnectionString="Network
    Library=DBMSSOCN; data source=192.168.30.95; Integrated Security=SSPI;"
    cookieless="false" timeout="20"/>

    Anyone run into this?

    Login failed for user '(null)'. Reason: Not associated with a trusted SQL
    Server connection.
    at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
    isInTransaction)
    at
    System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec
    tionString options, Boolean& isInTransaction)
    at System.Data.SqlClient.SqlConnection.Open()
    at System.Web.SessionState.SqlStateConnection..ctor(String
    sqlconnectionstring)

  • Next message: Matias Woloski: "Re: authorization different paths and roles"

    Relevant Pages

    • Re: write with cURL
      ... execute permissions. ... This is assuming that the PHP script runs ... of potential security risks from other users on the same server. ... web server itself is part of the group. ...
      (alt.php)
    • RE: System.Data.SqlClient "Timeout expired" causing ASP.net web applic
      ... There are many values here that can shutdown the aspnet_wp. ... > update tables on a Web Server running SQL Server 2000. ... > formation(DataSet currentBalances): Timeout expired. ...
      (microsoft.public.dotnet.framework.aspnet.webservices)
    • Re: web service architecture question
      ... To assume that we have all the security we will ever need is a bad one. ... ways to breach a server, and the separatin of the web and app server is one ... You can use remoting or web services. ... The web server will be exposed outside the ...
      (microsoft.public.dotnet.framework.webservices)
    • RE: System.Data.SqlClient "Timeout expired" causing ASP.net web applic
      ... There are many values here that can shutdown the aspnet_wp. ... > update tables on a Web Server running SQL Server 2000. ... > formation(DataSet currentBalances): Timeout expired. ...
      (microsoft.public.dotnet.languages.vb)
    • RE: System.Data.SqlClient "Timeout expired" causing ASP.net web applic
      ... There are many values here that can shutdown the aspnet_wp. ... > update tables on a Web Server running SQL Server 2000. ... > formation(DataSet currentBalances): Timeout expired. ...
      (microsoft.public.dotnet.framework.aspnet)