Authentication problem continued



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

  • Getting error error: 26 - Error Locating Server/Instance Specified
    ... I have a strange problem. ... SQL Server. ... When debugging on developement machine everything is working ... connection string and I get this error only on one site. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Authentication problem continued
    ... SQL Server is configured for Windows Authentication only and not mixed ... but only on my developement machine and not another box. ... When the user name and password is passed in the connection string I get ...
    (microsoft.public.dotnet.framework.aspnet)

Loading