Logon failed for user '(null)'..... error

From: Jrome (jlapointe_at_isd.state.al.us)
Date: 12/23/03


Date: Tue, 23 Dec 2003 12:32:51 -0800

We are receiving the error "Logon failed for
user '(null)'. Reason: Not associated with a trusted SQL
Server Connection".

We have a WinForms application written in VB.NET 2003 and
connect to a SQL Server 2000 (SP3) DB with the following
connection string:
        gstrConn = _
                "Server=SQL2000;" & _
                "DataBase=dbname;" & _
                "Integrated Security=SSPI;"

The application works perfectly for the users on one
network domain, but the error listed above appears when
trying to access the DB application from a user's
workstation on another domain. The user has a SQL Server
account. We have even tried to have the user run the DB
application in a smart client "trusted assembly"
environment but also get the error. What must be
configured differently and how?

A poor state employee-
Jerome



Relevant Pages

  • Re: IIS hosted object and SQL Server connection
    ... Trusted SQL Connections with ASP.NET ... process to a user who has the correct SQL Server permissions. ... > Is it possible for an IIS hosted remote object to connect to a SQL ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: Cant Connect
    ... "Login failed for user 'CHRISHARRIES\sq;'. ... trusted SQL Server connection" I think there must be something in the SQL ...
    (microsoft.public.sqlserver.connect)
  • Linked Server - Issue
    ... I add the linked server using scripts and run them using osql/isqlw. ... Reason Not associated with a Trusted SQL ...
    (microsoft.public.sqlserver.security)
  • trusted connection
    ... Not associated with a trusted SQL ... Server connection. ... do i need to put trusted connection = true in my string? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)