WebGuru’s Blog about Digital Life

Some steps to install the free ASP.NET open source forum:

1. First of all, of course you should download this application from http://www.yetanotherforum.net/.
2. Prepare the Microsoft SQL Express database. If you have not installed any on your servers yet, you can download it from Microsoft website for free. When you are on Microsoft Download center, remember you not only need  SQL Server 2005  Express database service, but you also need SQL Server Management Studio Express to create a initial forum admin user.
3. Create a login for your new SQL database, and then a new database Instance. With such information, including Database Name and Logon Account/Password, you can modify the yanet.config first before you start to install the forum.
4. Finally, you can run the installation from the URL of http://yourdomainname/YaNet/install/default.aspx.

I did well in the above steps, except I had a glitch in the step 4. The error message I got was the following:

Login failed … not associated with a trusted SQL server connection

First, I thought the login I created had too few privileges. Then I realized that I did not follow exactly the SQL Express installation instruction from YetAnotherForum site. Which was I did not set up the SQL server in Mixed Mode authentication mode.

Anyhow, if you have the same error messages. You can try this:

1. Open installed SQL Server Management Studio for Express
2. Select the created forum database server.
3. Right click  Server Properties (Configure)
4. On Security option tab, check “SQL Server and Windows” in “Authentication” section.

To find out why I chose YetAnotherForum, you can read my previous posts:

http://lichao.net/eblog/recommend-a-free-aspnet-c-open-source-forum-200801156.html
http://lichao.net/weblog/web-development/aspnet/86.html