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

[Blake Versiga]

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?

 

[Vidar Petursson]

Hi

http://support.microsoft.com/defaul...port/kb/articles/Q307/0/02.asp&NoWebContent=1
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269587


--
Best Regards
Vidar Petursson
==============================
Microsoft Internet Client & Controls MVP
==============================

 

[Yan-Hong Huang[MSFT]]

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: <[email protected]>
!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!tk2msftngp13.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?
!
!
!