CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:
Zone: > NEWSGROUP > Asp.Net Forum > general_asp.net.security Tags:
Item Type: NewsGroup Date Entered: 12/19/2004 7:31:48 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 5 Views: 25 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
6 Items, 1 Pages 1 |< << Go >> >|
djschlie
Asp.Net User
login failed for user '(null)'12/19/2004 7:31:48 AM

0/0

hi

we have just changed our server from win2000 to new server running win 2003,
now, everytime i run the website i get the following error:

Login failed for user '(null)' Reason: not associated with a trusted sql server connection

my connection string is:

"server=servername; database=testdb; user id=user; password=password; trusted_connection=true"


the website is running on seperate server to the sql server, and worked fine on the old server (2000)

i have enabled impersonation

can anyone help me?
bdesmond
Asp.Net User
Re: login failed for user '(null)'12/19/2004 7:51:08 AM

0/0

Hi there,

If you get rid of the trusted_Connection=true, you should be good to go. :)
--Brian Desmond
Windows Server MVP - Directory Services
http://www.briandesmond.com
djschlie
Asp.Net User
Re: login failed for user '(null)'12/19/2004 8:24:33 AM

0/0

thanks for your answer bdesmond

is there a way to do it using the trusted_connection = true? why should i need to change this if it worked fine using the old sql server?
djschlie
Asp.Net User
Re: login failed for user '(null)'12/19/2004 9:07:16 AM

0/0

more info: we have the web server on a differnet domain to our sql server, would this be causing problems with impersonation?

have tried setting up the anonymous access user on the sql server, but this hasnt worked
bdesmet
Asp.Net User
Re: login failed for user '(null)'12/19/2004 3:54:46 PM

0/0

Impersonation has no impact if you're using SQL authentication as bdesmond suggested (get rid of the trusted_connection property and just leave the uid and pwd flags in the connection string). This is wht we call a trusted subsystem, all logins on the presentation tier (ASP.NET in this case) are using the same SQL security context behind the scenes (i.e. as SQL Server account). Domains do not have impact at all on this (there is only impact if you're using Windows integrated authentication in SQL Server). So, if you have user "user" with password "password" on your databaseserver, it should work fine.
Bart De Smet [MVP]



Visit www.msdn.be, www.bartdesmet.net
djschlie
Asp.Net User
Re: login failed for user '(null)'12/21/2004 12:00:04 AM

0/0

thankyou for the help, you were right:) however i have another issue:

have removed trusted_connection = true, and can now access the site internally, however when tried to access the site externally, login screen comes up

???

6 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Professional DotNetNuke 4: Open Source Web Application Framework for ASP.NET 2.0 Authors: Shaun Walker, Joe Brinkman, Bruce Hopkins, Scott McCulloch, Patrick J. Santry, Chris Paterra, Scott Willhite, Dan Caron, Pages: 517, Published: 2006
Hacking Exposed Windows Server 2003: Windows Server 2003 Authors: Joel Scambray, Stuart McClure, Pages: 541, Published: 2003
Mastering Dreamweaver MX Databases Authors: Susan Sales Harkins, Bryan Chamberlain, Darren McGee, Pages: 707, Published: 2003
Pro InfoPath 2007 Authors: Philo Janus, Pages: 278, Published: 2007
SQL Server Security: covers SQL Server 2000 and SQL Server 7 security Authors: Chip Andrews, David Litchfield, David (David William) Litchfield, Bill Grindlay, Pages: 352, Published: 2003
Professional Windows PowerShell Authors: Andrew Watt, Pages: 531, Published: 2007
Beginning SQL Server 2005 Administration Authors: Dan Wood, Chris Leiter, Paul Turley, Pages: 574, Published: 2006
Oracle Application Server 10g Administration Handbook: Administration Handbook Authors: John Garmany, Donald K. Burleson, Pages: 408, Published: 2004
Beginning Visual Basic 2005 Authors: Thearon Willis, Bryan Newsome, Pages: 799, Published: 2006
The Web Application Hacker's Handbook: Discovering and Exploiting Security Flaws Authors: Dafydd Stuttard, Marcus Pinto, Pages: 736, Published: 2008

Web:
SQL SERVER - Fix : Error: 18452 Login failed for user ‘(null ... [Microsoft][ODBC SQL Server Driver][SQL Servr] login failed for user (null). Reason Not asscociated with a trusted SQL Servr Connection. ...
You may receive the error "Login failed for user '(null)'. Reason ... Your detailed, step-by-step instructions saved my application :) It has been two days now without any "Login failed for user '(null)'" errors, whereas they ...
PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User ... [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Back to the top ...
Intermittent - Login failed for user '(null)' [Archive] - dBforums [Archive] Intermittent - Login failed for user '(null)' Microsoft SQL Server.
RE: Login failed for user '(null)'. used at signon to authenticate in SQL Server. ... connect the remote SQL Server database), is there any other data accessing .
Why do I get "Login failed for user '\'."? KB #306586 PRB: Troubleshooting Error 80004005 "Login Failed" in ASP KB #307002 PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User '(Null)'" ...
Login failed for user '(null)'. Reason: Not associated with a ... Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Thread Starter: IanMarritt Started: 24 Oct 2006 4:32 PM UTC ...
You may receive the error "Login failed for user '(null)'. Reason ... re: You may receive the error "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" - Part II ...
microsoft.public.inetserver.iis.security: Re: Login failed for ... But when I do backwards, I get > Login failed for user '(null)' and > Out-of- process+ISAPI+extension+request+failed. 503 in IIS. ...
Login failed for user '(null)'. Reason: Not associated with a ... When i connect my client VC++ application to SqlServer2000 i am getting this error "Login failed for user '(null)'. ...




Search This Site:










website auto builds

web mail

getting selected index of dropdownlist

urgent !! forcing page refresh

installed fine but it won't run

c# treeview issues

stdole

having a problem with the personal website template

search engine friendly re-direct

check ssl expiration date remotely

please help! how can you cut and paste table data from a website?

default text values from the code in an asp textbox problem

loginn

export asp:table to excel

unix and mac browers

where are the cookies?

dnn 3.1.1 compatibility with sql server 2005 ctp

help, easy id assignment for queries

what is up with vs2005 express

module creation problems

bc30451: name 'addpanel' is not declared.

createuserwizard - continuedestinationpageurl

two subdomains

dynamic user controls as objects

upgrade to team edition problems

profile for department field and report

data section in the toolbox???

how do i assign users to roles?

domain and user group authorization

2.0 - mac / other browser compatibility
 
All Times Are GMT