MS Sql Server / Unable to perform install ACCESS DENIED I need DBO access to my database.
Up until recently I have been able to Install and Update my windows hosting / DNN cms application.
At this point everything comes to a grinding halt and I have no dbo permission on the database I created for installation: "System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action." "-- --Create Membership roles -- IF ( NOT EXISTS ( SELECT name FROM sys.database_principals WHERE [type] = 'R' AND name = N'aspnet_Membership_FullAccess' ) ) CREATE ROLE aspnet_Membership_FullAccess" etc etc.
User account is same one I have to set up other DNN database. Permissions (CAS trust) set to full, File permissions for app pool are full. The issue is with database user/role.
Your 'akward winning' service techs do NOT support sql server... they hung up on me after I waited for an hour. on. hold. stupid. music.