|
|
|
|
have you been able to create a SQL server login with DbOwner permission?
|
|
|
|
| |
|
|
Joined: 7/2/2018
Posts: 6
|
|
|
Thanks for the follow up. I seem to be blocked because the DB is requesting elevated permission to the database (denoted below). I am not sure how to add that permission. This is occurring on each clean installation. Any suggestion would be greatly appreciated.
07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Folder Creation Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep File Creation Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep File Deletion Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Folder Deletion Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Checking IIS configuration 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Installing Database Script DotNetNuke.Schema 07/11/2018 23:35:49 [INFO] DotNetNuke.Services.Upgrade.Upgrade Start ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.SqlDataProvider 07/11/2018 23:37:56 [INFO] DotNetNuke.Services.Upgrade.Upgrade End ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.SqlDataProvider 07/11/2018 23:37:56 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Installing Database Script DotNetNuke.Data 07/11/2018 23:37:56 [INFO] DotNetNuke.Services.Upgrade.Upgrade Start ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.SqlDataProvider 07/11/2018 23:38:07 [INFO] DotNetNuke.Services.Upgrade.Upgrade End ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.SqlDataProvider 07/11/2018 23:38:07 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Installing Membership Database Scripts 07/11/2018 23:38:07 [INFO] DotNetNuke.Services.Upgrade.Upgrade Start InstallMemberRoleProvider 07/11/2018 23:38:12 [ERROR] DotNetNuke.Services.Upgrade.Upgrade System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action. User does not have permission to perform this action. User does not have permission to perform this action. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (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& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:2988e0cc-ff8e-4cde-aa71-596459bfb8d4 Error Number:15247,State:1,Class:16
/*************************************************************/ /*************************************************************/
-- --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
IF ( NOT EXISTS ( SELECT name FROM sys.database_principals WHERE [type] = 'R' AND name = N'aspnet_Membership_BasicAccess' ) ) CREATE ROLE aspnet_Membership_BasicAccess
IF ( NOT EXISTS ( SELECT name FROM sys.database_principals WHERE [type] = 'R' AND name = N'aspnet_Membership_ReportingAccess' ) ) CREATE ROLE aspnet_Membership_ReportingAccess
System.Data.SqlClient.SqlException (0x80131904): User or role 'aspnet_Membership_FullAccess' does not exist in this database. User or role 'aspnet_Membership_FullAccess' does not exist in this database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (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& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:2988e0cc-ff8e-4cde-aa71-596459bfb8d4 Error Number:15410,State:1,Class:11
EXEC sp_addrolemember N'aspnet_Membership_BasicAccess', N'aspnet_Membership_FullAccess' EXEC sp_addrolemember N'aspnet_Membership_ReportingAccess', N'aspnet_Membership_FullAccess'
System.Data.SqlClient.SqlException (0x80131904): 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 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 grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnEr
|
|
|
|
| |
|
|
Joined: 7/2/2018
Posts: 6
|
|
|
Thanks for the follow up. I seem to be blocked because the DB is requesting elevated permission to the database (denoted below). I am not sure how to add that permission. This is occurring on each clean installation. Any suggestion would be greatly appreciated.
07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Folder Creation Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep File Creation Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep File Deletion Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Folder Deletion Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Checking IIS configuration 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Installing Database Script DotNetNuke.Schema 07/11/2018 23:35:49 [INFO] DotNetNuke.Services.Upgrade.Upgrade Start ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.SqlDataProvider 07/11/2018 23:37:56 [INFO] DotNetNuke.Services.Upgrade.Upgrade End ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.SqlDataProvider 07/11/2018 23:37:56 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Installing Database Script DotNetNuke.Data 07/11/2018 23:37:56 [INFO] DotNetNuke.Services.Upgrade.Upgrade Start ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.SqlDataProvider 07/11/2018 23:38:07 [INFO] DotNetNuke.Services.Upgrade.Upgrade End ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.SqlDataProvider 07/11/2018 23:38:07 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Installing Membership Database Scripts 07/11/2018 23:38:07 [INFO] DotNetNuke.Services.Upgrade.Upgrade Start InstallMemberRoleProvider 07/11/2018 23:38:12 [ERROR] DotNetNuke.Services.Upgrade.Upgrade System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action. User does not have permission to perform this action. User does not have permission to perform this action. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (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& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:2988e0cc-ff8e-4cde-aa71-596459bfb8d4 Error Number:15247,State:1,Class:16
/*************************************************************/ /*************************************************************/
-- --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
IF ( NOT EXISTS ( SELECT name FROM sys.database_principals WHERE [type] = 'R' AND name = N'aspnet_Membership_BasicAccess' ) ) CREATE ROLE aspnet_Membership_BasicAccess
IF ( NOT EXISTS ( SELECT name FROM sys.database_principals WHERE [type] = 'R' AND name = N'aspnet_Membership_ReportingAccess' ) ) CREATE ROLE aspnet_Membership_ReportingAccess
System.Data.SqlClient.SqlException (0x80131904): User or role 'aspnet_Membership_FullAccess' does not exist in this database. User or role 'aspnet_Membership_FullAccess' does not exist in this database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (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& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:2988e0cc-ff8e-4cde-aa71-596459bfb8d4 Error Number:15410,State:1,Class:11
EXEC sp_addrolemember N'aspnet_Membership_BasicAccess', N'aspnet_Membership_FullAccess' EXEC sp_addrolemember N'aspnet_Membership_ReportingAccess', N'aspnet_Membership_FullAccess'
System.Data.SqlClient.SqlException (0x80131904): 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 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 grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnEr
|
|
|
|
| |
|
|
Joined: 7/2/2018
Posts: 6
|
|
|
07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Folder Creation Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep File Creation Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep File Deletion Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Folder Deletion Check 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Checking IIS configuration 07/11/2018 23:35:48 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Installing Database Script DotNetNuke.Schema 07/11/2018 23:35:49 [INFO] DotNetNuke.Services.Upgrade.Upgrade Start ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.SqlDataProvider 07/11/2018 23:37:56 [INFO] DotNetNuke.Services.Upgrade.Upgrade End ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.SqlDataProvider 07/11/2018 23:37:56 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Installing Database Script DotNetNuke.Data 07/11/2018 23:37:56 [INFO] DotNetNuke.Services.Upgrade.Upgrade Start ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.SqlDataProvider 07/11/2018 23:38:07 [INFO] DotNetNuke.Services.Upgrade.Upgrade End ExecuteScript:C:\_Business Information-Alphabed LLC\DNN Website Application\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.SqlDataProvider 07/11/2018 23:38:07 [INFO] DotNetNuke.Services.Upgrade.Internals.Steps.BaseInstallationStep Installing Membership Database Scripts 07/11/2018 23:38:07 [INFO] DotNetNuke.Services.Upgrade.Upgrade Start InstallMemberRoleProvider 07/11/2018 23:38:12 [ERROR] DotNetNuke.Services.Upgrade.Upgrade System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action. User does not have permission to perform this action. User does not have permission to perform this action. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (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& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:2988e0cc-ff8e-4cde-aa71-596459bfb8d4 Error Number:15247,State:1,Class:16
/*************************************************************/ /*************************************************************/
-- --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
IF ( NOT EXISTS ( SELECT name FROM sys.database_principals WHERE [type] = 'R' AND name = N'aspnet_Membership_BasicAccess' ) ) CREATE ROLE aspnet_Membership_BasicAccess
IF ( NOT EXISTS ( SELECT name FROM sys.database_principals WHERE [type] = 'R' AND name = N'aspnet_Membership_ReportingAccess' ) ) CREATE ROLE aspnet_Membership_ReportingAccess
System.Data.SqlClient.SqlException (0x80131904): User or role 'aspnet_Membership_FullAccess' does not exist in this database. User or role 'aspnet_Membership_FullAccess' does not exist in this database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (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& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:2988e0cc-ff8e-4cde-aa71-596459bfb8d4 Error Number:15410,State:1,Class:11
EXEC sp_addrolemember N'aspnet_Membership_BasicAccess', N'aspnet_Membership_FullAccess' EXEC sp_addrolemember N'aspnet_Membership_ReportingAccess', N'aspnet_Membership_FullAccess'
System.Data.SqlClient.SqlException (0x80131904): 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 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 grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnEr
|
|
|
|
| |