关于asp。net forums安装后无法浏览，报错，求救

[JavaZheng]

错误信息如下：

Server Error in '/AspNetForums' Application.
--------------------------------------------------------------------------------

Cannot resolve collation conflict for equal to operation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException: Cannot resolve collation conflict for equal to operation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteReader() +41
AspNetForums.Data.SqlDataProvider.GetSiteStatistics() +109
AspNetForums.Components.Statistics.GetSiteStatistics() +120
AspNetForums.Controls.SiteStats.InitializeSkin(Control skin) +20
AspNetForums.Controls.SkinnedForumWebControl.CreateChildControls() +24
System.Web.UI.Control.EnsureChildControls() +100
System.Web.UI.Control.PreRenderRecursiveInternal() +38
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Page.ProcessRequestMain() +1489




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

[liuvb]

iis里建虚拟目录了没有？

[rgbcn]

关于排序规则冲突的问题

==
在SQLserver AspNetForums数据库中查找Statistics_ResetTopPosters存储过程，修改此过程中的下列语句：
CREATE Table #Top500Users (
Rank int IDENTITY (1, 1) NOT NULL ,
UserName nvarchar(50)
为
CREATE Table #Top500Users (
Rank int IDENTITY (1, 1) NOT NULL ,
UserName nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS
==

以前别人帮我解答的

[rgbcn]

see
http://expert.csdn.net/Expert/topic/2263/2263961.xml?temp=.9316522