Hi I verified the db an the collation is Latin1_General_CI_AI
other hand,
I try to install is manually and I note the following
Install/dbscripts/InstallCommon.sql
Install/dbscripts/InstallMembership.sql
Install/dbscripts/InstallProfile.sql
Install/dbscripts/InstallRoles.sql
Install/dbscripts/BugNET.Schema.SqlDataProvider.sql
When I call the BugNET.Schema.SqlDataProvider.sql the following error are generate.
Creating [dbo].[Priority]
Creating primary key [PK__Priority__07F6335A] on [dbo].[Priority]
Creating [dbo].[BugAttachment]
Creating primary key [PK__BugAttachment__1273C1CD] on [dbo].[BugAttachment]
Creating [dbo].[UserProjects]
Creating primary key [PK_UserProjects_1] on [dbo].[UserProjects]
Creating [dbo].[Permission]
Creating primary key [PK_Permission] on [dbo].[Permission]
Creating [dbo].[Roles]
Creating primary key [PK_Roles] on [dbo].[Roles]
Creating [dbo].[RolePermission]
Creating primary key [PK_RolePermission] on [dbo].[RolePermission]
Creating [dbo].[ProjectCustomFieldValues]
Creating primary key [PK_ProjectCustomFieldValues] on [dbo].[ProjectCustomFieldValues]
Creating [dbo].[BugNet_CustomField_SaveCustomFieldValue]
Creating [dbo].[BugTimeEntry]
Creating primary key [PK_BugTimeEntry] on [dbo].[BugTimeEntry]
Creating [dbo].[BugNet_Role_RoleHasPermission]
Creating [dbo].[BugComment]
Creating primary key [PK__BugComment__164452B1] on [dbo].[BugComment]
Creating [dbo].[Status]
Creating primary key [PK__Status__023D5A04] on [dbo].[Status]
Creating [dbo].[UserRoles]
Creating primary key [PK_UserRoles] on [dbo].[UserRoles]
Creating [dbo].[Version]
Creating primary key [PK__Version__0425A276] on [dbo].[Version]
Creating [dbo].[ProjectMailBox]
Creating primary key [PK_ProjectMailBox] on [dbo].[ProjectMailBox]
Creating [dbo].[Resolution]
Creating primary key [PK__Resolution__00551192] on [dbo].[Resolution]
Creating [dbo].[BugNet_Priority_GetAllPriorities]
Creating [dbo].[BugNet_Role_GetRolesByProject]
Creating [dbo].[BugNet_Comment_DeleteComment]
Creating [dbo].[RelatedBug]
Creating primary key [PK_BugRelation] on [dbo].[RelatedBug]
Creating [dbo].[Log]
Creating [dbo].[BugNet_ApplicationLog_GetLogCount]
Creating [dbo].[BugNet_Permission_GetAllPermissions]
Creating [dbo].[ProjectCustomFields]
Creating primary key [PK_ProjectCustomFields] on [dbo].[ProjectCustomFields]
Creating [dbo].[BugNet_CustomField_CreateNewCustomField]
Msg 137, Level 15, State 2, Procedure BugNet_CustomField_CreateNewCustomField, Line 9
Must declare the scalar variable "@ProjectID".
(1 row(s) affected)
Creating [dbo].[BugNet_Role_CreateNewRole]
Creating [dbo].[HostSettings]
Creating primary key [PK_HostSettings] on [dbo].[HostSettings]
Creating [dbo].[BugNet_HostSettings_GetHostSettings]
Creating [dbo].[BugNet_Version_GetVersionById]
Creating [dbo].[BugNotification]
Creating primary key [PK_BugNotification] on [dbo].[BugNotification]
Creating [dbo].[BugNet_TimeEntry_DeleteTimeEntry]
Creating [dbo].[BugNet_Priority_GetPriorityById]
Creating [dbo].[BugNet_Role_UpdateRole]
Creating [dbo].[Type]
Creating primary key [PK_Type] on [dbo].[Type]
Creating [dbo].[BugNet_Type_GetTypeById]
Creating [dbo].[BugNet_Role_RoleExists]
Creating [dbo].[BugNet_Version_Update]
Creating [dbo].[BugNet_Permission_DeleteRolePermission]
Creating [dbo].[BugNet_Attachment_DeleteAttachment]
Creating [dbo].[BugHistory]
Creating primary key [PK__BugHistory__182C9B23] on [dbo].[BugHistory]
Creating [dbo].[BugNet_Role_GetAllRoles]
Creating [dbo].[ProjectCustomFieldType]
Creating primary key [PK_ProjectCustomFieldType] on [dbo].[ProjectCustomFieldType]
Creating [dbo].[BugNet_CustomField_GetCustomFieldsByProjectId]
Creating [dbo].[BugNet_Version_GetVersionByProjectId]
Creating [dbo].[BugNet_Status_GetAllStatus]
Creating [dbo].[BugNet_CustomField_DeleteCustomField]
Creating [dbo].[BugNet_Permission_GetPermissionsByRole]
Creating [dbo].[BugNet_Type_GetAllTypes]
Creating [dbo].[BugNet_Project_DeleteProjectMailbox]
Creating [dbo].[BugNet_Role_GetRoleById]
Creating [dbo].[BugNet_Status_GetStatusById]
Creating [dbo].[BugNet_Resolution_GetResolutionById]
Creating [dbo].[BugNet_Permission_AddRolePermission]
Creating [dbo].[BugNet_Role_DeleteRole]
Creating [dbo].[BugNet_RelatedBug_DeleteRelatedBug]
Creating [dbo].[BugNet_HostSettings_UpdateHostSetting]
Creating [dbo].[BugNet_RelatedBug_CreateNewRelatedBug]
Creating [dbo].[BugNet_Resolution_GetAllResolutions]
Creating [dbo].[BugNet_ApplicationLog_ClearLog]
Creating [dbo].[BugNet_Version_CreateNewVersion]
Creating [dbo].[BugNet_ApplicationLog_GetLog]
Creating [dbo].[Project]
Creating primary key [PK__Product__1DE57479] on [dbo].[Project]
Creating [dbo].[Bug]
Creating primary key [PK__Bug__145C0A3F] on [dbo].[Bug]
Creating [dbo].[Component]
Creating primary key [PK__Component__09DE7BCC] on [dbo].[Component]
Creating [dbo].[BugNet_Component_GetComponentsByProjectId]
Creating [dbo].[BugNet_Attachment_GetAttachmentsByBugId]
Creating [dbo].[BugNet_Project_GetProjectsByUserName]
Creating [dbo].[BugNet_Comment_CreateNewComment]
Creating [dbo].[BugNet_Permission_GetRolePermission]
Creating [dbo].[BugsView]
Msg 208, Level 16, State 1, Procedure BugsView, Line 5
Invalid object name 'dbo.Priority'.
(1 row(s) affected)
Creating [dbo].[BugNet_Bug_GetRecentlyAddedBugsByProject]
Creating [dbo].[BugNet_Bug_GetBugComponentCountByProject]
Creating [dbo].[BugNet_Bug_GetBugById]
Creating [dbo].[BugNet_Bug_GetBugsByCriteria]
Creating [dbo].[BugNet_TimeEntry_GetWorkReportByProjectId]
Creating [dbo].[BugNet_Bug_CreateNewBug]
Creating [dbo].[BugNet_Project_AddUserToProject]
Creating [dbo].[BugNet_Bug_GetBugStatusCountByProject]
Creating [dbo].[BugNet_Role_RemoveUserFromRole]
Creating [dbo].[BugNet_Attachment_CreateNewAttachment]
Creating [dbo].[BugNet_Project_GetProjectByMailbox]
Creating [dbo].[BugNet_Role_AddUserToRole]
Creating [dbo].[BugNet_Project_CreateNewProject]
Creating [dbo].[BugNet_Project_GetPublicProjects]
Creating [dbo].[BugNet_RelatedBug_GetRelatedBugsByBugId]
Creating [dbo].[BugNet_Bug_GetBugUserCountByProject]
Creating [dbo].[BugNet_Role_GetRolesByUser]
Creating [dbo].[ProjectCustomFieldSelection]
Creating primary key [PK_ProjectCustomFieldSelection] on [dbo].[ProjectCustomFieldSelection]
Creating [dbo].[BugNet_CustomFieldSelection_Update]
Creating [dbo].[BugNet_Project_CloneProject]
Msg 137, Level 15, State 2, Procedure BugNet_Project_CloneProject, Line 55
Must declare the scalar variable "@ProjectID".
(1 row(s) affected)
Creating [dbo].[BugNet_TimeEntry_GetProjectWorkerWorkReport]
Creating [dbo].[BugNet_Role_IsUserInRole]
Creating [dbo].[BugNet_Project_GetProjectMembers]
Creating [dbo].[BugNet_TimeEntry_CreateNewTimeEntry]
Msg 137, Level 15, State 2, Procedure BugNet_TimeEntry_CreateNewTimeEntry, Line 27
Must declare the scalar variable "@BugCommentID".
(1 row(s) affected)
Creating [dbo].[BugNet_Project_CreateProjectMailbox]
Msg 137, Level 15, State 2, Procedure BugNet_Project_CreateProjectMailbox, Line 24
Must declare the scalar variable "@IssueTypeId".
(1 row(s) affected)
Creating [dbo].[BugNet_BugNotification_CreateNewBugNotification]
Creating [dbo].[BugNet_Bug_GetBugVersionCountByProject]
Creating [dbo].[BugNet_Role_GetProjectRolesByUser]
Creating [dbo].[BugNet_CustomField_GetCustomFieldsByBugId]
Creating [dbo].[BugNet_Bug_UpdateBug]
Creating [dbo].[BugNet_BugNotification_GetBugNotificationsByBugId]
Creating [dbo].[BugNet_CustomFieldSelection_GetCustomFieldSelectionsByCustomFieldId]
Creating [dbo].[BugNet_BugNotification_DeleteBugNotification]
Creating [dbo].[BugNet_Component_GetComponentById]
Creating [dbo].[BugNet_Project_RemoveUserFromProject]
Creating [dbo].[BugNet_Attachment_GetAttachmentById]
Creating [dbo].[BugNet_TimeEntry_GetWorkReportByBugId]
Creating [dbo].[BugNet_Project_UpdateProject]
Creating [dbo].[BugNet_Project_GetProjectByCode]
Creating [dbo].[BugNet_Bug_GetMonitoredBugsByUser]
Creating [dbo].[BugNet_Component_UpdateComponent]
Creating [dbo].[BugNet_Bug_GetRoadMapProgress]
Creating [dbo].[BugNet_History_CreateNewHistory]
Creating [dbo].[BugNet_Version_DeleteVersion]
Creating [dbo].[BugNet_History_GetHistoryByBugId]
Creating [dbo].[BugNet_Project_GetAllProjects]
Creating [dbo].[BugNet_Project_DeleteProject]
Creating [dbo].[BugNet_Project_IsUserProjectMember]
Creating [dbo].[BugNet_Comment_UpdateComment]
Creating [dbo].[BugNet_Component_GetRootComponentsByProjectId]
Creating [dbo].[BugNet_Project_GetMailboxByProjectId]
Creating [dbo].[BugNet_Project_GetProjectById]
Creating [dbo].[BugNet_Comment_GetCommentById]
Creating [dbo].[BugNet_CustomFieldSelection_GetCustomFieldSelection]
Creating [dbo].[BugNet_Bug_GetBugTypeCountByProject]
Creating [dbo].[BugNet_Bug_GetBugPriorityCountByProject]
Creating [dbo].[BugNet_Bug_Delete]
Creating [dbo].[BugNet_CustomFieldSelection_DeleteCustomFieldSelection]
Creating [dbo].[BugNet_Bug_GetBugsByProjectId]
Creating [dbo].[BugNet_Bug_GetBugFixedInVersionCountByProject]
Creating [dbo].[BugNet_Bug_GetChangeLog]
Creating [dbo].[BugNet_Component_GetChildComponentsByComponentId]
Creating [dbo].[BugNet_Component_DeleteComponent]
Creating [dbo].[BugNet_CustomFieldSelection_CreateNewCustomFieldSelection]
Creating [dbo].[BugNet_Bug_GetBugUnassignedCountByProject]
Creating [dbo].[BugNet_Component_CreateNewComponent]
Creating [dbo].[BugNet_TimeEntry_GetWorkerOverallWorkReportByWorkerId]
Creating [dbo].[BugNet_Bug_GetRoadMap]
Creating [dbo].[BugNet_Comment_GetCommentsByBugId]
Adding foreign keys to [dbo].[Component]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Component" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[RolePermission]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.RolePermission" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[ProjectMailBox]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.ProjectMailBox" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[Version]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Version" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[BugAttachment]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.BugAttachment" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[ProjectCustomFieldSelection]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.ProjectCustomFieldSelection" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[BugTimeEntry]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.BugTimeEntry" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[BugComment]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.BugComment" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[UserRoles]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.UserRoles" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[ProjectCustomFields]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.ProjectCustomFields" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[RelatedBug]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.RelatedBug" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[BugNotification]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.BugNotification" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[RolePermission]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.RolePermission" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[ProjectCustomFieldValues]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.ProjectCustomFieldValues" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[BugHistory]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.BugHistory" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[Roles]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Roles" because it does not exist or you do not have permissions.
(1 row(s) affected)
The database update failed