[Step 4: Adding Accounts]
* 1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager)
* 2. Go To Tools -> SQL Query Analyzer (Login With Your "sa" Password)
* 3. Go To md5 Hash Generator And Generate A Hashed Password And Define It Below.
Code:
Use account;
Go
---Account Query By Warmonger---
DECLARE @UserNO varchar(16), @AccountID varchar(16), @Password varchar(16), @PasswordH varchar(32), @Email varchar(50), @SecretA varchar(22), @SecretQ varchar(22)
SET @UserNO= '09101410275532'
SET @AccountID = 'Account ID'
SET @Password = 'Account Password'
SET @PasswordH = 'Account Password Hashed'
SET @Email = 'E-Mail'
SET @SecretA = 'Secret Answer'
SET @SecretQ = 'Secret Question'
Insert Into [TBL_USER] Values (@UserNO, @AccountID, @Password, @Email, @SecretA, @SecretQ)
Insert Into [USER_PROFILE] Values (@UserNO,@AccountID,@PasswordH,'801011000000','1', '0','Y','01/01/2006 00:00:00',null,null,null,'000')
I dont know that i need to do on this step somoone help me with this
and if you know how create client show me too ...
