Re: Authentication problem continued

Sure Gabriel. This is the exception I get if on my test box if I haven't run
the app on my development box very recently:

Exception Text:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'NT AUTHORITY\ANONYMOUS LOGON'.

Source Error:


Line 209: If SqlConnection2.State <> ConnectionState.Open Then
Line 210: SqlConnection2.ConnectionString = scon
Line 211: SqlConnection2.Open()
Line 212: End If
Line 213: com.Connection = SqlConnection2

Source File: c:\inetpub\wwwroot\ClarkCategory\StartFrm1.aspx.vb Line: 211

Does this have anything to do with the double hop problem?

S

"Gabriel Lozano-Morán" <abuse@xxxxxxxxxxxxxxx> wrote in message
news:uY8DqA8HHHA.784@xxxxxxxxxxxxxxxxxxxxxxx
Can you post the exact exception message please?

Gabriel

"SAL" <SAL_@xxxxxxxx> wrote in message
news:u2MXJ17HHHA.3312@xxxxxxxxxxxxxxxxxxxxxxx
Yeah, I'm not seeing any logs that seem helpful in the event viewer.
However, the line that causes the login failure is where I try to open
the connection to SQL Server.
If I take the impersonate="true"
line out of the web.config file, I can no longer log in on my development
box either.

S
"Gabriel Lozano-Morán" <abuse@xxxxxxxxxxxxxxx> wrote in message
news:OhhzKp7HHHA.3312@xxxxxxxxxxxxxxxxxxxxxxx
What other account might be being used to set the security context for
the application pool? I'm not sure about this part.

Login failures are logged to the Application event log therefore try to
reconnect and then look at the event log for "login failed" messages.

Gabriel Lozano-Morán
http://www.pointerx.net


"SAL" <SAL_@xxxxxxxx> wrote in message
news:uM6Zz36HHHA.1008@xxxxxxxxxxxxxxxxxxxxxxx
Gabriel,
thank you for your reply.

I have a SQL Server login established now and I can log in on my
development machine but I'm getting the Anonymous login failure on my
test box.

my machinename\ASPNET is a user of the database and is a user for the
server, it looks like to me.
What other account might be being used to set the security context for
the application pool? I'm not sure about this part.

S

"Gabriel Lozano-Morán" <abuse@xxxxxxxxxxxxxxx> wrote in message
news:u7E0Lb6HHHA.1264@xxxxxxxxxxxxxxxxxxxxxxx
Going by your input there could be 2 problems that I can think off

1) SQL Server is configured for Windows Authentication only and not
mixed authentication

2) The account used to set the security context for the application
pool of your web site has no access to the other box' SQL Server

Gabriel Lozano-Morán
http://www.pointerx.net

"SAL" <SAL_@xxxxxxxx> wrote in message
news:ur%23QOK6HHHA.1468@xxxxxxxxxxxxxxxxxxxxxxx
Hello,
I'm still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/message_view-2.aspx?thread_id=72204

and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />

Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"

I pass in my user name and password as:

User Id=me;Password=mypassword

When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI

I get logged in, but only on my developement machine and not another
box.

When the user name and password is passed in the connection string I
get the login failed for User Id=me

I'm the dbo of this sql server database so I should be able to log
in. However, I need to be able to access this web page from machines
other than my development box also.

Can anyone help me with this? Thanks

S













.

Relevant Pages

  • Re: SqlConnection and DB connection failures detection
    ... | Now question - after performing insert query I'm closing connection, ... | but my process still exists in SQL Server Activity Monitor (even if i ... | close my app) with "Sleeping" status. ... Authentication is all about security, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Authentication problem continued
    ... SQL Server is configured for Windows Authentication only and not mixed ... I'm still having trouble getting my app to authenticate correctly. ... but only on my developement machine and not another box. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL Errors in Stored Procedures
    ... T-SQL / SQL Server currently have no way of doing this. ... the app & SQL Server to provide such functionality. ... executes a stored procedure to insert some records. ... VB.NET app as an exception. ...
    (microsoft.public.sqlserver.programming)
  • Re: I dont want to re-invent the Login/Login Wheel - Help with utilities
    ... In the case of AS.NET app, being hosted by ISP, it is very likely the users are not windows domain user. ... the membership provider uses SQL Server or SQL Server Express. ... Both Windows authentication and authorization wolud be be fine if we wanted the world to have access to our application data, but not very intuitive for maintaining integrity over our data. ...
    (microsoft.public.vstudio.general)
  • Re: ASP.NET 2.0 - a newbie question
    ... the exception can be identified using the exception stack trace below. ... established connection failed because connected host has failed to ... connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& ... Microsoft SQL Server? ...
    (microsoft.public.dotnet.framework.aspnet)