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: SBS2008 install from my MS Action Pack
    ... licenses as needed for internal use up to the licensing limits of MAPs ... since he has SBS standard (NOT premium, ... server, and SQL Server standard, can he purchase SBS Premium CALs ...
    (microsoft.public.windows.server.sbs)
  • 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: SBS2008 install from my MS Action Pack
    ... So the question is, since he has SBS standard (NOT premium, another win2k8 standard server, and SQL Server standard, can he purchase SBS Premium CALs and be covered? ... An additionally purchased SBS Premium CAL would cover access to SBS and the additional Win2k8 server, but would it cover access to the separately licensed SQL Server Std? ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS2008 install from my MS Action Pack
    ... MAPs they told me I can just buy CALS to extend it, ... standard (NOT premium, another win2k8 standard server, and SQL Server ...
    (microsoft.public.windows.server.sbs)
  • 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)