Installing DotNetNuke

Version: 04.04.00

Installation Status Report

00:00:00.125 - Installing Version: 4.4.0
00:00:00.359 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.828 - Installing Script: DotNetNuke.Schema.SqlDataProvider Error! (seeC:\Inetpub\wwwroot\DotNetNuke\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.log for more information)
00:00:08.843 - Installing Script: DotNetNuke.Data.SqlDataProvider Error! (seeC:\Inetpub\wwwroot\DotNetNuke\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.log for more information)
00:00:10.093 - Installing MemberRole Provider:
00:00:10.109 -   Installing Script: InstallCommon.sql
00:00:11.703 -   Installing Script: InstallMembership.sql
00:00:12.906 -   Installing Script: InstallProfile.sql
00:00:13.234 -   Installing Script: InstallRoles.sql
00:00:14.140 - Performing General Upgrades
00:00:14.750 - Loading Host Settings:
00:00:15.015 - Configuring SuperUser:
00:00:15.625 - Installing Modules:
00:00:15.656 -   Installing Module File HTML_03.03.00_Install:  Success
00:00:17.625 -   Installing Module File Links_03.03.00_Install:  Success
00:00:18.218 - Executing Additional Scripts:
00:00:18.218 -   Creating Portal: My Website
00:00:23.890 -   Successfully Installed Portal 0:
00:00:23.890 - Installing Optional Resources:

Installation Complete

Click Here To Access Your Portal

DotNetNuke.Data.log is empty.

Log File for Schema is

System.Data.SqlClient.SqlException: Must declare the scalar variable "@id".
Must declare the scalar variable "@id".
Must declare the scalar variable "@id".
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

CREATE PROCEDURE dbo.[AddSearchItemWord]
 @SearchItemID int,
 @SearchWordsID int,
 @Occurrences int

AS

DECLARE @ID int
SELECT @id = SearchItemWordID
 FROM SearchItemWord
 WHERE SearchItemID=@SearchItemID
  AND SearchWordsID=@SearchWordsID
 

IF @ID IS NULL
 BEGIN
  INSERT INTO SearchItemWord (
   [SearchItemID],
   [SearchWordsID],
   [Occurrences]
   )
  VALUES (
   @SearchItemID,
   @SearchWordsID,
   @Occurrences
   )

  SELECT SCOPE_IDENTITY()
 END
ELSE

 UPDATE SearchItemWord
  SET Occurrences = @Occurrences
  WHERE SearchItemWordID=@id
   AND Occurrences<>@Occurrences

SELECT @id

System.Data.SqlClient.SqlException: Must declare the scalar variable "@portalid".
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

CREATE procedure dbo.GetBanner

@BannerId int,
@VendorId int,
@PortalID int

as

select Banners.BannerId,
       Banners.VendorId,
       'ImageFile' = case when Files.FileName is null then Banners.ImageFile else Files.Folder + Files.FileName end,
       Banners.BannerName,
       Banners.Impressions,
       Banners.CPM,
       Banners.Views,
       Banners.ClickThroughs,
       Banners.StartDate,
       Banners.EndDate,
       'CreatedByUser' = Users.FirstName + ' ' + Users.LastName,
       Banners.CreatedDate,
       Banners.BannerTypeId,
       Banners.Description,
       Banners.GroupName,
       Banners.Criteria,
       Banners.URL,       
       Banners.Width,
       Banners.Height
FROM   Banners
INNER JOIN Vendors ON Banners.VendorId = Vendors.VendorId
LEFT OUTER JOIN Users ON Banners.CreatedByUser = Users.UserID
left outer join Files on Banners.ImageFile = 'FileId=' + convert(varchar,Files.FileID)
where  Banners.BannerId = @BannerId
and   Banners.vendorId = @VendorId
AND (Vendors.PortalId = @PortalID or (Vendors.PortalId is null and @portalid is null))

System.Data.SqlClient.SqlException: Must declare the scalar variable "@portalid".
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

CREATE PROCEDURE dbo.GetAffiliate
 @AffiliateId int,
 @VendorId int,
 @PortalID int
AS

 SELECT Affiliates.AffiliateId,
  Affiliates.VendorId,
  Affiliates.StartDate,
  Affiliates.EndDate,
  Affiliates.CPC,
  Affiliates.Clicks,
  Affiliates.CPA,
  Affiliates.Acquisitions
 FROM Affiliates
 INNER JOIN Vendors ON Affiliates.VendorId = Vendors.VendorId
 WHERE Affiliates.AffiliateId = @AffiliateId
 AND Affiliates.VendorId = @VendorId
 AND (Vendors.PortalId = @PortalID or (Vendors.PortalId is null and @portalid is null))

No it is not

It is default installation for both sqlexpress and sql2000.

Can server collation other than English be a problem?

Regards.