BugNET

Open source issue tracking & project management
Welcome to BugNET Register | Login |

BugNET Forums

 
  Forum  Support  Installation pr...  Installation fails with SELECT permission denied message
Previous Previous
 
Next Next
New Post 7/14/2008 3:02 PM
User is offline pvandervelde
2 posts
No Ranking


Installation fails with SELECT permission denied message 

Hi All

I've been trying to get BugNET (0.7.921) to install (on Windows Vista + SQL express 2005) but I'm not getting there. I've managed to solve some problems by searching the forums (thanks heaps) but this one puzzles me. I'm getting an SQL error indicating that permissions were denied for some reason (see the error log below).

I've installed SQL express 2005 and created a BugNet database with a BugNet user which has all permissions on the database (as far as I can see). The database is set to use "Latin1_General_CI_AS" as collation so I think I should have problems with case sensitivity (I'm assuming the CI means case insensitive).

 

Does anybody have any ideas on what the problem could be and how to fix it? I'd really like to try out BugNET but I'll need to get it working first ;-)

 

Thanks heaps

 

Patrick

 

 

Installing Version: 0.7.921.0
Installing Membership Provider... - 00:00:00.0019548
Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:There is already an object named 'aspnet_Setup_RestorePermissions' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:There is already an object named 'aspnet_Setup_RemoveAllRoleMembers' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:There is already an object named 'aspnet_RegisterSchemaVersion' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:Invalid object name 'dbo.aspnet_SchemaVersions'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:There is already an object named 'aspnet_CheckSchemaVersion' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:There is already an object named 'aspnet_Applications_CreateApplication' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:There is already an object named 'aspnet_UnRegisterSchemaVersion' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:There is already an object named 'aspnet_Users_CreateUser' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:There is already an object named 'aspnet_Users_DeleteUser' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:There is already an object named 'aspnet_AnyDataInTables' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallCommon.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is no user table matching the input name 'aspnet_Membership' in the current database or you do not have permission to access the table. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_CreateUser' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_GetUserByName' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_GetUserByUserId' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_GetUserByEmail' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_GetPasswordWithFormat' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_UpdateUserInfo' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_GetPassword' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_SetPassword' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_ResetPassword' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_UnlockUser' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_UpdateUser' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_ChangePasswordQuestionAndAnswer' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_GetAllUsers' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_GetNumberOfUsersOnline' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_FindUsersByName' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:There is already an object named 'aspnet_Membership_FindUsersByEmail' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:Invalid object name 'dbo.aspnet_SchemaVersions'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The SELECT permission was denied on the object 'sysusers', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysusers', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysusers', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:The role 'aspnet_Membership_BasicAccess' does not exist in the current database. The role 'aspnet_Membership_ReportingAccess' does not exist in the current database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallMembership.sql
Message:Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Membership_FullAccess', because it does not exist or you do not have permission. Cannot find the object 'vw_aspnet_Applications', because it does not exist or you do not have permission. Cannot find the object 'vw_aspnet_Users', because it does not exist or you do not have permission. Cannot find the object 'vw_aspnet_MembershipUsers', because it does not exist or you do not have permission.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:There is already an object named 'aspnet_Profile_GetProperties' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:There is already an object named 'aspnet_Profile_SetProperties' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:There is already an object named 'aspnet_Profile_DeleteProfiles' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:There is already an object named 'aspnet_Profile_DeleteInactiveProfiles' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:There is already an object named 'aspnet_Profile_GetNumberOfInactiveProfiles' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:There is already an object named 'aspnet_Profile_GetProfiles' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:Invalid object name 'dbo.aspnet_SchemaVersions'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:The SELECT permission was denied on the object 'sysusers', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysusers', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysusers', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:The role 'aspnet_Profile_BasicAccess' does not exist in the current database. The role 'aspnet_Profile_ReportingAccess' does not exist in the current database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:Cannot find the user 'aspnet_Profile_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Profile_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Profile_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Profile_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Profile_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Profile_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Profile_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Profile_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Profile_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Profile_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Profile_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Profile_FullAccess', because it does not exist or you do not have permission. Cannot find the object 'vw_aspnet_Applications', because it does not exist or you do not have permission. Cannot find the object 'vw_aspnet_Users', because it does not exist or you do not have permission. Cannot find the object 'vw_aspnet_Profiles', because it does not exist or you do not have permission.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallProfile.sql
Message:There is no user table matching the input name 'aspnet_Profile' in the current database or you do not have permission to access the table.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:There is already an object named 'aspnet_UsersInRoles_IsUserInRole' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:There is already an object named 'aspnet_UsersInRoles_GetRolesForUser' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:There is already an object named 'aspnet_Roles_CreateRole' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:There is already an object named 'aspnet_Roles_DeleteRole' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:There is already an object named 'aspnet_Roles_RoleExists' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:There is already an object named 'aspnet_UsersInRoles_AddUsersToRoles' in the database. There is already an object named 'aspnet_UsersInRoles_RemoveUsersFromRoles' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:There is already an object named 'aspnet_UsersInRoles_GetUsersInRoles' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:There is already an object named 'aspnet_UsersInRoles_FindUsersInRole' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:There is already an object named 'aspnet_Roles_GetAllRoles' in the database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:Invalid object name 'dbo.aspnet_SchemaVersions'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The SELECT permission was denied on the object 'sysusers', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysusers', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'sysusers', database 'mssqlsystemresource', schema 'sys'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:The role 'aspnet_Roles_BasicAccess' does not exist in the current database. The role 'aspnet_Roles_ReportingAccess' does not exist in the current database.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\InstallRoles.sql
Message:Cannot find the user 'aspnet_Roles_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_BasicAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_ReportingAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_FullAccess', because it does not exist or you do not have permission. Cannot find the user 'aspnet_Roles_FullAccess', because it does not exist or you do not have permission. Cannot find the object 'vw_aspnet_Applications', because it does not exist or you do not have permission. Cannot find the object 'vw_aspnet_Users', because it does not exist or you do not have permission. Cannot find the object 'vw_aspnet_Roles', because it does not exist or you do not have permission. Cannot find the object 'vw_aspnet_UsersInRoles', because it does not exist or you do not have permission.


Installing BugNET Database... - 00:00:00.7838748
Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Invalid object name 'dbo.aspnet_Users'.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.Component" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.RolePermission" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.ProjectMailBox" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.Version" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.BugAttachment" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.ProjectCustomFieldSelection" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.BugTimeEntry" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.BugComment" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.UserRoles" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.ProjectCustomFields" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.RelatedBug" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.BugNotification" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.RolePermission" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.ProjectCustomFieldValues" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.BugHistory" because it does not exist or you do not have permissions.


Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Cannot find the object "dbo.Roles" because it does not exist or you do not have permissions.


Installing BugNET Default Data... - 00:00:01.1660382
Error!

Error in file:D:\webroot\bugnet\Install\dbscripts\BugNET.Data.SqlDataProvider.sql
Message:Invalid object name 'Priority'.


Creating Administrator Account... - 00:00:01.1846088

 
New Post 7/16/2008 6:07 AM
User is offline admin
602 posts
bugnetproject.com
1st Level Poster




Re: Installation fails with SELECT permission denied message 

From the first error message I would double check the user account you are using to connect to the database.


Davin Dubeau
BugNET - Core Developer

 
New Post 7/16/2008 1:48 PM
User is offline pvandervelde
2 posts
No Ranking


Re: Installation fails with SELECT permission denied message 

Hi Davin

 

Thanks heaps for that. You were right.

Just in case somebody wants to know I had created a BugNet user which BugNET will use to access the database. This user has the following settings:

Default schema: dbo (this might be too much, but it worked ;-) )

Database role membership: db_datareader, db_datawriter, db_owner

 

Thanks again

 

Patrick

 
Previous Previous
 
Next Next
  Forum  Support  Installation pr...  Installation fails with SELECT permission denied message

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.