cancel
Showing results for 
Search instead for 
Did you mean: 

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.

tldr: How do I get dbo access to my database?