By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,696 Members | 2,256 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,696 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.