Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Reply
Thread Tools

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

 
 
Blake Versiga
Guest
Posts: n/a
 
      07-08-2003
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?


 
Reply With Quote
 
 
 
 
Vidar Petursson
Guest
Posts: n/a
 
      07-08-2003
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:OoP3O$(E-Mail Removed)...
> 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?
>
>



 
Reply With Quote
 
 
 
 
Yan-Hong Huang[MSFT]
Guest
Posts: n/a
 
      07-09-2003
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: <OoP3O$(E-Mail Removed)>
!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?
!
!
!

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Login failed for user ''. The user is not associated with a trusted SQL Server connection. eruth ASP .Net 4 10-30-2007 11:22 AM
Error:Login failed for user ''. The user is not associated with a trusted SQL Server connection. CFTK ASP .Net 5 01-09-2007 10:51 AM
Login failed for user ''. The user is not associated with a trusted SQL Server connection. Dennis ASP .Net 0 06-26-2006 03:55 PM
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection Frederik ASP .Net 2 11-26-2003 04:01 AM
aspx - Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection Frederik ASP .Net 0 11-25-2003 09:08 PM



Advertisments