Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

@DNC SQL Server Setup for Dragona (similar for ROM)

Junior Spellweaver
Joined
Jun 28, 2014
Messages
133
Reaction score
8
Thanks for Video Elssair.
But I can't connect. I typed 127.0.0.1 and Windows-Authentification but brings me error.
 
Skilled Illusionist
Joined
Dec 4, 2013
Messages
353
Reaction score
56
Thanks for Video Elssair.
But I can't connect. I typed 127.0.0.1 and Windows-Authentification but brings me error.

Watch the video and your *.ini files carefully, besides the server connection is not authenticated, is by username and pass
 
Junior Spellweaver
Joined
Jun 28, 2014
Messages
133
Reaction score
8
Ok will try.
But how does MS SQL Server knows my ROM Database? Is there any .exe i must start before connecting with SQL?

Ok maybe i explain. Start from scratch :):

I open SQL Server Management Studio.
What put in:
- Servername?
- Login-Name?
- Password?

Which of these .ini Files I need to change? PlayerCenter, Global,..
 
Last edited:
Skilled Illusionist
Joined
Dec 4, 2013
Messages
353
Reaction score
56
Ok will try.
But how does MS SQL Server knows my ROM Database? Is there any .exe i must start before connecting with SQL?

Ok maybe i explain. Start from scratch :):

I open SQL Server Management Studio.
What put in:
- Servername?
- Login-Name?
- Password?

Which of these .ini Files I need to change? PlayerCenter, Global,..

Sorry but explain it all from the beginning is very difficult, the vídeo is a base for setup, you have to use logic that God has given for you, much encouragement and you can see how you learn best.

Sorry my english it's to poor :)
 
Initiate Mage
Joined
Jul 9, 2014
Messages
51
Reaction score
3
When you first create your SQL installation, you are prompted to create a password. When you get your database all created, I used sa as the username and the password I created when asked during the install.

Also, when you first created your database, you should have created a name for it. Mine is ROMDB, so I have that and I select SQL Server Authentication and enter sa as the username then the password I created during install.

Perhaps you setup the initial SQL DB wrong? I used this video for the setup of my SQL. I stopped watching at 8minutes, since he goes into other stuff. But after 8minutes.

Hope this helps your SQL setup.

 
Junior Spellweaver
Joined
Jun 28, 2014
Messages
133
Reaction score
8
Thanks man Ochoaman!

Now I am a Step closer :)
Will try now to import the Databases



I start the RAServerMonitor and want to Start the Servers.
Now I'm getting this Error:

DBTransferClass Connect Error _Srv = 127.0.0.1 _DB=ROM_Account _LoginID =romuser
DBTransferClass Init Error!! Server=127.0.0.1 DB=ROM_Account LoginID=romuser

I set everything right in the .Ini and my Databases.
Any Idea?

Thanks
 
Experienced Elementalist
Joined
Nov 27, 2007
Messages
272
Reaction score
59
Thanks man Ochoaman!

Account _LoginID =romuser

U hawe the same login in file and on sql "romuser" ??


Acc_DBServer = ( you'r Computer name)
Acc_DataBase = ROM_Account (here nothig change)
Acc_Account = (you'r Sql login)
Acc_Password = (you'r encryption pass from sql ) U do this that tool RAPasswordEncode.
 
Last edited:
Junior Spellweaver
Joined
Jun 28, 2014
Messages
133
Reaction score
8
Oh sh*** I didn't know that ;-).
I use the default User Login "sa".
This Login-Name is to short to encrypt it with that tool.

Any Idea? Should I create a new SQL instance?



Ok, i created a new Login in my Database named "romuser".
So I put this User in the Password tool, and encrypted it.
Then I put this Password and "romuser" in the .ini Files.

Is there something wrong?

thanks
 
Experienced Elementalist
Joined
Nov 27, 2007
Messages
272
Reaction score
59
Oh sh*** I didn't know that ;-).
I use the default User Login "sa".
This Login-Name is to short to encrypt it with that tool.

Any Idea? Should I create a new SQL instance?



Ok, i created a new Login in my Database named "romuser".
So I put this User in the Password tool, and encrypted it.
Then I put this Password and "romuser" in the .ini Files.

Is there something wrong?

thanks


U must encrypt password not username...
 
Junior Spellweaver
Joined
Jun 28, 2014
Messages
133
Reaction score
8
Thanks so far.

Ok I think I made it a step further.
So now I get following messages when starting Servers:

- ControllerClientEvent::OnConnectFailed = Code1
- Census not find

I have Account, ServerList, Switch and Proxy online.
The others remaining in yellow "Starting"

Anybody knows whats wrong?
 
Initiate Mage
Joined
Oct 4, 2014
Messages
10
Reaction score
1
Elssair
where i can find windows service administrative tool for net start? im stuck : c
:dancemental:
 
Last edited:
Back
Top