Re: Authentication problem continued

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: Connecting to SQL from a Windows Service
    ... There is probably some way to debug this, but that's deeper Windows knowledge than I can dredge up right now. ... I looked into the Event Log and found that when my service ... 1st Login succeeds. ... You can try turning on login auditing in SQL Server and then check the ...
    (microsoft.public.sqlserver.connect)
  • Re: 18456 Login failed for user NT AUTHORITYSYSTEM
    ... Associated with this is event id 17055 from MSSQLSERVER w/description 18456: Login failed for user NT ... These messages occur in bursts of of over 100 messages every 5 minutes and just flood the application event log w/entries I think what's going on is the Alert Engine is a service running under local system and is unable to connect to SQL server. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Login audit log
    ... I selected all, then I relogin, in the event log ... >> I use SQL Server 2000 and Win 2003 Server. ... >> Login audit log using Profiler, ... >> Windows Event Viewer, it only logs Windows authentications users for SQL ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Server does not exist or access denied
    ... Though I am using SQL Server Authentication I still have problems. ... This will show the login errors against the server. ... will log failed logins to the Server Event Log and SQL Server Error Log. ...
    (microsoft.public.sqlserver.setup)
  • Problem after installation
    ... I am trying to complete a installation of Sharepoint ... as a SQL server as well. ... me to login in. ... application pool it uses is not there. ...
    (microsoft.public.sharepoint.portalserver)