Sorry I posted about this in another thread but can't seem to update or add a post in the forum at the moment so here goes:
http://www.dnnsoftware.com/forums/forumid/108/thre...

Ok so I'm still struggling with this issue. Tried to install a fresh 8.0.3 site but it fails at 18% with:

[ERROR] DotNetNuke.Services.Upgrade.Upgrade System.Data.SqlClient.SqlException (0x80131904): Cannot find the object 'aspnet_Membership_GetUserByUserId', because it does not exist or you do not have permission.

I checked the web.config when I got the error and see the connection string was missing the ; after the password again like the other times this has happened. Not sure why it gets deleted during the install process?

I looked at the database and it seems all the tables and stored procs are there but when I look into the Users table it is empty so it seems that when I hit install it doesn't write any of the host account info into the database.

The site was in its own App Pool with no limits that would cause a recycle during the install.

Here is the full error I get during the installation (sorry its so long):

The product is being installed. Thanks for your patience...

0:00 Minutes | 18% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): Cannot find the object 'aspnet_Membership_GetUserByUserId', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_GetUserByName', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_GetUserByEmail', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_GetPassword', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_GetPasswordWithFormat', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_UpdateUserInfo', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_GetNumberOfUsersOnline', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_CheckSchemaVersion', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_RegisterSchemaVersion', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_UnRegisterSchemaVersion', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_GetUserByUserId', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_GetUserByName', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_GetUserByEmail', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_GetAllUsers', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_GetNumberOfUsersOnline', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_FindUsersByName', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_FindUsersByEmail', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_CheckSchemaVersion', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_RegisterSchemaVersion', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_UnRegisterSchemaVersion', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Users_DeleteUser', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_CreateUser', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_SetPassword', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_ResetPassword', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_UpdateUser', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_ChangePasswordQuestionAndAnswer', because it does not exist or you do not have permission.

Cannot find the object 'aspnet_Membership_UnlockUser', 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.

Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)

ClientConnectionId:8d2d67bf-742f-4f8d-99f2-db51c11c8637

Error Number:15151,State:1,Class:16

--

--Stored Procedure rights for BasicAcess

--

GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByUserId TO aspnet_Membership_BasicAccess

GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByName TO aspnet_Membership_BasicAccess

GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByEmail TO aspnet_Membership_BasicAccess

GRANT EXECUTE ON dbo.aspnet_Membership_GetPassword TO aspnet_Membership_BasicAccess

GRANT EXECUTE ON dbo.aspnet_Membership_GetPasswordWithFormat TO aspnet_Membership_BasicAccess

GRANT EXECUTE ON dbo.aspnet_Membership_UpdateUserInfo TO aspnet_Membership_BasicAccess

GRANT EXECUTE ON dbo.aspnet_Membership_GetNumberOfUsersOnline TO aspnet_Membership_BasicAccess

GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO aspnet_Membership_BasicAccess

GRANT EXECUTE ON dbo.aspnet_RegisterSchemaVersion TO aspnet_Membership_BasicAccess

GRANT EXECUTE ON dbo.aspnet_UnRegisterSchemaVersion TO aspnet_Membership_BasicAccess

--

--Stored Procedure rights for ReportingAccess

--

GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByUserId TO aspnet_Membership_ReportingAccess

GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByName TO aspnet_Membership_ReportingAccess

GRANT EXECUTE ON dbo.aspnet_Membership_GetUserByEmail TO aspnet_Membership_ReportingAccess

GRANT EXECUTE ON dbo.aspnet_Membership_GetAllUsers TO aspnet_Membership_ReportingAccess

GRANT EXECUTE ON dbo.aspnet_Membership_GetNumberOfUsersOnline TO aspnet_Membership_ReportingAccess

GRANT EXECUTE ON dbo.aspnet_Membership_FindUsersByName TO aspnet_Membership_ReportingAccess

GRANT EXECUTE ON dbo.aspnet_Membership_FindUsersByEmail TO aspnet_Membership_ReportingAccess

GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO aspnet_Membership_ReportingAccess

GRANT EXECUTE ON dbo.aspnet_RegisterSchemaVersion TO aspnet_Membership_ReportingAccess

GRANT EXECUTE ON dbo.aspnet_UnRegisterSchemaVersion TO aspnet_Membership_ReportingAccess

--

--Additional stored procedure rights for FullAccess

--

GRANT EXECUTE ON dbo.aspnet_Users_DeleteUser TO aspnet_Membership_FullAccess

GRANT EXECUTE ON dbo.aspnet_Membership_CreateUser TO aspnet_Membership_FullAccess

GRANT EXECUTE ON dbo.aspnet_Membership_SetPassword TO aspnet_Membership_FullAccess

GRANT EXECUTE ON dbo.aspnet_Membership_ResetPassword TO aspnet_Membership_FullAccess

GRANT EXECUTE ON dbo.aspnet_Membership_UpdateUser TO aspnet_Membership_FullAccess

GRANT EXECUTE ON dbo.aspnet_Membership_ChangePasswordQuestionAndAnswer TO aspnet_Membership_FullAccess

GRANT EXECUTE ON dbo.aspnet_Membership_UnlockUser TO aspnet_Membership_FullAccess

--

--View rights

--

GRANT SELECT ON dbo.vw_aspnet_Applications TO aspnet_Membership_ReportingAccess

GRANT SELECT ON dbo.vw_aspnet_Users TO aspnet_Membership_ReportingAccess

GRANT SELECT ON dbo.vw_aspnet_MembershipUsers TO aspnet_Membership_ReportingAccess

/*************************************************************/

/*************************************************************/

/*************************************************************/

/*************************************************************/

DECLARE @command nvarchar(4000)

SET @command = 'REVOKE EXECUTE ON [dbo].aspnet_RegisterSchemaVersion FROM ' + QUOTENAME(user)

EXECUTE (@command)

So at the moment I cannot install any new DNN sites on my server. Any advice on this greatly appreciated as always!