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

From: Rudy (Rudy_at_discussions.microsoft.com)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 10:27:01 -0800

Hello all!
I have been reading alot of post on this. I have doubled checked my
permissions, and tried everything else, still no luck. Here is the setup.
I'm running SQL 2000 on two machines, one developer edition, one standard.
My develope is on computer "A" which is also where I have Visual Studio
loaded, and do all my programming and what not. I just added a server, and
built a domain network. I also just got SQL standard and that is loaded on
server, running windows 2000 server.
I can make connection thrrough enterprise manager, I have both servers
registered. I moved the "MMG IMS" database from my developer to my standard
SQL. Basicly for troubleshooting, I also have tried using the sa Login,
change the password for that login. I origianly used windows login, but now
I'm trying everything to get this to work.
The problem is when I run my asp.net website without debugging i get the
following.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.

Source Error:

Line 141: 'Fills dataset from Midwesy in SQl
Line 142: Public Sub FillDataSet(ByVal dSet As dsMMMGIms)
Line 143: SqlDataAdapter1.Fill(dSet)
Line 144:
Line 145: End Sub
 

Source File: c:\inetpub\wwwroot\mmg ims\Component1.vb Line: 143
Line 143 is in red and stated as a problem. My app builds ok. I am new at
this, any help on this would be great!

Thanks, Rudy

Relevant Pages

  • Re: SQL User SID format?
    ... When you move databases to another server, you can remap users to logins ... capability to remap a user to a login with new ALTER USER syntax - I ... The new ALTER USER syntax works for remapping both SQL and Windows ... this means you already have access to a SID from the syslogins catalog; ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2000 Replication Agents Credentials
    ... the snapshot agent IS using sql login to connect to the ... The pull distribution agent IS using sql ... Do you know where SQL Server 2000 saves the sql ...
    (microsoft.public.sqlserver.replication)
  • Re: Can you update/process AS2005 cube with AMO and SQL authentica
    ... We have cases where the AS server and the Data Source server reside on 2 ... The data source is properly secured using SQL Server ... login and no serious client will accept the login with no password. ...
    (microsoft.public.sqlserver.olap)
  • Re: Sharepoint Error: Cannot connect to the configuration database error
    ... It looks like you have a standard version with only have MSDE ... When you go to START/PROGRAMS do you see a SQL Server reference? ... full SQL CD you can also install the tools on your SBS. ...
    (microsoft.public.windows.server.sbs)