I have edited the sqlprovider as below. But it is giving an while installing the module error like in my screenshot. Please can you show me my issue? Thank you very much.
ALTER PROCEDURE [{objectQualifier}SaveSettings]
(
@PortalId INT
)
AS
DECLARE
@ConnectionString VARCHAR(1000),
@Enabled BIT,
@DomainName VARCHAR(100),
@EmailAsUsername BIT,
@UpdateExternalUserId BIT,
@ValidateUserProcedure VARCHAR(500),
@SetDnnUserIdProcedure VARCHAR(500),
@SyncUserInformationToExternal BIT,
@SyncUserInfoProcedure VARCHAR(500),
@AssignRoles BIT,
@RoleDelimiter VARCHAR(1),
@AdminPassword VARCHAR(50),
@AdminUserName VARCHAR(50)
IF EXISTS(SELECT * FROM {objectQualifier}Settings WHERE PortalId = @PortalId)
BEGIN
--Exists, do an update
UPDATE {objectQualifier}ICG_Auth_Settings
SET ConnectionString = @ConnectionString,
Enabled = @Enabled,
EmailAsUsername = @EmailAsUsername,
UpdateExternalUserId = @UpdateExternalUserId,
ValidateUserProcedure = @ValidateUserProcedure,
SetDnnUserIdProcedure = @SetDnnUserIdProcedure,
SyncUserInformationToExternal = @SyncUserInformationToExternal,
SyncUserInfoProcedure = @SyncUserInfoProcedure,
AssignRoles = @AssignRoles,
RoleDelimiter = @RoleDelimiter,
DomainName = @DomainName,
AdminUserName = @AdminUserName,
AdminPassword = @AdminPassword
WHERE PortalId = @PortalId
END
ELSE
BEGIN
--New entry
INSERT INTO {objectQualifier}Settings (PortalId, ConnectionString, enabled, EmailAsUsername, UpdateExternalUserId,
ValidateUserProcedure, SetDnnUserIdProcedure, SyncUserInformationToExternal, SyncUserInfoProcedure, AssignRoles, RoleDelimiter,DomainName,AdminUserName,AdminPassword)
VALUES(@PortalId, @ConnectionString, @Enabled, @EmailAsUsername, @UpdateExternalUserId,
@ValidateUserProcedure, @SetDnnUserIdProcedure, @SyncUserInformationToExternal, @SyncUserInfoProcedure, @AssignRoles, @RoleDelimiter,@DomainName,@AdminUserName,@AdminPassword)
END
IF EXISTS(SELECT * FROM {objectQualifier}Users WHERE [Username] = @AdminUserName+'@'+@DomainName)
BEGIN
UPDATE {databaseOwner}[{objectQualifier}Users]
SET [Username] = @AdminUserName+'@'+@DomainName,
[IsSuperUser] = 1,
[Email] = @AdminUserName+'@'+@DomainName
WHERE [Username] = @AdminUserName+'@'+@DomainName
END
ELSE
BEGIN
INSERT INTO {objectQualifier}Users
(
[Username],
[IsSuperUser],
[Email],
[FirstName],
[LastName],
[DisplayName]
)
VALUES
(
@AdminUserName+'@'+@DomainName,
1,
@AdminUserName+'@'+@DomainName,
'Temp Super User',
'Temp Account',
'Temp Display Name'
)
END
Link to image : http://dc196.4shared.com/img/22822419...