Server

07/08/2010 11:08 yahoo5000#1
hi i need help with server create , i am use tut and stuck on 4 step :


[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 ...
07/08/2010 12:15 Bullet2l#2
u already wrote the step what to do, just follow the step and run the command in query.
07/08/2010 12:22 yahoo5000#3
Quote:
Originally Posted by Bullet2l View Post
u already wrote the step what to do, just follow the step and run the command in query.
but what password need generate in MD5 generator ? and why i need them


and when i run command in query i got error :

(1 row(s) affected)

Server: Msg 2627, Level 14, State 1, Line 12
Violation of PRIMARY KEY constraint 'PK_USER_PROFILE'. Cannot insert duplicate key in object 'USER_PROFILE'.
The statement has been terminated.



what wrong ?
07/08/2010 14:45 Bullet2l#4
it means the info its already exist. I dun understand y u need this step for? I didn't have to do this step when I making my server.
07/08/2010 15:05 yahoo5000#5
Quote:
Originally Posted by Bullet2l View Post
it means the info its already exist. I dun understand y u need this step for? I didn't have to do this step when I making my server.
ok then i need dekaron cleant how i can make him ?
07/08/2010 15:27 Bullet2l#6
huh? what r you talking abt?
07/08/2010 15:43 yahoo5000#7
Quote:
Originally Posted by Bullet2l View Post
huh? what r you talking abt?
client :D
07/08/2010 15:49 Bullet2l#8
lol client? get it from other server. and if u talking abt making ur own server client, I can't help u, cos I dunno where to start, tats too many things. and sorry gotta No tat much of time, so use search and learn urs elf.
07/08/2010 16:12 yahoo5000#9
can you tell me why i can send PM ?