error when connecting to SQLServer

I made a discovery dealing with this last night. What I found was two fold dealing with the SQL database and IIS 5.0. First thing is to "NOT" add the Forum folder under or in the same directory as your web site. Why you might ask? Becuse, IIS and SQL will try to "duke" it out over permissions and authentication. When I got my web site to the point where it could be edited and changed to what I needed without difficulty, <enter the ability to use FrontPage here>, I added the "forums" folder as a "virtual directory", this is very important because it keeps the appropriate permissions seperate. Then I created my database using SQL Server 2005 Express with the really nice add-on feature of SQL Server Express Management Studio, commomly refered to as SSMSE. You can obtain it here for free.

The management interface makes creating the database and new user much easier than in previous editions. Next thing is to make sure when you create your user for the database and connection string is to create them before you create the new database. This will give them the appropriate permissions and rights for the new user. You user needs to have these three rights or permissions, db_writer, db_reader and db_owner. Then you can edite the connection string for webwiz and proceed to run the setup script. I hope this helps, I fought with it for three weeks until I finally figured it all out.