Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Not connecting to dnn server - Install and UpgradeNot connecting to dnn server - Install and Upgrade
Previous
 
Next
New Post
7/14/2018 7:42 PM
 
have you been able to create a SQL server login with DbOwner permission?

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
7/17/2018 1:25 AM
 
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
 
New Post
7/17/2018 1:25 AM
 
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
 
New Post
7/17/2018 1:26 AM
 
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
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Not connecting to dnn server - Install and UpgradeNot connecting to dnn server - Install and Upgrade


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out