Hello Blake,
I have some suggestions:
1) Post your connection string here. :)
2) Double check the security of your SQL server to make sure that whether
it supports windows intrgrated authentication and sql server
authentication.
3) Use SQL server profiler to audit all the login action to see which login
action failed.
If the root cause still can't be found, please post here. Thanks.
Best regards,
yhhuang
VS.NET, Visual C++
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
Got .Net?
http://www.gotdotnet.com
--------------------
!From: "Blake Versiga" <.>
!Subject: Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.
!Date: Tue, 8 Jul 2003 07:51:57 -0500
!Lines: 20
!X-Priority: 3
!X-MSMail-Priority: Normal
!X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
!X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
!Message-ID: <Oo**************@tk2msftngp13.phx.gbl>
!Newsgroups: microsoft.public.dotnet.framework.aspnet
!NNTP-Posting-Host: aux-217-3-232.dallas.net 209.217.3.232
!Path: cpmsftngxa09.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
!Xref: cpmsftngxa09.phx.gbl microsoft.public.dotnet.framework.aspnet:32965
!X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
!
!I am pulling my hair out.....
!I am trying to put a bound data grid on a webform...
!
!I have 4 data connections in my server explorer, all of which connect
!successfully. But when I run the web page I get the error:
!
!Login failed for user '(null)'. Reason: Not associated with a trusted SQL
!Server connection.
!
!I use a connection string in my application in several other pages with no
!problem and tried to create a connection with that string (which does not
!use integerated security). And again it worked in the server explorer but
!not in the application.
!
!1) How can I make a server TRUSTED?
!
!It seems the only way to have a bound controls is to have a trusted
!connection to a server. Is that correct?
!
!
!