I logged into a new account, just to make sure that it works. When i run the script
"UPDATE Users
SET IsSuperUser = 1
WHERE username = 'myUser'"
I am no longer able to login. If I change it back to False, I can log in again.
When it try to run the Add Host via SQL, i run this (I assume my problem is here)
DECLARE @ApplicationName nvarchar(256)
SET @ApplicationName = '0' DECLARE @UserName nvarchar(256)
SET @UserName = 'theHost' /*The new user*/ DECLARE @Password nvarchar(128)
SET @Password = '***************************' DECLARE @PasswordSalt nvarchar(128)
SET @PasswordSalt = '***************' DECLARE @Email nvarchar(256)
SET @Email = 'TestingAccount@test.com' /*You can set this to whatever you want*/ DECLARE @PasswordQuestion nvarchar(256)
SET @PasswordQuestion = '' DECLARE @PasswordAnswer nvarchar(128)
SET @PasswordAnswer = '' DECLARE @IsApproved bit
SET @IsApproved = 1 DECLARE @CurrentTimeUtc datetime
SET @CurrentTimeUtc = GETDATE() DECLARE @CreateDate datetime
SET @CreateDate = @CurrentTimeUtc DECLARE @UniqueEmail int
SET @UniqueEmail = 0 DECLARE @PasswordFormat int
SET @PasswordFormat = 2 DECLARE @UserId uniqueidentifier /*Make the stored procedure call*/ EXEC dbo.aspnet_Membership_CreateUser @ApplicationName,
@Username, @Password, @PasswordSalt, @email, @passwordquestion, @PasswordAnswer, @IsApproved, @CurrentTimeUtc, @CreateDate,
@UniqueEmail, @PasswordFormat, @UserId
/*Display the new user id*/ SELECT 'New User Account Id ', @userId
/*Insert the record into the DotNetNuke users table*/ INSERT
INTO users(Username, FirstName, LastName, IsSuperUser, Email, DisplayName, UpdatePassword)
VALUES (@Username, 'New', 'Account', 1,@Email, 'New Account', 0)
I get the error "invalid column name: DisplayName"