468,296 Members | 1,266 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,296 developers. It's quick & easy.

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

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?
Nov 17 '05 #1
2 30614
Hi

http://support.microsoft.com/default...NoWebContent=1
http://support.microsoft.com/default...;en-us;Q269587
--
Best Regards
Vidar Petursson
==============================
Microsoft Internet Client & Controls MVP
==============================
"Blake Versiga" <.> wrote in message
news:Oo**************@tk2msftngp13.phx.gbl...
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?

Nov 17 '05 #2
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?
!
!
!

Nov 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Nicola Marchiori | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.