ASP.NET Newbie = Authenication

Hi all!

I'm just a newbie with ASP.NET, XP Professional and VB.NET.

Here is my problem.

I was working with the movies on MSDN.Microsoft.com in the visual basic section under "VB at the Movies". In working with the data access ones, I found I can use "trusted_connection=true" in my connection string to access data in SQL Server 7 (Desktop Developer edition) and it works fine for a windows application. I try the same thing in a web form application and it doesn't work. I get a Logon Failed for User error.

If I "specify trusted_connection=false;user=sa", then it works fine.

I'm just trying to go by the examples on msdn and the "trusted_connection=true" is what they use and it works.

Can somebody tell me what's wrong? As far as I can tell, it's something to do with IIS, but I'm not too familar with it either.

Also, while I'm at it, what is best way in terms of security to access data? I know I need to do some more research, but it seems a lot of the info is still to advanced for me.

Thanks very much!
JB

I think I found the answer in this thread about the same problem

The thread made a reference to a HOW TO article about configuring SQL Server and it looks like the only thing I have to do is add a new database User called <DomainName\ASPNET> since that's the account created by ASP.NET.

I would still appreciate any info anyone can give me. The biggest thing is if the SQL Server was on a different machine than the IIS server.

I'm still doing some reading and some of the info is just a bit confusing, but I'm wading through.

Thanks,
JB