Hi Smith,

I guess your application is an ASP.Net application as it uses a webconfig
file? If so, Windows Authentication may not work for you in this case
because when you use the Windows Authentication as the authentication mode
for your SQL Server, (I don't know where you host your web application but I
assume it's going to be hosted by a hosting company) your web application
will try to connect to your SQL Server with a not trusted user account which
will needed to be authenticated by the AD or something. And as it's a not
trusted user, it'll fail.

In such cases you should use SQL Authentication. And your connection string
would be something like "data source=localhost; initial catalog=mydb;
uid=testuser; pwd=****"

Windows Authentication is very useful in domain environments where there is
trust relationship between clients and server and your clients are members
of domain.

--
Ekrem Önsoy


"Smith" <naissani (AT) hotmail (DOT) co> wrote