Unfortunatly the collation is not the issue for me, my db was CI to start with, and I had the same error and still continue to have errors. I have run the install from scratch using a blank db and still was not able to complete the SQL Scripts. Now I have a db with tables and no data in them. The only table that was populated seems to be Version. Portals, PortalAlais, Users, etc are all blank because the scripts did not complete. But the installer will not proceed saying either that 4.5.1 is already installed or the 4.4.0 Success error loops on install db step.

Since there does not appear to be a solution to this issue, I am going to follow the path that has worked twice before. I will install an earlier version and them upgrade to 4.5.1.

My fix was not a fix really - I installed as dbo a gave the account everything but backup rights on the database.  Install then went smooth and everything is running clean without errors (I can cleaded out the database of all priop attempts).  From the 4.5.3 Install download.

janaf123 wrote Similar problem with 4.05.05 on XP / SQL Express. Install hangs when running "Run Database Installation Scripts". For some reason, it works in Auto mode but not in Custom or Typical install mode. Other symtoms; the images are not displayed, and formatting / style sheet? is not attached during install. Seems to be some rights issue that I can not find.... I get past the test file permissions and test database connection. Any clues?

Read your post and thought that I would try the Auto mode on XP Pro/SQL2000. I'd like to think it got farther, but I still have errors and no portal. InstallWizard.aspx output is:

00:00:00.015 - Installing Version: 4.4.0
00:00:00.031 -   Executing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.156 -   Executing Script: DotNetNuke.Schema.SqlDataProvider Error! (see DotNetNuke.Schema.log for more information)
00:00:07.375 -   Executing Script: DotNetNuke.Data.SqlDataProvider Success
00:00:16.469 - Installing MemberRole Provider:
00:00:16.469 -   Executing Script: InstallCommon
00:00:17.719 -   Executing Script: InstallMembership
00:00:18.407 -   Executing Script: InstallProfile
00:00:18.578 -   Executing Script: InstallRoles
00:00:18.969 - Upgrading to Version: 4.5.5
00:00:19.063 -   Executing Script: 04.04.01.SqlDataProvider Success
00:00:19.188 -   Executing Script: 04.05.00.SqlDataProvider Error! (see 04.05.00.log for more information)
00:00:21.375 -   Executing Script: 04.05.01.SqlDataProvider Success
00:00:21.547 -   Executing Script: 04.05.02.SqlDataProvider Success
00:00:22.594 -   Executing Script: 04.05.03.SqlDataProvider Success
00:00:22.751 -   Executing Script: 04.05.04.SqlDataProvider Success
00:00:22.860 - Performing General Upgrades
00:00:23.563 - Loading Host Settings:
00:00:24.063 - Configuring SuperUser:
00:00:24.782 - Installing Modules:
00:00:24.813 - Executing Additional Scripts:
00:00:24.813 -   Creating Portal: My Website
00:00:27.829 -   Error: Error parsing Portal TemplateThe stored procedure 'dbo.dnn_GetFolderPermissionsByPortal' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.GetFolderPermissionsByPortal(Int32 PortalID) at DotNetNuke.Security.Permissions.FolderPermissionController.GetFolderPermissionsDictionary(Int32 PortalID) at DotNetNuke.Security.Permissions.FolderPermissionController.GetFolderPermissionsCollectionByFolderPath(Int32 PortalID, String Folder) at DotNetNuke.Common.Utilities.FileSystemUtils.SetFolderPermission(Int32 PortalId, Int32 FolderId, Int32 PermissionId, Int32 RoleId, Int32 UserId, String relativePath) at DotNetNuke.Entities.Portals.PortalController.ParseFolderPermissions(XmlNodeList nodeFolderPermissions, Int32 PortalID, Int32 FolderId, String folderPath) at DotNetNuke.Entities.Portals.PortalController.ParseFolders(XmlNode nodeFolders, Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.ParseTemplate(Int32 PortalId, String TemplatePath, String TemplateFile, Int32 AdministratorId, PortalTemplateModuleAction mergeTabs, Boolean IsNewPortal) at DotNetNuke.Entities.Portals.PortalController.CreatePortal(String PortalName, String FirstName, String LastName, String Username, String Password, String Email, String Description, String KeyWords, String TemplatePath, String TemplateFile, String HomeDirectory, String PortalAlias, String ServerPath, String ChildPath, Boolean IsChildPortal)
00:00:27.829 -   Portal failed to install:Error!
00:00:27.829 - Installing Optional Resources:

When I look in the schema.log file it appears to be nothing but a long series of SQL commands. There are no dates/times or anything, so it is hard to tell what happened when. The 04.05.00.log file is a little better at yielding information since it only contains one set of error messages, shown below:

System.Data.SqlClient.SqlException: Invalid column name 'UserID'.
Invalid column name 'UserID'.
Could not use view or function 'dbo.dnn_vw_FolderPermissions' because of binding errors.
   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.[dnn_GetFolderPermissionsByPortal]
 @PortalId  int
 
 AS
 
 SELECT *
 FROM dbo.dnn_vw_FolderPermissions
 WHERE  PortalID = @PortalID OR (PortalId IS NULL AND @PortalId IS NULL)

I hope this helps somebody, because I am stumped here.