Re: Authentication problem continued

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: Cant Connect
    ... Then it's likely the authentication settings on the IIS side ... Try adding the IUSR account as a login in SQL Server ... > Cn.open CnStr ...
    (microsoft.public.sqlserver.connect)
  • Re:changing sa password / login
    ... authentication and it worked. ... >I think you might have made changes to SQL Server ... >Authentication" can not recognize SA login which is SQL ... >configuration to use mixed authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Security question ..
    ... > If you use NT authentication, a user's permissions to a database are ... Your assertion that a user's permissions are independent of the application ... Even using Access and "exploring" will require an ODBC login to SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re:changing sa password / login
    ... I think you might have made changes to SQL Server ... to make was using Mixed Authentication which will ... Authentication" can not recognize SA login which is SQL ... configuration to use mixed authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Kerberos / Authentication to SQL2K
    ... use Windows integrated security for database access. ... That SQL Server be running on the same computer as IIS. ... > authentication until I switched on impersonation either. ... > When set up on my web server however, I get the "Login failed for user ...
    (microsoft.public.dotnet.framework.aspnet)
Loading