How to create Database acces accounts

08/17/2012 16:35 Bashment#1
Hi guys. I couldn't see anywhere saying what is the procedure for creating a database acces accounts.. Couldnt find it anywhere and would be really nice if you can help me. I'm sorry if there is already such topic but i couldnt find it.

Cheers
08/17/2012 16:51 [S]DipNot#2
PSUserData > Tables > dbo.UsersMaster ( right click ) > Open Table

UserUID : 1 ( or u want number )
UserID : admin ( your game login id )
Pw : ***** ( your game login pw )
JoinDate : 17/08/2012
Admin : True ( is Admin ) - False ( is Normal Player )
Status : for Admin : 16 - for normal Player : 0
Leave : 0
LeaveDate : Null
UserType : for Admin : A - For Nrml Plyr : N
User IP : Your IP Adress

and No Need Edit You Other Field.
08/17/2012 17:10 heavens007#3
okay um i need to make a new sql login. like i got the account name and the password i wanna use. it goes fine with windows authentication but it wont let me use the account for sql authentication sooo how do i make a new sql authentication login?
08/17/2012 17:41 [ADM]Speedy#4
open ur DB , go in "security" , right click logins , new login , write login name and pass and TADA :)! u need to press ok though
08/17/2012 17:47 Bashment#5
Thank you guys for the answers.
08/17/2012 20:15 TeddyBear94#6
Quote:
Originally Posted by [S]DipNot View Post
PSUserData > Tables > dbo.UsersMaster ( right click ) > Open Table

UserUID : 1 ( or u want number )
UserID : admin ( your game login id )
Pw : ***** ( your game login pw )
JoinDate : 17/08/2012
Admin : True ( is Admin ) - False ( is Normal Player )
Status : for Admin : 16 - for normal Player : 0
Leave : 0
LeaveDate : Null
UserType : for Admin : A - For Nrml Plyr : N
User IP : Your IP Adress

and No Need Edit You Other Field.
that is to make a an GM/ADM account ingame ... u wont be able to connect with that to database lol
08/17/2012 20:20 [S]DipNot#7
lol Me is Connect. and Fully Work. and " Thansked by Bashment " . Problem is Fixed.
08/18/2012 05:33 JohnHeatz#8
Before more non needed posts are made...

#Closed