I am planning to build a website system (a web interface that connects to a database). I am planning to use SQL Server 2005 Trial Edition but I am not sure if I can use Visual Studio 2005 Team Suite. Is it possible to build a web based database application using Visual Stuidio 2005 Team Suite with either SQL Server 2005 Trial Edirion or Visual Studio 2005 Standard/Professional Editions?

I don't see why not. You are simply adding a connection object and it should work no matter what database brand or version you are using.